-150kg
qu'à l'achat
3x moins cher qu'en magasin
Description de l'annonce
Recherche broyeur de branches pour 1 journée
#Broyeur a vegetaux
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-150kg
qu'à l'achat
3x moins cher qu'en magasin
Recherche broyeur de branches pour 1 journée
#Broyeur a vegetaux
Louer un broyeur a vegetaux entre particuliers ou proposer un broyeur a vegetaux en location.
Poster une annonce
-150kg
qu'à l'achat
3x moins cher qu'en magasin
Envoyer 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, filtre_villes, dpt_url 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='282925'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='broyeur-a-vegetaux' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='24'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'broyeur-a-vegetaux' 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('02' 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='71202' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 71202
SELECT util_cp FROM utilisateur WHERE util_id=71202 LIMIT 1
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 = 282925
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=24 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 71202 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='282925'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='282925' 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=71202 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=71202 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 = 71202 AND W.type_id = 1) OR (W.util_id <> 71202 AND W.type_id = 2)) AND (M.post_util_id = 71202 OR M.dest_util_id = 71202) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '282925'
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='71202' AND wish_id<>'282925' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='02640'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.16667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.300339197041 AND ville_latitude_deg<50.199660802959 AND ville_longitude_deg>2.4707270646224 AND ville_longitude_deg<3.8626129353776 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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('02640','02640','02480','02480','02480','02480','02480','02480','02590','02480','02520','02480','02440','02590','02590','02790','02480','02590','02590','02590','02300','02480','80400','02680','02440','80400','02680','02680','80400','02590','02300','02590','02590','60640','80400','02690','80400','02440','02440','02590','02590','02680','02680','60640','02700','02440','02300','80400','02440','80400','02430','02440','60640','02590','02700','80400','02490','60640','02700','02300','02690','80400','80400','02300','60640','02240','02760','02300','02490','80400','80400','80400','02760','80400','02800','02490','02490','60640','80200','02100','60640','02100','02100','60640','80400','80190','02100','02300','02240','02240','02610','80190','02700','80200','80400','02240','02300','02300','02300','02490','02800','60640','02300','02240','80190','60640','02100','80240','02300','80190','02240','02100','80190','80190','80400','02720','60640','60640','02800','80190','02800','02300','02300','02300','02100','02240','80190','80240','80200','60640','02700','02490','02800','02240','80400','80200','02800','02490','80200','80930','80400','60400','80240','02300','80190','80190','02240','80200','80240','02720','80200','02100','60400','80190','60400','02700','02490','60640','80190','60400','60400','02300','60400','02800','02800','02720','02300','80190','02700','02800','02240','02420','60400','80190','02700','02240','80200','80200','02420','60400','80190','02490','02300','02490','02240','02300','80240','02100','02100','60310','02800','60640','80200','60400','80240','80190','02240','60400','80320','60310','60310','02300','60400','80200','60400','02800','80240','80190','80700','80700','02800','80700','80190','80200','02100','80240','02420','60400','02420','60400','60310','02800','02800','02300','02240','02420','02700','80320','80240','02420','80320','02390','60310','02800','80190','02410','02420','80200','02420','80200','80200','60310','02800','60400','02270','80200','80200','02110','60400','60400','02420','02110','60400','02670','80700','80700','80700','02300','80240','02110','02300','02420','02240','80320','02390','60310','60400','60400','02410','02390','80320','80320','60400','02270','80700','02670','80200','02110','60400','80320','80700','80700','02300','80200','02110','60310','80700','02110','80240','60400','80320','02240','02420','80240','80240','02410','02390','80200','80200','02420','80740','02300','02300','80200','02420','02380','80200','80112','02300','80240','02380','60310','80320','80320','60310','80700','60400','02300','02380','80700','80200','80200','60400','60400','02120','02870','80320','02270','02110','02270','60310','80700','02240','80700','60138','02320','80740','02300','02380','60310','60170','02270','02870','02110','02120','80200','80240','02420','02230','02110','02420','02380','80700','02270','02110','80700','02270','60310','80170','80700','80240','02380','02380','80200','80200','60310','80200','60310','60310','60310','02110','80760','80320','80320','02270','02300','02870','80240','02420','80170','80700','80170','60400','80700','80200','02270','80200','80700','80122','60170','02380','60310','80200','02320','80700','02320','80700','02270','02320','60310','02120','02870','80980','60170','02380','80340','02290','59297','80200','80240','60170','02380','02320','80170','80700','80200','02110','02110','02290','80340','59266','60170','02120','02380','02290','80340','02120','02870','02420','80340','02270','02320','02870','80170','60310','80700','02270','80360','80700','02290','80700','80700','02270','59142','02110','02110','80360','80700','02000','80170','02120','60310','02110','02110','80360','02000','60350','59231','02290','59266','60170','59231','60350','80700','60170','02320','60170','80360','02320','80360','02290','80340','80340','60310','02870','02120','02270','02320','60490','02000','80910','80170','80360','80131','80700','80700','60157','02000','80170','02270','59127','59127','02880','80360','80340','60150','80360','80340','80131','59266','02290','60150','60490','02000','02000','60490','02000','02290','60350','80500','62124','80170','02270','62124','80170','60150','60150','80500','60150','02320','80360','02000','02120','02120','80360','60490','60490','80340','62124','59127','02880','80500','02000','60490','02120','02880','02000','80360','02630','02000','80121','80360','02000','02270','02110','60150','62124','02000','02290','60490','80500','02000','02270','02290','59231','02290','80910','62124','02880','60490','02880','59258','02120','59127','60350','62147','02200','02320','80500','02270','80131','02120','60170','02000','02630','80170','80500','62450','59238','60490','02880','60350','02880','02880','80360','62450','80360','59137','80340','80340','02120','60150','02120','02000','02200','02270','60490','60490','02000','02250','02880','02000','62124','60350','02880','60490','02110','02110','02320','80500','02000','60490','62124','02120','02120','02880','02270','80300','02290','59159','02290','60162','02000','62124','59258','80360','80118','80340','80300','59258','02200','62450','02000','02250','02250','02250','60150','59191','60150','80170','02120','80500','80340','80500','60350','02200','80360','80340','60153','02510','60490','60150','60150','59127','60350','80170','60490','80500','59980','59980','02120','62124','59225','80134','60750','02880','60350','02250','80300','02290','02290','59159','80500','60162','59267','59241','80170','80360','02200','59191','80500','60200','60200','02000','02840','62450','62147','02880','02510','02110','62450','60490','02880','80720','60113','02000','02250','02250','80800','62124','60350','02880','02860','80500','60350','60350','02200','80800','80360','02120','59191','02350','02860','62147','02000','02880','80110','80110','02510','62450','59980','80500','59400','02840','02110','59360','62147','80300','62450','80300','80500','02250','02290','02860','59281','62124','59225','02200','02290','80300','02630','02200','80800','02250','02370','59159','62124','59360','60350','02120','80300','02510','60280','80500','02880','02860','59980','60113','60113','02000','02370','59400','02200','02140','62450','02860','02120','02120','02120','62147','02370','80720','60420','02140','62124','80110','62450','62147','60350','60200','02450','02450','80300','80810','59400','59217','02200','02200','60490','60420','02860','80110','59980','80500','80500','80720','02600','59267','02600','60420','80500','59400','02140','62450','80800','62450','02450','02110','02840','02370','59400','80110','80500','59157','62450','62450','62147','80300','59360','02880','80300','02860','80110','59400','80300','02350','62124','59157','02860','02200','02200','60190','60350','02250','02250','02370','60200','80800','62450','59540','59360','02140','80110','80500','62450','80500','60190','02350','60190','02860','80800','02120','60350','02200','02140','80500','02250','60420','80300','60190','59540','02140','80300','62159','59540','60420','80500','62450','02350','80300','80500','59400','02600','02860','02840','59267','60350','02840','80500','02600','80300','02450','62860','59400','02140','62450','02860','60420','59540','02200','59217','02140','80110','80110','02140','02120','02860','02600','02140','62860','62159','59217','80300','80110','02220','59400','02350','02200','02370','80300','02350','02840','02200','02860','80300','80300','02370','59360','02140','02220','62860','60190','62450','02860','60190','60190','02200','02000','02250','80800','80800','60350','02200','80500','60420','59217','02200','02200','02600','60190','02600','80300','02860','60420','02450','80800','60420','02860','02120','80380','59554','80113','60420','02370','02220','02160','02350','80250','80500','60420','60420','59360','02840','02200','02140','80500','62121','62121','02260','02220','02450','80800','80300','59360','02260','02860','80300','59554','59161','80110','80110','02140','02600','62121','59360','80300','02170','02140','80110','02250','02170','80300','02840','02600','59271','59360','02260','02350','80110','60420','62128','59214','80250','02860','59554','80300','59360','80300','60680','62159','62860','60880','60880','02200','02220','02220') 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='24' AND wish_id<>'282925' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=408959 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 = 408959 AND W.type_id = 1) OR (W.util_id <> 408959 AND W.type_id = 2)) AND (M.post_util_id = 408959 OR M.dest_util_id = 408959) 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 = 408959
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=418931 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 = 418931 AND W.type_id = 1) OR (W.util_id <> 418931 AND W.type_id = 2)) AND (M.post_util_id = 418931 OR M.dest_util_id = 418931) 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 = 418931
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415186 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 = 415186 AND W.type_id = 1) OR (W.util_id <> 415186 AND W.type_id = 2)) AND (M.post_util_id = 415186 OR M.dest_util_id = 415186) 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 = 415186
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411737 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 = 411737 AND W.type_id = 1) OR (W.util_id <> 411737 AND W.type_id = 2)) AND (M.post_util_id = 411737 OR M.dest_util_id = 411737) 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 = 411737
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=410862 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 = 410862 AND W.type_id = 1) OR (W.util_id <> 410862 AND W.type_id = 2)) AND (M.post_util_id = 410862 OR M.dest_util_id = 410862) 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 = 410862
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=398551 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 = 398551 AND W.type_id = 1) OR (W.util_id <> 398551 AND W.type_id = 2)) AND (M.post_util_id = 398551 OR M.dest_util_id = 398551) 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 = 398551
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=241629 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 = 241629 AND W.type_id = 1) OR (W.util_id <> 241629 AND W.type_id = 2)) AND (M.post_util_id = 241629 OR M.dest_util_id = 241629) 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 = 241629
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220627 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 = 220627 AND W.type_id = 1) OR (W.util_id <> 220627 AND W.type_id = 2)) AND (M.post_util_id = 220627 OR M.dest_util_id = 220627) 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 = 220627
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=195973 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 = 195973 AND W.type_id = 1) OR (W.util_id <> 195973 AND W.type_id = 2)) AND (M.post_util_id = 195973 OR M.dest_util_id = 195973) 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 = 195973
SELECT ssrubr_slug, ssrubr_title, 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='24' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=10823 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 = 10823 AND W.type_id = 1) OR (W.util_id <> 10823 AND W.type_id = 2)) AND (M.post_util_id = 10823 OR M.dest_util_id = 10823) 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 = 10823
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 WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous