Description de l'annonce
Je loue mon vélo adulte mixte équipé de roues 700
Cadre alu
Idéal pistes cyclables
10€ par jour où 35€ la semaine
Au caution de 150€ sera demandée
#Velos
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Je loue mon vélo adulte mixte équipé de roues 700
Cadre alu
Idéal pistes cyclables
10€ par jour où 35€ la semaine
Au caution de 150€ sera demandée
#Velos
Louer un velo entre particuliers ou proposer un velo en location.
Poster une annonceEnvoyer 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='601078'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'velos' 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='95'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('90' 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='451814' 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` = 451814
SELECT util_cp FROM utilisateur WHERE util_id=451814 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 = 601078
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=788 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 451814 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='601078'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='601078' 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=451814 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451814 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 = 451814 AND W.type_id = 1) OR (W.util_id <> 451814 AND W.type_id = 2)) AND (M.post_util_id = 451814 OR M.dest_util_id = 451814) 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 = '601078'
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='451814' AND wish_id<>'601078' 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='90700'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.117039197041 AND ville_latitude_deg<48.016360802959 AND ville_longitude_deg>6.1835638758615 AND ville_longitude_deg<7.5164361241385 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 ('90700','90400','90400','90400','90400','25600','90400','90400','25600','90400','25200','25600','90800','90800','90400','90140','90800','25200','25490','70400','25600','90400','25600','90850','90400','90120','90140','70400','90120','25490','25200','70400','25400','70400','90800','90140','90000','25460','25400','70400','90850','90160','70400','90140','25420','90340','70400','90140','70400','25550','90600','25490','90340','25550','90300','25400','90340','70400','25550','25400','25630','25490','90140','25230','70400','70400','90160','90500','90100','25550','25550','90300','90160','25700','25230','25420','90100','70400','90300','70400','25750','25750','90130','25550','25550','90300','25230','90130','90100','90100','90500','90380','25550','90100','90100','25750','90130','70400','90350','70400','90150','90150','25550','25420','25230','90300','70400','90150','25420','90150','90150','25113','90100','25350','70400','90150','90100','90150','90100','25420','25750','70400','70400','02926','68210','68210','25750','90100','90300','25260','90100','90300','25310','90100','70400','68210','70400','68210','25260','90150','25310','25700','90150','90150','90170','70400','90100','90150','90110','02925','25310','70400','25310','90330','25260','90200','25310','68210','68210','70400','25260','90100','90110','25150','25150','90100','90170','90150','90170','90110','90100','02915','02916','02924','70200','90100','90200','90100','25250','25310','25150','70200','25250','90110','70290','90150','25250','02923','90100','90200','90150','68210','25250','68210','68210','25250','25260','70400','70290','70400','25150','68210','68210','25250','90200','25310','90200','02908','02933','90110','02922','25150','70200','25310','25260','68210','70200','68210','90360','90360','70200','70200','90110','70250','68210','25310','70400','68580','68210','90200','25150','68580','68210','70400','90370','02933','02907','02905','68210','68210','68210','25250','68210','68780','70200','70200','70200','02906','90200','25310','02914','02932','90200','68210','68210','68580','70400','02912','02935','90170','68210','25250','25250','25250','25150','02900','02900','02900','25250','70290','70110','25150','70200','70200','68580','68580','02912','25250','68780','68290','25150','25250','25150','25190','68780','70110','70200','68210','70200','25190','25190','70110','70110','70270','68780','25190','68780','25250','25250','02904','68210','68780','68210','68210','25190','25250','68480','25190','25190','68580','70200','70110','02944','68210','02902','25250','25250','68210','25190','68290','70290','68580','70110','25190','70110','02943','02942','25250','70200','68780','68290','68290','68210','25190','68290','25190','25190','68290','02903','25190','68116','68290','68290','68210','25250','25250','68720','68290','70110','70110','68118','25190','68580','25190','25190','70200','70200','02950','70200','68130','70110','25470','70270','68580','02946','70110','70270','70270','02889','25470','68720','70110','70110','25190','70110','70200','68520','70200','68290','68210','68520','70440','25340','70200','25250','68480','68290','70270','70270','25470','25340','02888','02952','02950','70200','25190','68800','25430','68700','25470','68560','70110','68560','25190','25340','68130','70110','70110','68720','68480','70440','68130','70200','25430','68290','25190','68800','25190','68720','68480','68480','25340','02953','25190','25340','68990','68560','70110','70200','02947','68480','68640','25470','25470','68480','68700','25430','02886','68520','25190','02882','02882','25470','02887','68720','68800','68700','70440','25340','25340','25340','02885','68560','70110','68640','70110','68130','68720','02884','02953','25380','68800','68130','02954','68720','70200','68480','25340','25680','25680','68480','25120','25120','70270','68800','25340','25430','25470','25470','02353','88160','88560','25120','02807','68960','68960','68720','68720','68480','25680','25340','68480','02362','70110','70110','02363','70200','68990','25470','70200','68130','70200','02883','25430','02354','25430','25430','68620','25380','68470','68130','68130','68480','25340','25120','88540','25380','70200','70270','68720','68960','25680','25340','70110','68960','68640','70110','25430','68470','68950','02364','25450','25340','25340','70200','88160','25340','25120','68130','70110','70310','70270','70200','68700','25470','25430','68480','68121','68470','68760','70310','25380','02857','68550','02803','68690','70110','25380','68130','02856','70200','68480','68130','68130','70110','68480','02362','02807','68720','02360','68700','68700','68470','25340','02855','70240','25680','68480','25380','70300','88160','25380','02338','88160','68790','68550','68470','25380','70240','25470','70200','25430','68480','70300','02873','68640','70310','68350','68130','70110','25110','25380','70110','02350','88360','68480','70310','70310','68720','70240','68130','25680','25680','25430','02718','68470','25120','25110','25110','25110','70300','68480','25680','70310','68350','68690','02338','02813','70200','68130','25140','68760','02854','02718','68440','70240','25140','68130','70230','25680','02714','68460','68700','25140','02802','68480','25680','70310','70280','70300','70240','02340','25680','68510','02717','68640','25110','02812','25210','25380','70310','68130','70310','70000','68830','68480','02863','25680','70280','68120','70300','70310','02717','25110','68440','02345','25110','02714','68510','25110','02806','70230','68480','25380','88310','68310','68850','25380','68510','02814','25680','68480','02713','02722','70280','68220','02715','25430','68120','68440','25210','70240','68100','68200','68480','68480','70000','70280','68820','02853','68500','70280','25510','02345','02715','25530','25110','25110','68510','25680','68440','70240','02800','02800','25680','70310','25380','25360','25680','25210','70230','02800','70300','02720','70240','68220','68640','70000','70300','68510','70300','25680','25110','68480','02716','25110','88360','02712','88290','68510','68500','02723','70310','68480','02336','68500','70240','68440','70240','68440','68500','25680','68110','70240','68510','70300','70230','25110','70300','68400','68220','25110','02852','68500','25680','70240','68510','70230','02345','68510','02748','02864','02805','02732','02610','68440','25360','70240','25140','88310','70300','68260','70300','68500','02842','68510','02732','02748','68540','70300','02720','68440','25110','25510','68730','68220','70240','68730','70230','25210','25210','88290','25210','68360','04245','25530','02822','68530','68390','70000','68870','02608','68270','68220','04118','70230','70300','25680','25110','04117','68610','04254','02710','02843','70300','25210','68840','02607','25680','68220','68440','25530','68480','68540','68610','02733','70300','68390','02333','70230','68220','68220','70300','02732','02610','02612','68170','68870','25640','68500','25360','88120','02610','25210','02606','68820','70000','25360','70230','02830','02732','25210','02823','25210','70230','70240','68510','68220','04253','70240','25640','88340','70300','70000','68730','70300','02742','25530','25510','25110','25110','02830','68530','70000','04116','68190','25110','70300','25530','25640','25360','02735','68610','88340','88250','25390','02735','25210','25640','02613','68500','68220','25510','04244','02735','04115','70220','68270','70000','25640','70000','25110','02605','02608','02615','88200','68500','70230','70240','25640','88120','70230','25640','02333','04124','25510','68380','25210','02824','02762','04112','68190','70000','02735','70230','70240','68390','25530','02300','25110','68500','02610','70800','25110','68500','25510') AND fami_id='5' AND cate_id='95' AND type_id='1' AND ssrubr_id='788' AND wish_id<>'601078' 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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420290 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 = 420290 AND W.type_id = 1) OR (W.util_id <> 420290 AND W.type_id = 2)) AND (M.post_util_id = 420290 OR M.dest_util_id = 420290) 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 = 420290
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=390134 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 = 390134 AND W.type_id = 1) OR (W.util_id <> 390134 AND W.type_id = 2)) AND (M.post_util_id = 390134 OR M.dest_util_id = 390134) 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 = 390134
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232944 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 = 232944 AND W.type_id = 1) OR (W.util_id <> 232944 AND W.type_id = 2)) AND (M.post_util_id = 232944 OR M.dest_util_id = 232944) 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 = 232944
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=352133 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 = 352133 AND W.type_id = 1) OR (W.util_id <> 352133 AND W.type_id = 2)) AND (M.post_util_id = 352133 OR M.dest_util_id = 352133) 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 = 352133
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=338043 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 = 338043 AND W.type_id = 1) OR (W.util_id <> 338043 AND W.type_id = 2)) AND (M.post_util_id = 338043 OR M.dest_util_id = 338043) 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 = 338043
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=68942 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 = 68942 AND W.type_id = 1) OR (W.util_id <> 68942 AND W.type_id = 2)) AND (M.post_util_id = 68942 OR M.dest_util_id = 68942) 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 = 68942
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=118712 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 = 118712 AND W.type_id = 1) OR (W.util_id <> 118712 AND W.type_id = 2)) AND (M.post_util_id = 118712 OR M.dest_util_id = 118712) 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 = 118712
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='788' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 118712
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=262981 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 = 262981 AND W.type_id = 1) OR (W.util_id <> 262981 AND W.type_id = 2)) AND (M.post_util_id = 262981 OR M.dest_util_id = 262981) 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 = 262981
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='788' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=277745 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 = 277745 AND W.type_id = 1) OR (W.util_id <> 277745 AND W.type_id = 2)) AND (M.post_util_id = 277745 OR M.dest_util_id = 277745) 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 = 277745
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 788
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 788
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