Rechercher tracteur tondeuse
-500kgqu'à l'achat
4x moins cher qu'en magasin
Description
Bonjour, nous recherchons une tondeuse autoportée pour le week-end du 22 mai sur vieux berquin SVP #tracteur tondeuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Vieux-Berquin (59232) · publié depuis 3 mois ou +
Discuter
Prix
70€/jour
-500kgqu'à l'achat
4x moins cher qu'en magasin
Bonjour, nous recherchons une tondeuse autoportée pour le week-end du 22 mai sur vieux berquin SVP #tracteur tondeuse
Annonces similaires
Tout voirLouer un tracteur tondeuse entre particuliers ou proposer un tracteur tondeuse en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='356264'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tracteur-tondeuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='8'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tracteur-tondeuse' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='88'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('59' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='163478' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 163478
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 356264
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=8 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 163478 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='356264'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='356264' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=163478 LIMIT 1
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 163478 AND W.type_id = 1) OR (W.util_id <> 163478 AND W.type_id = 2)) AND (M.post_util_id = 163478 OR M.dest_util_id = 163478) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='163478' AND note_visu IN (1,3,4)
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '356264'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='163478' AND wish_id<>'356264' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59232'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.7*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.63333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.250339197041 AND ville_latitude_deg<51.149660802959 AND ville_longitude_deg>1.9233852598863 AND ville_longitude_deg<3.3432747401137 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN ('59232','59270','59270','59190','59190','59270','59270','59190','59940','59940','59190','59660','59270','59190','59253','62350','59114','59270','59940','59114','62136','62350','59270','62350','59181','62840','62350','59190','59270','59190','59189','59114','62840','59299','62350','59670','08951','59173','59189','59114','08958','62350','08954','59189','62136','59670','59190','62330','59850','62136','08950','62232','59670','62400','62840','59670','62350','59173','59193','62136','62920','08950','62330','59670','08970','59173','08956','59670','62840','08952','62920','59173','62400','62120','59670','59670','62190','07782','08978','07783','59280','59670','59249','62120','62149','62190','62840','08970','59280','62400','62232','62232','62120','59930','62120','59249','62920','59173','08900','59670','62190','59670','62120','59134','59116','08957','62120','08953','62120','62232','62190','59480','59470','62232','62660','62199','62157','62120','59670','62122','62120','62120','62149','08972','59236','62120','62120','59285','59134','62190','62120','62138','08902','59470','62122','08908','59470','62120','62120','59134','59480','62151','62149','59320','59134','62131','62131','62196','62113','62120','62540','59890','62190','62190','62113','62113','07784','59134','62145','62131','62138','62149','59470','59840','59560','62120','59320','59320','59496','62149','59274','59470','59320','62138','62540','59840','59285','07784','62120','08900','62620','62120','59160','08972','59122','62290','08972','08906','08902','08900','62500','59320','62575','59470','08640','62260','62138','59496','62980','59285','59136','59320','62510','62129','59211','62700','62980','59184','62190','62260','07781','08902','62129','62260','62260','08640','62145','59380','59890','62575','59237','08640','59272','62960','62960','59840','62620','62940','62138','62550','59143','62470','62550','59320','62670','62550','08900','59470','07780','07780','62470','08904','59122','08691','59221','62550','62570','08640','59320','59470','62129','62550','62410','08980','62145','62500','59380','62460','59470','62550','62620','62530','59143','62145','62410','08904','59560','62129','62114','62620','59470','59112','59320','62570','62410','62219','59380','59380','62550','62410','59185','59120','62160','62150','62500','59130','59147','62150','62960','59251','62500','59143','62550','59350','62570','62570','59118','08980','08647','62460','62750','62150','62960','59147','59263','59470','62550','62129','08940','62960','59139','59122','08920','59380','62550','62160','59117','08691','62219','59520','62880','59143','59470','08691','08647','59147','08647','08647','62500','59110','08920','62150','59112','62550','59380','08920','08690','62880','62880','62500','08980','59777','59000','59800','59160','59350','59630','62530','62134','62172','62150','08691','62380','59122','59143','62150','62550','62160','62960','59126','59223','59250','62129','59700','59133','08650','62150','08980','59139','62380','08647','62460','62910','59166','62143','62380','08691','62880','62550','59113','62960','59380','59143','62300','59380','59910','62800','59380','59175','62910','62530','62500','62380','59155','08920','62150','08690','59380','62690','59284','08940','62440','62560','62220','62150','62960','59133','62221','62218','59175','59492','59370','62300','62380','62134','62127','62500','62130','08630','62127','62910','59143','59790','62560','62710','62550','62134','62134','62560','08630','62550','08630','08690','08980','59420','62380','62690','59630','62380','62380','08600','59260','62690','62500','62144','62430','62380','62690','59122','62153','62740','62130','59551','62910','62590','59650','59491','59493','59655','62910','08930','62310','62153','62210','62820','62127','08690','62134','59200','62640','62580','59810','08890','59170','59290','59630','62134','59380','62420','59229','59710','62310','59960','59239','62134','08890','62310','62130','08600','08840','62690','59380','59630','59261','62144','62560','62560','62680','62130','59380','62690','08600','62134','59100','62560','62310','62690','62130','59229','08600','62500','62110','62910','59239','08630','08650','08650','08600','08630','62134','62127','62380','08930','62127','62119','59630','62370','08880','62380','59551','62134','62310','59180','59495','62130','62890','62690','62144','62690','62690','62310','62690','62310','62310','59273','62890','08560','62144','62560','62127','62580','62690','62134','62320','08630','59510','59254','62690','59162','08630','59710','59262','59710','62310','08630','62320','62380','08840','62890','08600','62950','62130','62580','08560','08600','59510','62380','62560','62127','08600','08930','59273','62134','62320','62320','59210','62580','08840','08880','07700','62580','59710','62310','62144','62890','62130','59279','59830','62130','08600','62141','62310','62127','62370','62580','62130','59390','59150','62130','07712','08600','59246','62690','59630','59390','08630','62134','62580','62127','62890','62380','59152','59152','62970','62134','08630','62370','08660','62130','62310','62134','62580','59123','62223','59242','62310','62560','59390','08610','62127','62560','59152','59283','62130','62380','62130','62380','62380','59390','59152','62790','07700','62310','62130','62580','62690','59242','62890','08511','62310','62161','62161','59780','59760','59279','08600','62890','62130','59950','59279','59640','59430','59140','59240','62370','62690','08880','08560','62130','62490','59830','08600','08610','59123','62223','59283','59115','62580','62380','62127','62370','59235','62310','08600','59830','62580','59310','62310','08510','62223','08800','62127','08600','08800','08501','08630','62130','59820','62127','62130','08660','62890','62580','62123','62130','59128','62123','62123','08610','62161','62123','62127','62490','62380','08830','62161','07730','62310','08670','59286','07730','62560','62810','59780','07730','62130','62850','08510','62310','59242','08501','62130','62810','62127','59780','62650','62223','62810','59830','62130','08800','62162','62223','62770','08680','62610','08600','59553','59553','62490','59553','62890','62380','59830','62370','07520','62223','07730','62770','62850','62380','62130','08510','08830','08670','08670','62123','62770','08620','62810','08610','62650','62162','62130','08500','62890','62130','62223','62810','59310','62310','62000','62650','62270','62370','62810','62610','08800','62770','62270','59830','07711','62850','62130','62130','62130','08870','07522','08870','62850','08860','62810','62130','59194','62130','62130','62000','07730','59820','62650','62490','59830','62310','07522','62810','62118','62270','07730','08433','08600','62610','59500','62130','62810','07522','62270','62123','62123','62770','62770','62123','62810','62810','07730','62118','62370','08620','62770','08520','62610','62610','62310','59310','08870','62118','62650','62223','59552','59310','08620','62117','59119','62770','62217','62217','08433','62810','62240','59552','62650','59148','62217','62240','07502','08510','62850','59194','62270','07522','62240','07740','59310','62140','08680','59153','62610','62310','62118','62270','62270','62850','07520','62217','62650','62810') AND fami_id='5' AND cate_id='88' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='8' AND wish_id<>'356264' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=441763 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 441763 AND W.type_id = 1) OR (W.util_id <> 441763 AND W.type_id = 2)) AND (M.post_util_id = 441763 OR M.dest_util_id = 441763) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 441763
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=437931 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 437931 AND W.type_id = 1) OR (W.util_id <> 437931 AND W.type_id = 2)) AND (M.post_util_id = 437931 OR M.dest_util_id = 437931) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 437931
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=425032 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 425032 AND W.type_id = 1) OR (W.util_id <> 425032 AND W.type_id = 2)) AND (M.post_util_id = 425032 OR M.dest_util_id = 425032) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 425032
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=331479 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 331479 AND W.type_id = 1) OR (W.util_id <> 331479 AND W.type_id = 2)) AND (M.post_util_id = 331479 OR M.dest_util_id = 331479) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 331479
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=192989 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 192989 AND W.type_id = 1) OR (W.util_id <> 192989 AND W.type_id = 2)) AND (M.post_util_id = 192989 OR M.dest_util_id = 192989) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 192989
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=181156 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 181156 AND W.type_id = 1) OR (W.util_id <> 181156 AND W.type_id = 2)) AND (M.post_util_id = 181156 OR M.dest_util_id = 181156) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 181156
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=168238 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 168238 AND W.type_id = 1) OR (W.util_id <> 168238 AND W.type_id = 2)) AND (M.post_util_id = 168238 OR M.dest_util_id = 168238) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 168238
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=158418 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 158418 AND W.type_id = 1) OR (W.util_id <> 158418 AND W.type_id = 2)) AND (M.post_util_id = 158418 OR M.dest_util_id = 158418) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 158418
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=87665 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87665 AND W.type_id = 1) OR (W.util_id <> 87665 AND W.type_id = 2)) AND (M.post_util_id = 87665 OR M.dest_util_id = 87665) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 87665
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous