-150kg
qu'à l'achat
5x moins cher qu'en magasin
Description de l'annonce
Location à la journée ou demi journée
#Broyeur a vegetaux
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-150kg
qu'à l'achat
5x moins cher qu'en magasin
Location à la journée ou demi 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
5x 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='557966'
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('78' 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='414419' 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` = 414419
SELECT util_cp FROM utilisateur WHERE util_id=414419 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 = 557966
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=24 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 414419 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='557966'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='557966' 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=414419 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=414419 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 = 414419 AND W.type_id = 1) OR (W.util_id <> 414419 AND W.type_id = 2)) AND (M.post_util_id = 414419 OR M.dest_util_id = 414419) 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 = '557966'
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='414419' AND wish_id<>'557966' 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 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='4' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 414419
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78112'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.3828668758251 AND ville_longitude_deg<2.7504731241749 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 ('78112','78750','78620','78160','78100','78240','78230','78560','78590','78870','78240','78110','78430','78860','78290','78380','78590','78300','78400','78450','78150','78450','78630','78360','78170','78600','78330','78810','78150','78955','78670','78670','78210','78260','78420','78340','78600','92430','92420','92380','78121','92500','78810','92000','78390','78800','78000','78540','78570','92410','78630','78370','78500','78570','78700','78580','78850','78220','92210','78510','78190','92310','95870','92800','92150','95530','78140','78480','78280','78780','78180','78920','78640','78130','92370','78580','92250','92400','78350','78530','92700','95370','78990','78640','92100','78124','92200','78124','95240','95000','78960','78350','95220','95280','95610','92270','78650','78117','92190','92360','78410','95100','78640','95000','78580','92300','95180','78580','95110','92600','78640','92130','95130','78760','78740','95480','78114','95000','78470','78126','95490','78117','78130','78310','78470','78740','78320','92110','78410','92140','95800','95250','78250','95130','92230','78650','92170','78320','91400','78770','95210','95218','78410','95120','92320','78770','78490','92350','78250','78310','91570','78410','78410','78490','92240','95300','95450','91190','95650','95310','78250','78770','93800','91190','78250','91430','78490','78490','92260','92330','92220','92290','93400','78770','78680','92120','78770','95150','95550','91430','95320','78690','92390','93450','78250','95230','95520','78320','95450','78460','78470','78820','95600','95880','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','95650','95300','78770','95390','91370','78720','78490','94250','78720','78580','78490','78490','95580','95580','95740','78970','78490','94110','91440','95430','95680','93430','92340','78770','93200','93210','91400','95450','78690','78930','95650','91470','78440','95170','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','78460','95540','95450','78930','78490','92160','95360','95650','95650','91940','91190','95840','91120','78250','91300','95450','78720','94270','95160','93120','93300','95410','91940','94260','95560','95840','78440','93380','78940','94800','91470','95300','95450','95430','95630','93240','78890','94200','94205','91400','78440','93310','78610','91140','78440','78440','78790','78790','93500','94550','95300','78490','78910','78930','78910','95450','91160','78440','78720','95450','91940','95570','95450','91140','78440','95350','95350','94150','78790','78440','95330','78910','93170','91320','78610','95810','91470','91470','95760','78940','93350','94160','95830','95830','95400','95200','94320','95560','95450','91380','91160','78930','91160','93440','91640','94220','78520','94400','93260','93230','95570','93100','94300','78930','78200','78711','95140','94140','95590','78440','95560','78930','78930','78910','78610','95440','95460','78125','95450','95570','95810','78200','95400','95810','93000','78790','78910','95450','95620','95450','91420','78790','95500','94700','95690','78440','78490','94310','94390','93700','93150','78910','95450','95290','91620','78440','94600','78610','91550','95560','91160','95510','95640','95640','95690','78720','93130','78790','93140','78200','78200','95420','78520','94410','95810','78830','91470','95810','91620','95640','91640','95640','78830','95500','78200','94340','91360','95640','91640','95690','91460','78790','95720','93110','95690','94290','95720','95720','91200','78550','94120','95510','95660','78200','94130','91360','95590','78120','91700','95570','78200','94000','78200','95260','91310','91310','78520','94480','93250','91640','78790','78910','95510','95720','95420','95420','95270','78550','91390','91600','78200','95640','94170','95500','95420','95450','95260','91310','78950','95270','95640','91680','78125','91260','78120','78200','95750','91310','95590','91240','94190','91270','95190','78113','94460','78111','93320','93340','78910','93360','95750','91680','94100','94210','94340','95340','95500','94380','95420','78200','78980','95340','91470','95810','95640','94360','91170','95810','91530','95190','95780','95850','91560','78113','60240','93600','94500','95270','78730','78730','95270','91210','91700','93220','78710','78550','94430','95510','60230','91180','93330','93270','78550','95190','95420','95270','91230','94450','91350','91220','91220','78200','78520','91520','91340','91530','60119','95420','91410','95700','93420','78790','95270','78550','60119','60110','78125','91700','60240','78980','93190','93390','78910','95270','78840','78270','78113','95850','95510','78270','95380','94350','95340','78550','60240','78790','78120','91650','91290','78270','94470','95420','95420','91650','95820','95270','91290','91000','91130','78200','60240','78730','94370','94380','91650','93370','95380','93460','95780','91330','93160','95420','60240','60540','60540','60530','95270','95270','93410','94490','94880','94880','91530','60119','95270','28410','94420','60240','60240','91070','91630','60820','91800','95420','78125','60110','78113','78980','95270','77181','93470','28560','28260','78125','78125','60530','93290','91630','95710','91450','60240','60540','95420','28410','78125','91080','95780','91790','95670','78113','78840','95380','95510','95470','28410','94440','78125','60175','91530','60173','91410','77500','60540','78730','28260','78270','95380','91410','60530','94440','91630','28560','77420','60110','78125','78980','78980','91580','94510','91090','91000','78980','91630','91860','78113','60240','91910','91730','95380','91630','95710','60260','27630','28410','78730','78270','60240','60530','28260','77181','91450','60240','60540','77340','77270','28410','77185','91090','27620','78270','91730','91800','28230','78125','60110','94520','94520','77184','91580','94440','60530','95710','78270','77990','95420','60530','78125','28230','60240','60570','77177','60460','91810','28260','60580','77186','60240','78270','77990','60240','77290','27620','95470','28210','91480','28210','28210','60270','27640','77170','78270','91250','91730','28410','78980','60240','60530','28410','91250','60149','28260','78270','60790','77360','95470','91480','95470','60240','91410','78660','77410','77200','28260','91540','28410','60240','28210','60560','91710','78270','91580','60460','91510','91510','91280','91410','60570','95770','91770','77150','91100','77680','60240','91580','27630','28210','77380','27540','28130','91100','28260','27620','60520','77230','78660','60240','28260','60240','91850','77230','27630','78660','77090','77183','27630','91540','91540','60730','60340','28130','28320','91540','60730','60790','78270','91410','60110','77230','27630','28410','60240','60240','60240','77150','60240','91250','60128','28500','77410','95770','95770','60340','77127','60240','77400','78270','77400','28500','91760','60240','77600','60240','27730','60730','27120','77290','27420','60500','77330','28320','28210','78660','77170','60520','91580','91610','77230','91870','60790','77400','60240','27630','27720','60740','27780','78270','28260','77600','77600','60790','28700','60500','91410','60430','60790','60240','60570','27620','60128','77410','28210','28210','28700','28210','28210','28130','27640','60730','77410','77164','77135','27630','28320','91750','60240','60240','91410','27120','91590','91250','91830','60660','77400','77400','77230','27530','77400','77410','60590','27630','77410','28570','28260','77173','77600','27730','60240','60660','60660','60520','28210','27200','77230','60250','60240','78660','91150','60240','60730','91580','60790','28130','78660','91150','28500','60660','60660','28130','28500','77230','27420','27720','60160','77166','77400','27120','27750','78660','28320','27510','91410','60590','27420','60300','60300','91590','27140','27730','77410','77550','91590','28700','27120','77230','91150','27120','77166','28130','77600','60590','27870','91830','28320','91750','28500','77176','27640','28130','77230','28700','91590','27120','28500') 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<>'557966' 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=134541 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 = 134541 AND W.type_id = 1) OR (W.util_id <> 134541 AND W.type_id = 2)) AND (M.post_util_id = 134541 OR M.dest_util_id = 134541) 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 = 134541
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=471505 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 = 471505 AND W.type_id = 1) OR (W.util_id <> 471505 AND W.type_id = 2)) AND (M.post_util_id = 471505 OR M.dest_util_id = 471505) 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 = 471505
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=470713 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 = 470713 AND W.type_id = 1) OR (W.util_id <> 470713 AND W.type_id = 2)) AND (M.post_util_id = 470713 OR M.dest_util_id = 470713) 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 = 470713
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=466826 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 = 466826 AND W.type_id = 1) OR (W.util_id <> 466826 AND W.type_id = 2)) AND (M.post_util_id = 466826 OR M.dest_util_id = 466826) 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 = 466826
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=432459 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 = 432459 AND W.type_id = 1) OR (W.util_id <> 432459 AND W.type_id = 2)) AND (M.post_util_id = 432459 OR M.dest_util_id = 432459) 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 = 432459
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=428379 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 = 428379 AND W.type_id = 1) OR (W.util_id <> 428379 AND W.type_id = 2)) AND (M.post_util_id = 428379 OR M.dest_util_id = 428379) 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 = 428379
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=423444 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 = 423444 AND W.type_id = 1) OR (W.util_id <> 423444 AND W.type_id = 2)) AND (M.post_util_id = 423444 OR M.dest_util_id = 423444) 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 = 423444
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=401935 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 = 401935 AND W.type_id = 1) OR (W.util_id <> 401935 AND W.type_id = 2)) AND (M.post_util_id = 401935 OR M.dest_util_id = 401935) 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 = 401935
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=387997 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 = 387997 AND W.type_id = 1) OR (W.util_id <> 387997 AND W.type_id = 2)) AND (M.post_util_id = 387997 OR M.dest_util_id = 387997) 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 = 387997
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=338238 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 = 338238 AND W.type_id = 1) OR (W.util_id <> 338238 AND W.type_id = 2)) AND (M.post_util_id = 338238 OR M.dest_util_id = 338238) 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 = 338238
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