-15kg
qu'à l'achat
Description de l'annonce
Loue coffre de toit avec ses barres de fixation . Neuf, gros volume
#Coffre de toit
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-15kg
qu'à l'achat
Loue coffre de toit avec ses barres de fixation . Neuf, gros volume
#Coffre de toit
Louer un coffre de toit entre particuliers ou proposer un coffre de toit en location.
Poster une annonce
-15kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
-15kg
qu'à l'achat
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='383513'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='coffre-de-toit' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='723'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'coffre-de-toit' 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='227'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('57' 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='201433' 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` = 201433
SELECT util_cp FROM utilisateur WHERE util_id=201433 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 = 383513
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=723 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 201433 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='383513'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='383513' 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=201433 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=201433 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 = 201433 AND W.type_id = 1) OR (W.util_id <> 201433 AND W.type_id = 2)) AND (M.post_util_id = 201433 OR M.dest_util_id = 201433) 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 = '383513'
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='201433' AND wish_id<>'383513' 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='973' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 201433
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='57170'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.383639197041 AND ville_latitude_deg<49.282960802959 AND ville_longitude_deg>5.7502095760945 AND ville_longitude_deg<7.1164504239055 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 ('57170','57590','57590','57170','57590','57590','57170','57590','57170','57590','57170','57170','57590','57590','57590','57590','57590','57170','57170','57170','57170','57170','54280','57590','57590','57170','57590','54760','54760','54280','57590','57590','57170','57170','57590','57630','57590','57590','54280','54370','57590','57590','57590','57340','54760','54760','57590','54280','57340','57340','57590','57630','57590','57170','54280','57170','54610','57170','57590','54610','54280','57340','57420','57340','54610','57420','57590','54760','57630','57630','57590','57590','57580','57340','54770','54370','57340','57630','57420','57170','54760','54760','54370','54770','54610','57340','54770','57340','57340','54114','57260','54370','54280','54370','57580','57580','57580','54760','57170','54110','57580','57420','54610','57340','54280','57580','57170','54610','57580','57380','54370','54610','54610','57340','54370','57380','54770','57580','57580','54370','54110','57340','57420','57580','54110','54610','57340','54420','57340','57630','54690','54370','57630','57260','57260','54760','57340','57630','57420','54110','57580','54280','54610','54770','57340','54370','57580','54610','54370','57380','57580','57340','54110','54425','57380','57420','54610','57810','57260','57340','54690','57380','57810','57340','54610','54670','54370','57420','57420','57340','57420','54370','57340','54370','57580','57580','57580','54610','54130','57810','57580','57340','54370','54370','57260','57260','54270','54700','57260','54110','54370','54370','57580','54670','57340','54420','54220','54136','57380','57340','57420','54130','57260','54380','57260','54670','54370','57260','54110','57810','57340','54250','57580','54110','54700','57580','54300','57420','57380','57340','57420','54510','54370','54300','54110','57420','54390','57260','54380','54380','57580','54300','54300','54320','54700','57260','57260','57420','57380','54510','54110','57260','54100','54000','57530','57580','54110','54370','54110','54210','54340','54140','57420','54380','54940','57810','57660','57810','57530','57340','57420','54700','57530','57670','57420','54410','57580','57420','57260','57420','54820','54300','57380','54110','57670','57690','54300','54300','57690','57420','54180','54520','54700','54700','57690','54700','57420','57420','57260','54380','54370','54110','54300','57245','57385','57385','57385','57380','57260','57810','57670','57380','57690','54710','54180','57660','57245','54210','57810','57530','57690','54300','57660','57530','54700','54600','57810','57670','57530','57420','54370','57530','54210','57530','54380','54700','57670','57260','54210','54700','54500','57380','54370','57670','57420','57530','57245','57114','57260','57260','54370','54700','57114','57660','57420','54460','54370','54300','57670','54700','57670','57930','57530','57220','54210','54300','57220','57670','54700','57810','57420','54300','57420','54380','54380','54300','57530','57530','54360','57420','57670','57660','57420','57670','57530','57690','54210','54300','54710','57770','57530','54230','54700','54700','57670','57114','57810','57245','54210','54360','54360','57530','57530','57690','54700','54360','54380','57730','57660','57670','54850','57530','54121','54300','57660','54360','57670','54385','57690','57670','54630','57680','54450','54210','57690','57660','57155','57420','57660','57690','54210','54380','57810','57670','54840','54850','54450','57220','54300','57660','57220','54300','54360','57660','54460','57930','57810','54950','57660','57220','57645','54840','57730','54450','54230','54450','54290','54450','54700','57670','54210','54230','57220','54450','54300','57670','57660','54530','54530','57740','54700','57117','57176','54200','57680','54450','54630','54470','57670','57117','54290','57660','57670','57730','54360','57220','57530','54200','54380','57810','54840','57500','57117','54290','54950','54450','54360','54470','54450','54450','54550','57810','57680','57660','57660','54530','54230','57530','54290','57130','57660','54450','57158','57950','57730','54450','57070','57070','57130','57670','57660','57930','54385','57220','57640','54160','57130','54550','54385','57220','54360','54830','57220','57640','57220','54840','54385','54830','57530','57070','57640','54830','57070','54450','57050','57670','54160','54450','57220','54385','54840','54450','54550','54385','54450','54470','54122','54470','57830','54200','57430','54290','54290','57220','57130','57160','57730','57050','54990','57130','57890','57000','57050','57070','54740','54290','54134','54550','54450','54890','57130','57670','57830','54890','57220','54830','57220','54360','57220','54385','57160','57450','57130','57160','54450','54160','57220','54290','54290','57640','54122','57430','54450','57640','54740','57510','54890','54890','57680','54470','57160','57830','57880','57070','54290','54450','54890','57470','54450','57450','54450','54118','54160','54385','57142','54134','54122','57640','54123','57930','67260','57160','57050','57830','57830','54120','57510','57140','57220','54740','57140','54830','54290','57220','54200','57830','57880','57050','54290','54830','57470','54450','57400','57830','57220','57930','54120','57880','54290','54830','57430','57670','54330','54200','57830','57830','54200','57930','57220','57640','54200','54450','57510','57510','54540','54330','57800','54200','54120','54290','54330','57430','54470','57490','57640','57890','57450','54200','57830','54740','57400','54740','54450','54290','57220','57220','54290','54830','57930','57930','57510','54830','57220','54470','54330','57930','54120','57640','57450','57490','54830','54290','54330','57830','54200','57220','57365','54740','57130','57400','67260','57800','54740','54122','54470','67260','54129','54120','57510','54330','57130','57450','54470','54200','54470','54470','54470','54290','57930','57930','54200','57790','57830','57830','57640','54740','54470','54470','54540','57800','57140','57140','57550','54450','54330','54450','54290','54830','54200','54470','57220','54290','57210','54200','57400','88700','54740','54122','54740','54120','54170','54450','54470','57510','57510','57130','54480','57790','54170','54540','57220','57640','54290','54470','54470','57450','54740','54200','67260','54170','54200','67260','57365','57790','57400','57220','57640','57150','54450','57510','54330','54290','88700','54200','57140','57790','54200','54890','54122','54470','57790','57550','54470','57790','55210','67260','54116','57220','57210','54290','57220','67320','57930','54470','57365','54740','57430','54470','67260','57800','57400','57220','54330','54120','54540','57510','57550','54800','57510','57210','88700','54470','67260','54113','54450','54113','54470','54480','88700','57865','54470','54800','57130','54330','57320','57280','57210','54330','57400','67320','54470','57930','54470','88130','57450','54740','57790','67320','54170','55300','57124','57800','54480','54120','54540','54330','54330','54570','57159','57535','88330','54330','57320','57980','57560','57980','57300','54290','88700','57320','54540','88330','57220','67260','54120','57320','57920','54740','54480','57600','67260','54800','67320','54200','57144','54800','57980','54800','88700','57600','54113','57159','57120','55300','67260','54480','54113','57430','54330','57560','54170','54113','54480','57400','57550','57300','57400','57320','54540','54119','54200','57320','57445','57525','88700','57915','57145','57400','57990','54540') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='723' AND wish_id<>'383513' 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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=475796 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 = 475796 AND W.type_id = 1) OR (W.util_id <> 475796 AND W.type_id = 2)) AND (M.post_util_id = 475796 OR M.dest_util_id = 475796) 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 = 475796
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=464872 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 = 464872 AND W.type_id = 1) OR (W.util_id <> 464872 AND W.type_id = 2)) AND (M.post_util_id = 464872 OR M.dest_util_id = 464872) 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 = 464872
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=290263 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 = 290263 AND W.type_id = 1) OR (W.util_id <> 290263 AND W.type_id = 2)) AND (M.post_util_id = 290263 OR M.dest_util_id = 290263) 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 = 290263
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389551 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 = 389551 AND W.type_id = 1) OR (W.util_id <> 389551 AND W.type_id = 2)) AND (M.post_util_id = 389551 OR M.dest_util_id = 389551) 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 = 389551
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='723' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 389551
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=362791 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 = 362791 AND W.type_id = 1) OR (W.util_id <> 362791 AND W.type_id = 2)) AND (M.post_util_id = 362791 OR M.dest_util_id = 362791) 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 = 362791
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=341794 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 = 341794 AND W.type_id = 1) OR (W.util_id <> 341794 AND W.type_id = 2)) AND (M.post_util_id = 341794 OR M.dest_util_id = 341794) 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 = 341794
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=257029 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 = 257029 AND W.type_id = 1) OR (W.util_id <> 257029 AND W.type_id = 2)) AND (M.post_util_id = 257029 OR M.dest_util_id = 257029) 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 = 257029
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=216014 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 = 216014 AND W.type_id = 1) OR (W.util_id <> 216014 AND W.type_id = 2)) AND (M.post_util_id = 216014 OR M.dest_util_id = 216014) 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 = 216014
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=202506 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 = 202506 AND W.type_id = 1) OR (W.util_id <> 202506 AND W.type_id = 2)) AND (M.post_util_id = 202506 OR M.dest_util_id = 202506) 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 = 202506
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 723
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 723
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