-7200kg
qu'à l'achat
Description de l'annonce
Urgent cherche barres et coffre de toit Toyota chr
#Voitures
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-7200kg
qu'à l'achat
Urgent cherche barres et coffre de toit Toyota chr
#Voitures
Louer une voiture entre particuliers ou proposer une voiture en location.
Poster une annonce
-7200kg
qu'à l'achat
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='635121'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='voitures' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='985'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'voitures' 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='81'
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='527591' 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` = 527591
SELECT util_cp FROM utilisateur WHERE util_id=527591 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 = 635121
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=985 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 527591 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='635121'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='635121' 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=527591 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=527591 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 = 527591 AND W.type_id = 1) OR (W.util_id <> 527591 AND W.type_id = 2)) AND (M.post_util_id = 527591 OR M.dest_util_id = 527591) 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 = '635121'
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='527591' AND wish_id<>'635121' 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='59730'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.1667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.1667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.55- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.717039197041 AND ville_latitude_deg<50.616360802959 AND ville_longitude_deg>2.8480077631729 AND ville_longitude_deg<4.2519922368271 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 ('59730','59222','59218','59222','59730','59730','59218','59218','59360','59730','59730','59222','59218','59360','59730','59530','59550','59271','59360','59288','59294','59530','59550','59213','59213','59530','59360','59540','59360','59530','59530','59540','59540','59213','59213','59188','59530','59214','59980','59360','59292','59540','59227','59227','59980','59188','59530','59530','59550','59360','59213','59530','59213','59980','59217','59188','59530','59225','59227','59129','59530','59157','59530','59530','59360','59269','02110','59360','59269','59217','02110','59980','59980','59198','59360','59360','59157','59530','59225','59217','59224','59191','59530','59277','59550','59269','59990','59550','59296','59233','59360','59217','59400','59137','59191','59144','59191','59238','59144','59224','02450','59990','02110','59300','02110','02110','59144','02630','59144','59125','02110','59282','59400','59161','59145','59550','59550','59111','59144','59121','59141','59161','59400','59127','59300','59144','59127','59144','59121','59141','02450','59990','59127','59990','59282','02450','59550','59400','59144','59145','59400','02450','59111','59570','59570','59620','59220','59293','59141','59770','02630','59244','59300','59570','59161','59620','02170','59990','59220','59127','59570','59138','59400','59174','59111','59127','59295','59295','07387','02110','59620','59172','59400','59258','59244','59990','59195','02110','02510','59161','59440','59570','59156','59220','59111','59195','59570','02110','59550','59880','02630','59570','59410','59400','59620','59554','59258','59244','59440','59494','02510','07387','59570','59255','02510','59252','59172','59142','59138','59554','59138','59570','59990','59124','59494','59570','02170','59554','59554','59135','59252','07387','59281','59570','59860','02450','02450','59192','59264','02120','59138','59247','59268','59241','59258','07387','59590','59243','02110','59135','07387','07387','59265','59330','02170','07387','59267','59252','02420','59440','02110','59920','02510','59265','59215','02110','59171','02230','02110','02110','59570','07387','02120','02120','59247','59440','59620','02120','59159','02110','07387','59247','02450','59440','07380','59159','59440','02110','07382','02170','59171','07387','59570','59580','02170','59330','59330','59440','59400','59554','59266','59570','59267','07387','59330','59554','59330','59171','59278','59265','59440','02420','59234','59970','59234','59266','59580','07370','02420','07380','62860','59179','02110','59154','59440','59265','59330','59219','59440','02420','02260','59266','59165','07370','59490','02420','59265','02120','02120','59440','59440','59970','02110','07370','02420','59750','59234','02110','02620','59440','59330','07370','59178','02120','59219','02110','59230','59870','59490','02420','59400','07350','59219','59231','02120','59163','02120','59176','02420','59231','59267','59870','62147','59970','59178','02120','02120','02110','59163','59720','59151','07040','62860','02120','59159','59870','02120','02420','59169','62860','02260','59151','59297','07350','59176','02420','62860','02420','07350','07040','59163','02110','59600','07080','02120','02120','02120','02100','07340','59440','02110','59178','62860','59870','59177','07350','02260','02420','59216','59216','59216','59680','59178','59680','02120','59199','02100','02100','59231','02120','59199','02260','62860','59680','02420','62147','59146','62860','59131','59169','59600','07040','59177','59870','59680','59182','59287','59182','59158','02120','02420','80740','59169','02260','07080','59870','02260','07340','07300','59740','62147','59230','62147','59151','59230','02120','62860','59740','07340','07322','02420','59680','59177','59600','07320','59287','59226','80740','59600','07340','59230','07040','02420','07080','02260','07040','07301','02420','62860','62860','62860','07040','59151','59600','02100','59230','02390','07040','02120','59740','62860','02260','59600','59169','59680','59212','80240','02120','07080','62124','07322','07321','02140','59600','59167','59610','59740','59870','02580','07330','62860','02120','02260','59187','62860','59740','02260','07040','07603','80122','02390','62147','02490','02140','02100','02260','02390','02580','59151','07080','07390','59310','02720','07041','02490','59158','07390','59168','59245','62860','07321','59226','59158','59450','59740','59600','07608','02490','80112','07600','02100','80240','62147','02260','07334','59158','07012','59259','59740','59310','59690','07333','59194','62490','02490','02720','80360','59680','59148','02100','62182','62490','59169','07040','80240','59132','59680','62156','02120','59119','07973','62124','62860','62124','62112','59740','02120','02390','59310','07334','02500','80240','62182','07623','59740','02580','62147','59740','07024','02100','07012','07620','02720','59149','07973','59310','07033','02100','59552','02240','07022','59600','62112','59310','07022','07622','80240','02140','80240','59610','07624','02490','59310','07972','07601','62490','02120','80240','59740','62860','59740','07604','07331','07971','59194','02140','02100','62156','02490','59164','62124','62124','59132','80360','59500','07022','59552','02760','02250','07621','02240','62490','02500','02500','07332','07041','62124','06560','02240','07604','59740','62156','59460','07971','02140','02760','02100','07602','07022','62124','80240','80240','07971','07604','62117','62124','02500','02140','07011','07032','80240','07971','59132','62124','62156','07022','07620','07620','07620','02240','59310','02240','62159','07640','06560','07000','62182','62124','59553','59553','07604','80360','02500','62182','59310','80240','02500','02140','02240','59286','59310','02140','07120','07120','59186','62124','59149','62156','07620','07604','02140','07332','02430','06560','06470','02490','59553','02240','07640','02250','59128','02140','62118','07611','80240','62156','80240','07620','02250','62124','62490','07641','02270','07030','59283','02240','07120','02140','59310','06470','80240','02550','02490','07950','07970','02140','02140','07904','07972','62156','07538','07020','07643','62124','07120','02140','80240','02140','02680','59950','62128','62128','62128','07640','62118','06470','59235','62159','80360','59132','62124','62790','07618','07120','62128','59132','02240','07120','07031','80240','07120','02680','02250','62128','07050','59283','59132','02240','06560','07904','02690','07050','62490','02240','80240','80200','62450','07972','02140','02490','02490','80760','07020','02270','59149','02500','07642','06500','07500','07610','06594','59132','07120','80240','06590','02680','02680','62450','02140','07950','07534','62118','02140','02590','62970','62450','80200','07050','02270','06567','59830','59246','59242','02500','80200','62141','07530','07034','06560','02680','06560','02270','62118','59242','07506','80360','62118','06500','62128','02500','80200','02140','62490','07521','07950','07120','07903','62450','07050','06567','07500','80200','62490','62450','06470','02610','02240','59710','59830','06470','02270','07504','02140','07536','02140','02590','02590','62450','62128','07021','59162','02140','02690','62450','02590','07502','07903','02240','62118','02240','06591','07906','59830','07120','80360','02790','02140','02240','02140','07951','62950','59242','80200','07034','80200','07050','06567','62128','02440','59830','07130','59830','62580','02140','02500','62128','80200','59710','06593','02250','02250','62118','07812','06500','07950','59551','07870','07802','02500','02590','02590','62128','07110','62159','06500','02250','62450','62119','59239') AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='985' AND wish_id<>'635121' 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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540044 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 = 540044 AND W.type_id = 1) OR (W.util_id <> 540044 AND W.type_id = 2)) AND (M.post_util_id = 540044 OR M.dest_util_id = 540044) 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 = 540044
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=517419 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 = 517419 AND W.type_id = 1) OR (W.util_id <> 517419 AND W.type_id = 2)) AND (M.post_util_id = 517419 OR M.dest_util_id = 517419) 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 = 517419
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=523666 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 = 523666 AND W.type_id = 1) OR (W.util_id <> 523666 AND W.type_id = 2)) AND (M.post_util_id = 523666 OR M.dest_util_id = 523666) 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 = 523666
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=515729 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 = 515729 AND W.type_id = 1) OR (W.util_id <> 515729 AND W.type_id = 2)) AND (M.post_util_id = 515729 OR M.dest_util_id = 515729) 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 = 515729
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306783 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 = 306783 AND W.type_id = 1) OR (W.util_id <> 306783 AND W.type_id = 2)) AND (M.post_util_id = 306783 OR M.dest_util_id = 306783) 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 = 306783
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=481501 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 = 481501 AND W.type_id = 1) OR (W.util_id <> 481501 AND W.type_id = 2)) AND (M.post_util_id = 481501 OR M.dest_util_id = 481501) 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 = 481501
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77736 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 = 77736 AND W.type_id = 1) OR (W.util_id <> 77736 AND W.type_id = 2)) AND (M.post_util_id = 77736 OR M.dest_util_id = 77736) 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 = 77736
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=422720 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 = 422720 AND W.type_id = 1) OR (W.util_id <> 422720 AND W.type_id = 2)) AND (M.post_util_id = 422720 OR M.dest_util_id = 422720) 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 = 422720
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=143026 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 = 143026 AND W.type_id = 1) OR (W.util_id <> 143026 AND W.type_id = 2)) AND (M.post_util_id = 143026 OR M.dest_util_id = 143026) 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 = 143026
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='985' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=332350 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 = 332350 AND W.type_id = 1) OR (W.util_id <> 332350 AND W.type_id = 2)) AND (M.post_util_id = 332350 OR M.dest_util_id = 332350) 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 = 332350
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