Réserver
Prix
75€/jour
-1100kgqu'à l'achat
Description de l'annonce
Bonjour, je propose ma VStrom 650.
L'entretien complet à été fait récemment.
Top case suffisamment grand pour deux casques. #moto
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Prix
75€/jour
-1100kgqu'à l'achat
Bonjour, je propose ma VStrom 650.
L'entretien complet à été fait récemment.
Top case suffisamment grand pour deux casques. #moto
Annonces similaires
Tout voirLouer une moto entre particuliers ou proposer une moto en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
75€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='619693'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='moto' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='864'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'moto' 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 filtre_dpt='78'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='496040' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 496040
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 = 619693
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=864 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='619693'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='619693' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 496040 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=496040 LIMIT 1
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 = 496040 AND W.type_id = 1) OR (W.util_id <> 496040 AND W.type_id = 2)) AND (M.post_util_id = 496040 OR M.dest_util_id = 496040) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='496040' AND note_visu IN (1,3,4)
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 = '619693'
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='496040' AND wish_id<>'619693' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78170'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.4666517637462 AND ville_longitude_deg<2.8333482362538 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_cp IN ('78170','78290','78380','92380','92420','92430','78430','78150','78150','78400','92410','78560','78870','92210','92500','92310','78160','78000','78220','78110','78140','78590','78750','78620','92150','92800','78230','92000','92370','78112','78100','78360','78590','92100','78420','92360','92190','78330','78210','78800','92400','92250','92200','92130','78530','78350','78350','78860','78600','78450','78240','92140','92700','95870','78280','78600','92170','78240','92300','92320','78390','92270','92350','78500','78117','92240','78300','92600','91570','78450','92330','92260','92110','92220','78180','92290','92120','78340','91400','95530','78190','78960','95100','91430','78117','78810','91430','94250','78955','91370','75012','75019','75016','75020','75017','75013','75015','75014','75116','75011','75000','75002','75003','75004','75005','75006','75018','75001','75007','75010','75008','78630','75009','78260','78114','92230','93400','94110','92340','91190','95110','78470','95370','91190','78370','95240','78700','94233','94240','94231','94232','94230','94234','94235','94237','94239','94238','94236','78670','78670','92160','78810','95130','78570','93800','95218','95210','91300','78470','78121','94270','92390','93450','78990','94260','91120','95220','91440','94800','91400','78850','95120','78570','94550','78470','94200','94205','78780','95130','78540','95880','93200','93210','78460','91140','78630','94150','78640','78320','95230','78510','93430','95480','91940','91190','93300','93120','78580','93310','91320','78320','78640','91940','91160','95610','95250','93500','78480','95600','78310','94320','95000','91140','95360','94160','93170','94400','78760','78640','94220','95320','91470','95580','95580','78720','91380','91160','95170','78580','78720','94140','93240','78920','78310','95280','95390','91160','91940','78130','93380','91400','94300','78650','93100','95410','78320','95680','78460','95150','95550','93260','93230','78124','78640','95000','91470','95160','94390','91420','94310','78124','94700','95000','93350','94600','91550','78490','95490','95180','78720','91640','95310','78410','93440','78690','95300','91160','93000','78580','95740','91470','78740','94410','95350','91620','95800','78580','78490','78490','78650','95840','95140','91470','94290','93130','78490','94340','78690','91200','95350','78740','91360','93700','95560','78126','93150','93140','91620','78130','95200','95400','95430','95650','94000','95300','95540','95330','94120','78720','91360','95500','78410','93110','94130','78770','78770','95400','94480','78770','78250','95570','91700','95520','95840','91460','95450','91600','91390','95440','78250','91260','78410','78490','78490','94190','95650','91310','91310','78770','94170','78770','78410','78410','91270','78610','78490','94460','95460','93250','78490','78250','91640','95570','91310','78250','91640','94380','95630','91470','95430','78490','94100','94340','94210','95500','95560','91240','91560','95570','95450','91170','95650','78680','78770','93360','94360','91210','91310','95560','94500','78250','78830','93340','93320','94430','78820','78610','91230','91700','94450','95590','95720','91680','78580','95300','91640','95300','95760','91680','93330','91350','95650','95650','78830','95720','78720','93220','78770','78125','95500','78940','95450','95560','91220','78970','91220','91180','95720','95450','91700','78930','93600','78490','95450','94470','94350','78930','93270','78890','95500','78440','94380','94370','78610','91000','91130','91330','95190','91530','78250','91340','95620','91520','93390','93190','94490','94880','94880','95720','95810','95290','91470','95570','95450','93160','78910','93460','91290','78910','91800','94420','95450','91290','78440','93420','78790','93370','78790','78940','95270','91070','95830','95190','78440','91450','95270','78440','95690','91650','78440','95700','95690','95810','91650','95590','95830','95450','78910','95450','78610','94440','95850','91080','78120','93410','78930','78790','94440','78440','78730','78730','91530','78120','91650','95660','95810','91630','95270','78490','93470','77181','95190','78440','94510','95260','91090','91000','91630','91410','91860','78440','95380','77420','95260','78910','77500','95450','93290','95590','95690','91630','95690','91530','91450','95810','78930','95450','91800','91790','94520','94520','91630','77340','78520','95810','94440','95850','91090','78930','78930','78930','78910','95450','77185','78910','78200','95270','78711','95380','78440','77184','95340','91630','78790','95450','78125','91480','95640','95640','95270','95640','95270','95450','78790','77181','78200','77170','91250','91580','95270','78730','91810','91910','91730','77270','77186','95270','95270','95270','95640','78120','91530','95340','77177','91480','95380','78440','91250','91730','95380','78440','78790','95640','78550','60230','95510','78200','95270','95270','95420','91410','95670','91540','91280','78200','91410','77150','77200','78950','77360','78520','95380','77380','78790','95640','95340','91100','95470','91710','77680','78125','91100','78200','78113','91580','77290','95810','95820','95640','77410','78550','91730','95810','77990','91770','77150','78200','78113','91540','91540','77990','95640','78910','91250','77090','77183','95510','77127','91510','91510','78730','91540','60820','78790','78200','78200','60530','78730','95420','95450','78125','95420','95420','95750','95750','60240','91850','78520','78200','95510','95470','77170','91580','77330','60110','77600','78910','77400','91580','77400','60540','60540','60260','78111','78200','91760','78550','78113','60119','95420','60530','77410','95470','91610','78125','78980','78125','60119','91410','78550','78200','77600','77600','77400','78550','95470','60530','78125','60580','91250','77135','91830','77173','77230','77164','77230','95780','77230','60110','91750','60540','78550','78125','95510','60540','78660','91580','78710','77290','60240','95420','60560','78910','95420','77400','77600','91410','91590','78790','77166','77400','91410','78200','77410','78113','77400','60270','60240','60119','60530','78125','77550','60240','60460','78520','77230','77410','78980','60128','60520','77166','78790','77410','78113','60240','60530','77176','78125','60110','78840','78270','95420','95510','77410','77400','28410','91830','78270','60540','60175','91870','28410','78125','28230','95420','60240','77600','91750','78270','28230','60530','91580','91590','78200','78660','60173','77230','95420','78113','77410','60240','28410','91590','60240','95780','77230','28560','28260','77144','77600','60530','91410','77550','60460','78980','60128','78660','60520','91590','77240','91150','60570','60110','91150','95420','60340','77220','77176','77230','28410','78660','95420','77111','28210','77230','91590','91150','28560','95710','60340','77170','91590','60500','28320','77144','77700','77230','28260','28210','91410','91590','77240','77310','77450','60240','28410','95780','95510','28210','60500','60240','78840','77550','60520','78980','28130','78270','60740','78980','91150','77700','77220','60570','78980','60240','91590','77230','77240','60240','60240','91750','77310','77450','60149','60730','91780','91780','28700','77280','60240','95710','91410','28260','77410','28130','77550','77220','27630','28210','60730','60790','77111','78660','77410','78270','78660','28700','28410','77220','28210','78660','28320','91890','60240','77410','91410','91880','28410','77390','77174','78270','27620','60330','60950','77700','77230','60300','60300','28410','95420','77165','77310','60660','77230','28260','77950','77220','95710','91410','28320','60110','60730','78270','77410','28260','78270','77165','60790','60240','77450','27640','77700','77700','27620','77350','91820','28260','60660','60660','91820','60160','77450','91840','60730','77165','78270','77165','78980','28210','77950','60660','60660','60240','28500','60240','60240','28700','91780','28700','60240','77450','28320','60250','28410','78270','77350','28260','60240') AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='864' AND wish_id<>'619693' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549802 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 = 549802 AND W.type_id = 1) OR (W.util_id <> 549802 AND W.type_id = 2)) AND (M.post_util_id = 549802 OR M.dest_util_id = 549802) 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 = 549802
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=143984 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 = 143984 AND W.type_id = 1) OR (W.util_id <> 143984 AND W.type_id = 2)) AND (M.post_util_id = 143984 OR M.dest_util_id = 143984) 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 = 143984
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=547305 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 = 547305 AND W.type_id = 1) OR (W.util_id <> 547305 AND W.type_id = 2)) AND (M.post_util_id = 547305 OR M.dest_util_id = 547305) 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 = 547305
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=274132 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 = 274132 AND W.type_id = 1) OR (W.util_id <> 274132 AND W.type_id = 2)) AND (M.post_util_id = 274132 OR M.dest_util_id = 274132) 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 = 274132
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 547305
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546401 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 = 546401 AND W.type_id = 1) OR (W.util_id <> 546401 AND W.type_id = 2)) AND (M.post_util_id = 546401 OR M.dest_util_id = 546401) 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 = 546401
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546386 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 = 546386 AND W.type_id = 1) OR (W.util_id <> 546386 AND W.type_id = 2)) AND (M.post_util_id = 546386 OR M.dest_util_id = 546386) 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 = 546386
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544098 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 = 544098 AND W.type_id = 1) OR (W.util_id <> 544098 AND W.type_id = 2)) AND (M.post_util_id = 544098 OR M.dest_util_id = 544098) 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 = 544098
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=542210 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 = 542210 AND W.type_id = 1) OR (W.util_id <> 542210 AND W.type_id = 2)) AND (M.post_util_id = 542210 OR M.dest_util_id = 542210) 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 = 542210
SELECT ssrubr_slug, 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=538486 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 = 538486 AND W.type_id = 1) OR (W.util_id <> 538486 AND W.type_id = 2)) AND (M.post_util_id = 538486 OR M.dest_util_id = 538486) 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 = 538486
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 864
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 n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous