-15kg
qu'à l'achat
Description de l'annonce
Loue barres de toit pour mini clubman avec coffre de 310l
#Coffre de toit
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-15kg
qu'à l'achat
Loue barres de toit pour mini clubman avec coffre de 310l
#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='512629'
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('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='354094' 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` = 354094
SELECT util_cp FROM utilisateur WHERE util_id=354094 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 = 512629
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=723 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 354094 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='512629'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='512629' 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=354094 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=354094 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 = 354094 AND W.type_id = 1) OR (W.util_id <> 354094 AND W.type_id = 2)) AND (M.post_util_id = 354094 OR M.dest_util_id = 354094) 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 = '512629'
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='354094' AND wish_id<>'512629' 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='59222'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.1409*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.1409*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.57139- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.691239197041 AND ville_latitude_deg<50.590560802959 AND ville_longitude_deg>2.8697764388207 AND ville_longitude_deg<4.2730035611793 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 ('59222','59222','59360','59730','59222','59360','59360','59550','59360','59218','59360','59550','59288','59360','59530','59218','59218','59218','59730','59730','59730','59530','59271','59730','59540','59980','59730','59980','59540','59360','59550','59360','59540','59530','02110','59360','59530','59360','59213','59213','02110','59360','59294','59980','59530','59540','59530','59214','59225','59980','59188','59980','59292','59530','59530','59360','59550','59213','59213','59550','59530','59530','02450','59227','59227','59157','59217','59225','02110','59188','59530','02630','59530','59137','02110','02110','59191','59213','59157','59217','59530','59188','59213','59129','59238','59550','59227','02450','02110','02450','59269','59191','59217','59530','59530','59269','59550','59198','59191','02450','59145','59217','59400','59277','59144','02170','59224','59550','02630','59990','59144','59269','59127','59244','59296','02510','59127','59145','59127','59233','59144','59550','59244','59620','59400','02630','02110','59400','59990','59144','02510','59224','59620','59144','02510','59440','59161','59300','59620','02110','59144','59244','59161','59127','59138','02170','59125','59400','59570','02110','59144','59282','59127','59400','59141','02450','02450','59440','59570','59111','59141','59144','59620','02120','59121','59300','59990','59990','02170','59121','59570','02110','59570','59282','59258','02510','59138','59161','59570','59142','59111','59400','59141','07387','02120','02120','02110','59570','02110','59138','59400','59770','59570','02120','59990','59258','02450','59300','59440','59293','59220','59570','02110','59161','59295','59295','02170','59990','02230','59220','59111','59174','02170','59400','59138','59440','59330','59172','59554','02110','59570','59440','59195','02420','59111','07387','59570','02110','59258','59440','02110','59156','59880','59220','59195','59281','59241','59620','59554','59570','59410','59554','59990','07387','59252','59494','59440','59440','59554','59172','02260','59255','59570','59219','07387','59124','59330','59330','59267','07387','59268','59330','07387','59494','02120','02120','59252','02620','59247','59135','59440','59264','59860','59440','59243','02120','02110','07387','59330','59265','02420','59192','02110','59590','59219','59266','59159','59265','02110','02420','59920','59159','59252','59570','07387','59135','02120','02120','07387','02420','59440','02120','59266','59440','59570','59219','59330','59440','02120','02120','07387','02120','02420','07380','59215','02420','59247','59267','07387','02110','07382','59400','59171','59247','02120','02120','02120','59266','02260','59554','59330','02420','02110','59554','02260','02110','59265','59580','07370','02420','59750','59171','02110','02100','02260','07370','59278','59440','07380','59970','02120','62860','02420','59234','59234','02120','59177','02120','02420','59171','59154','02420','59265','02260','59580','02120','59720','59179','59177','59231','02100','02260','02100','07370','59216','59216','59231','07370','02260','59265','59216','02420','59165','59600','02420','59297','59680','59490','07040','59400','59970','59267','59159','59234','59680','59680','02120','02260','62147','59740','59177','02140','02120','07040','02390','59680','02580','07350','59178','07080','59740','59131','59212','02260','02120','62860','59163','02420','80740','02420','02100','59610','59490','59230','59680','62860','59231','59870','07340','02140','59151','02260','02580','02420','59176','07350','02260','59163','59600','59970','07350','07040','62860','02390','59870','59178','02390','59169','59151','59163','62147','02420','07350','80740','59870','02260','62860','59740','59740','59176','59600','59600','62147','59600','07080','02720','02100','59680','62860','80240','07340','59740','07040','62147','02490','02120','59870','59178','07340','59600','07040','07300','59600','07040','02120','02720','62860','02580','59199','07080','02500','07340','62860','59740','59199','59740','59178','02100','59132','07040','59169','02390','02490','59169','59146','62124','02140','02490','59287','59182','07322','59151','59182','02100','02120','07301','59870','59158','62860','02140','07080','80122','59870','07320','59168','59245','59610','59230','02720','02240','59740','59230','02250','59680','62860','62860','02490','59287','80112','07040','62860','02100','59151','80240','07041','59740','59226','59600','59230','02500','02500','02100','59680','07330','62147','07322','07080','59740','59132','02140','02240','07321','02100','59230','59169','59740','80240','62860','02140','59149','62860','02490','80360','07390','59740','02240','02500','07390','59167','80240','62147','02760','59870','07012','07603','80240','59187','80240','02100','02240','02140','07040','02490','02140','59151','62124','62124','02240','62860','59132','59600','02500','07333','02500','07334','80240','02760','07321','59164','02140','59740','07024','59259','59310','62860','02250','02140','62147','07022','59158','59186','07600','59450','07608','62182','07022','02240','02250','62490','59158','07012','59226','07033','02140','62156','80360','59158','02270','62490','07334','02140','07973','62182','59194','02140','59460','62124','02550','06560','02240','02240','59690','59310','02140','02140','59169','07041','62112','80240','80240','07022','62124','59148','59119','02430','62860','07973','07331','62124','02250','06470','80240','06560','59310','07623','07972','80240','62112','07620','02490','59552','59149','62490','02140','62156','02240','07022','07971','07601','62124','62124','59310','06560','59132','07032','07622','07022','59310','62124','02240','07332','02490','02680','07624','06470','02500','07604','02140','59310','02270','07120','07120','62490','80360','59132','59194','02680','02240','02140','02690','06470','59552','59500','07011','80240','59132','80240','02270','80240','06594','07000','62156','02270','80240','06590','02500','07621','62159','62124','62124','59132','07971','02140','07604','02500','62156','07602','62182','07971','62117','80240','02680','02680','02140','62182','07120','07971','02140','07604','02140','07120','02270','07030','06500','02490','06560','02490','07120','02590','62124','02140','02680','07620','07620','07120','59149','07604','59553','59553','02140','07120','07640','07620','80200','80240','62156','02610','02240','80360','62124','07332','59310','80240','02240','02140','02240','07020','62124','59286','07031','59310','62156','02690','02250','02250','02500','06470','62118','59310','80760','06591','07604','06500','62159','02240','06560','02500','62128','06470','59553','02250','80200','06560','62128','62128','07620','06567','07950','59128','07120','02590','02590','02590','62490','80200','07970','62156','07640','80200','06593','62450','02440','02790','02270','80200','02830','02270','07611','07972','62128','02250','07620','02140','07641','02270','07904','59283','07050','07050','62118','06567','07020','62128','59310','62450','07538','62450','07643','02240','02140','06592','59950','80360','07640','06460','02250','02250','07120','07034','62790','07904','02590','59235','02480','07618','06500','07972','62490','02140','59283','02590','07050','06500','80200','06460','07120','07950','02250','02270','62450','06500','02270','06567','80200','62118','62450','62450','80360','07021','80200','02590','02590','02240','02270','62128','62450','02140','02140','07642','07050','07500','02270','07610','07534','02800','02440','62118','02440','62118','80200','06500','80200','06567','80200','07130','62970') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='723' AND wish_id<>'512629' 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=460929 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 = 460929 AND W.type_id = 1) OR (W.util_id <> 460929 AND W.type_id = 2)) AND (M.post_util_id = 460929 OR M.dest_util_id = 460929) 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 = 460929
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=453025 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 = 453025 AND W.type_id = 1) OR (W.util_id <> 453025 AND W.type_id = 2)) AND (M.post_util_id = 453025 OR M.dest_util_id = 453025) 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 = 453025
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=343555 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 = 343555 AND W.type_id = 1) OR (W.util_id <> 343555 AND W.type_id = 2)) AND (M.post_util_id = 343555 OR M.dest_util_id = 343555) 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 = 343555
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=413930 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 = 413930 AND W.type_id = 1) OR (W.util_id <> 413930 AND W.type_id = 2)) AND (M.post_util_id = 413930 OR M.dest_util_id = 413930) 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 = 413930
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=380448 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 = 380448 AND W.type_id = 1) OR (W.util_id <> 380448 AND W.type_id = 2)) AND (M.post_util_id = 380448 OR M.dest_util_id = 380448) 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 = 380448
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=341786 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 = 341786 AND W.type_id = 1) OR (W.util_id <> 341786 AND W.type_id = 2)) AND (M.post_util_id = 341786 OR M.dest_util_id = 341786) 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 = 341786
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=185350 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 = 185350 AND W.type_id = 1) OR (W.util_id <> 185350 AND W.type_id = 2)) AND (M.post_util_id = 185350 OR M.dest_util_id = 185350) 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 = 185350
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=183514 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 = 183514 AND W.type_id = 1) OR (W.util_id <> 183514 AND W.type_id = 2)) AND (M.post_util_id = 183514 OR M.dest_util_id = 183514) 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 = 183514
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=183412 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 = 183412 AND W.type_id = 1) OR (W.util_id <> 183412 AND W.type_id = 2)) AND (M.post_util_id = 183412 OR M.dest_util_id = 183412) 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 = 183412
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=68025 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 = 68025 AND W.type_id = 1) OR (W.util_id <> 68025 AND W.type_id = 2)) AND (M.post_util_id = 68025 OR M.dest_util_id = 68025) 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 = 68025
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