-5kg
qu'à l'achat
Description de l'annonce
Loue porte 3 vélos thules
Facile à installer et très stables
#Porte velo
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-5kg
qu'à l'achat
Loue porte 3 vélos thules
Facile à installer et très stables
#Porte velo
Louer un porte-velo entre particuliers ou proposer un porte-velo en location.
Poster une annonce
-5kg
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='255547'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'porte-velo' 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='31729' 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` = 31729
SELECT util_cp FROM utilisateur WHERE util_id=31729 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 = 255547
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=722 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 31729 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='255547'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='255547' 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=31729 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=31729 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 = 31729 AND W.type_id = 1) OR (W.util_id <> 31729 AND W.type_id = 2)) AND (M.post_util_id = 31729 OR M.dest_util_id = 31729) 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 = '255547'
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='31729' AND wish_id<>'255547' 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='59111'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.833639197041 AND ville_latitude_deg<50.732960802959 AND ville_longitude_deg>2.6129594907042 AND ville_longitude_deg<4.0203805092958 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 ('59111','59111','59172','59172','59111','59111','59293','59252','59252','59295','59295','59156','59252','59282','59282','59141','59215','59296','59580','59141','59124','59247','59580','59220','59234','59247','59141','59198','59165','59554','59400','59234','59265','59220','59247','59121','59171','59161','59179','59171','59554','59188','59255','59277','59490','59234','59224','59161','59171','59220','59121','59268','59176','59188','59161','59129','59490','59224','59265','59227','59227','59135','59265','59176','59195','59161','59169','59265','59870','59554','59151','59233','59227','59195','59125','59135','62860','59554','59188','59182','59265','59287','59870','59400','59292','59182','59169','59151','59213','59217','59146','59174','59287','59294','59494','59870','59554','59269','59400','59870','59169','59213','59554','59300','62860','59214','59870','59400','59494','59217','62860','59151','59167','59267','62860','59400','59217','59178','59169','59213','59213','59410','59187','59300','59590','59730','62860','59151','59870','59269','59400','59400','59178','59217','59400','59178','59450','59157','59300','59730','59192','59730','59870','59157','59213','59213','59194','59730','59178','59269','59151','59400','59730','59119','59281','59540','59990','62860','62860','59770','62860','59267','59271','59148','59230','59169','59230','59540','59230','59159','59860','59880','62490','59990','59530','62112','59552','62860','59310','59194','62112','59990','59530','59241','59500','62860','62490','62860','59259','59310','59552','62860','59127','62490','62860','59191','59400','59258','59159','59540','59990','59191','59258','59730','59218','59218','59310','59226','59530','62147','59540','59990','59225','59144','62156','59360','59553','59553','59218','62117','59530','59218','62860','59286','59310','59310','59690','59310','59226','59158','62490','59191','62156','59530','59530','62182','59128','62860','59264','59980','59258','59225','59278','62147','59530','59553','59267','59283','59230','62182','59310','62156','59127','59144','59243','59950','59222','59222','59310','59980','59199','62490','62790','59310','59230','59990','59530','59199','59283','59970','59159','62147','59360','62118','59144','07624','59970','59530','59144','62156','59530','59235','59980','59970','59530','62490','59990','07623','59360','59158','59266','59231','59158','59980','59980','62970','59127','62860','59222','59144','59310','62118','62156','62141','59530','59127','62860','59530','59127','59144','62156','07620','59163','59246','59530','59238','07621','07387','59550','59288','59158','62147','62182','59920','59266','59162','62147','07611','07387','62156','62490','07387','62182','62147','59142','59360','62950','59154','62490','59710','59550','59360','02420','59242','07622','07387','62118','62118','59144','59231','59570','59360','59242','59163','59266','07620','62119','62128','07620','62147','59239','59551','07380','62580','62128','07608','07380','59710','59231','59144','07620','07620','62118','07387','07620','59242','59137','02110','59830','62118','59530','62124','59261','62159','07618','59163','62124','07610','02110','59360','59297','59830','07387','59360','07387','62320','62320','02420','62128','62128','59239','59710','59570','62820','59830','07382','62124','62118','07350','62124','62110','07387','59570','62128','62124','07604','62590','62580','62128','59570','02110','02110','07641','07603','62320','02420','62580','59830','07320','07600','62124','02420','59830','02110','62640','59550','59570','59551','62580','02110','62128','62124','62128','07502','59830','59710','59273','59570','07506','62128','62124','07350','07640','07500','07504','62320','07640','59360','02110','02110','62740','62710','07604','62124','62159','62124','07640','59360','07370','62420','62223','59570','59570','59273','62580','62220','07601','59570','07500','07643','07387','59133','07604','07370','62580','80360','59780','07387','07642','62580','80122','80740','02420','62128','07350','07321','59360','59570','07322','62223','62680','07538','07321','80240','02110','59830','02110','07521','07387','62128','62440','07602','62880','62450','62128','59262','07604','02420','80740','07370','80360','59360','59550','59133','62580','62124','62430','62124','02420','02110','07522','07604','07536','02110','59570','59780','62217','80240','07501','62217','07971','59113','07350','02630','59112','59152','07522','62450','62124','59550','62221','62218','07322','07370','07530','62450','59145','59175','59152','59152','59810','07971','62128','62159','07500','62124','59147','07973','80360','62210','62580','62128','59175','07971','59145','62223','62121','80112','07522','80240','07971','07972','62880','62880','62450','02420','07548','02420','02110','59570','62217','80240','02450','62121','02630','02420','62580','07534','59550','62175','59138','02420','07522','07904','59152','07503','02230','59155','07300','62880','07973','62000','59620','59147','62217','62450','62450','59251','62223','59570','80240','07904','59138','62300','80360','07340','62121','62121','02420','59139','59620','59790','59185','62300','07531','62223','62450','59550','07540','59147','59263','07334','02450','59112','02420','02110','02630','62450','02420','59550','62175','62410','59570','62450','62223','62217','62217','59138','59780','62223','59139','59260','62580','59138','80360','02450','07532','07301','62410','07540','07972','62450','07904','80240','80240','59510','02110','07330','62121','62450','59620','62450','07906','80240','62175','07520','59221','02450','02490','62121','07340','62223','07334','07534','62580','07340','59330','62121','02490','02420','07333','07080','02420','62410','02110','07340','02510','62450','59390','07520','62450','59272','59244','02420','80240','62138','07972','80240','02110','02510','59620','07533','62175','80240','62121','59440','59330','02170','59510','07332','80760','07040','07542','62153','62800','59320','07390','02510','07080','62173','59184','62410','02110','02110','07970','62450','07080','59244','07540','62750','07543','59440','07040','02120','07743','62121','59496','62217','59136','59320','62450','80360','07901','80360','62175','59370','07743','62000','02100','02100','59750','07390','59120','07950','59000','59800','59160','59350','59777','02100','07903','80240','02490','07730','07331','62143','07730','07903','62138','59330','02490','02110','59390','07540','59244','80360','59550','02490','59390','62173','80240','02120','02120','07080','07911','80240','62116','07332','59274','59620','80360','07903','59211','59390','07012','02450','02450','80200','07040','59320','62161','62161','59330','62153','80200','80360','62116','07900','07900','59496','07730','07950','59170','59290','80360','02110','62121','62144','80200','07760','02120','07760','59110','02100','07040','02170','59320','59440','62116','02510','07012','02100','59115','59440','07911','59134','07740','59330','59330','07040','62138','62450','07040','62161','07730','62144','59134','80300','07080','07812','62116','02490','02110','59600','59134','62160','80200','62173','80360','59130','80300','02170','02110','07911','62173','59134','07040','62160','59700','07950','59440','80240','02120','07040','62138','59320','59320','59480','80200','07910','59320','59350','59491','59493','59650','59655','62123','59600','62160','80240','02120','62161','62123','80200','59720','80300','07033','02100','07760','07802','02450','80360','59600','07951','07742','59480','02100','07011','59320','07812','07911','59320','59330','02760','59150','07740','62138','62116','62980','07050','80300','07730','59440','07730','07024','62144','80240','59440','59520','07812','07040','62123','02120','59600','59100','80240','62111','07950','59440','80200','07910','02170','62116','59440','07812','59160','62123','62123','07910','07730','80200','07812','62149','02490','07911','62149','62144','80360','62980','59440','62450','80300','02170','59440','62149','59420','59134','02120','07041','80300','59840','02100','02120','02100','62670','80200','07022','07022','59249','59118','02720','59840','80200','07910','07910','62172','02120','07050','07801','07950','08587','02760','62123','62114','59131','59600','07712','07910','59680','07760','59440','07911','07022','59910','80360','07050','02490','02490','62144','62149','62123','07000','62690','59249','62123','62530','07022','62840','80360','59840','08587','02490','02390','80300','62690','07910','62123','62530','59440','07812','59200','07870','80200','59600','80200','62123','62123','59600','62123','80200','59237','62113','62113','59219','02120') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='722' AND wish_id<>'255547' 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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544943 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 = 544943 AND W.type_id = 1) OR (W.util_id <> 544943 AND W.type_id = 2)) AND (M.post_util_id = 544943 OR M.dest_util_id = 544943) 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 = 544943
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=514300 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 = 514300 AND W.type_id = 1) OR (W.util_id <> 514300 AND W.type_id = 2)) AND (M.post_util_id = 514300 OR M.dest_util_id = 514300) 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 = 514300
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339897 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 = 339897 AND W.type_id = 1) OR (W.util_id <> 339897 AND W.type_id = 2)) AND (M.post_util_id = 339897 OR M.dest_util_id = 339897) 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 = 339897
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=365974 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 = 365974 AND W.type_id = 1) OR (W.util_id <> 365974 AND W.type_id = 2)) AND (M.post_util_id = 365974 OR M.dest_util_id = 365974) 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 = 365974
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='722' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 365974
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=442492 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 = 442492 AND W.type_id = 1) OR (W.util_id <> 442492 AND W.type_id = 2)) AND (M.post_util_id = 442492 OR M.dest_util_id = 442492) 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 = 442492
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=336903 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 = 336903 AND W.type_id = 1) OR (W.util_id <> 336903 AND W.type_id = 2)) AND (M.post_util_id = 336903 OR M.dest_util_id = 336903) 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 = 336903
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=343855 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 = 343855 AND W.type_id = 1) OR (W.util_id <> 343855 AND W.type_id = 2)) AND (M.post_util_id = 343855 OR M.dest_util_id = 343855) 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 = 343855
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=320591 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 = 320591 AND W.type_id = 1) OR (W.util_id <> 320591 AND W.type_id = 2)) AND (M.post_util_id = 320591 OR M.dest_util_id = 320591) 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 = 320591
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317386 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 = 317386 AND W.type_id = 1) OR (W.util_id <> 317386 AND W.type_id = 2)) AND (M.post_util_id = 317386 OR M.dest_util_id = 317386) 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 = 317386
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