Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

À LOUER – Yamaha XJR 1200 – Moto de caractère

Location Moto

Réserver

Ce voisin propose en location à Stains (93240)

60€/jour

Antoine S.

1 annonce

Prix

60€/jour

-1100kgqu'à l'achat

Description de l'annonce

Disponible à Stains
? Modèle emblématique des années 90, la XJR 1200 est une moto musclée au style rétro et au moteur puissant. Parfaite pour une balade stylée ou un week-end de pur plaisir sur une grosse cylindrée au couple généreux.
? Caractéristiques :
• Yamaha XJR 1200
• Moteur 4 cylindres en ligne – 1200 cm³
• Look vintage, sonorité rauque, sensations garanties
• Confort de conduite top en solo ou duo
? Tarifs :
• Journée : 60 €
• Week-end : 110 €
• Semaine : 320 €
➡️ Prix négociables pour location longue durée ou régulière
✅ Conditions :
• Permis moto A valide
• Caution demandée
• Conducteur sérieux uniquement
? Contacte-moi en MP pour plus d'infos ou pour réserver ! #moto

Annonces similaires

Tout voir

Il y a + de 30j

Xadv 2025

110€/jour

Sarcelles

Il y a + de 30j

Moto trk 702

100€/jour

Saint-Chéron

Il y a + de 30j

Moto bmw

130€/jour

Soisy-sous-Montmorency

Il y a + de 30j

Moto

100€/jour

Noisy-le-Grand

Il y a + de 30j

Moto bmw

130€/jour

Soisy-sous-Montmorency

Il y a + de 30j

Moto Ducati Diavel S - pack touring

120€/jour

Paris

Il y a + de 30j

Sportster 1250 S bi-place

120€/jour

Courbevoie

Il y a + de 30j

K1600b

170€/jour

Puteaux

Il y a + de 30j

Honda nt 1100

120€/jour

Versailles

Il y a + de 30j

Location moto 125

90€/jour

Palaiseau

Louer une moto entre particuliers ou proposer une moto en location.

Poster une annonce

Location entre voisins

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
0.0001
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
0.0002
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
0.0002
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0005
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<>''
0.0001
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='635232'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'moto' LIMIT 1
0.0001
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'
0.0001
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('93' USING utf8mb4) COLLATE utf8mb4_general_ci
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='527720' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 527720
0.0001
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 = 635232
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=864 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='635232'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='635232' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 527720 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=527720 LIMIT 1
0.0002
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 = 527720 AND W.type_id = 1) OR (W.util_id <> 527720 AND W.type_id = 2)) AND (M.post_util_id = 527720 OR M.dest_util_id = 527720) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='527720' AND note_visu IN (1,3,4)
0.0001
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 = '635232'
0.0001
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='527720' AND wish_id<>'635232' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='93240'
0.0167
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.500339197041 AND ville_latitude_deg<49.399660802959 AND ville_longitude_deg>1.6986132137498 AND ville_longitude_deg<3.0680467862502 HAVING distance <= 50 ORDER BY distance ASC
0.006
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 ('93240','93380','93440','93200','93210','95360','93350','95140','93430','93120','93300','92390','93450','95500','95410','95400','95170','95880','93700','93150','93800','95400','95200','95350','93500','95500','92230','93400','95160','95230','93000','95440','93310','95210','95218','95350','92110','95580','95580','93140','95500','93260','93230','95720','92600','95600','95500','92300','92270','95120','95460','93170','95720','95190','93130','95100','93600','95110','95330','93100','95680','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','92700','93270','93420','95720','95700','92250','93320','93340','92400','95390','92200','93250','95570','95130','95570','94300','93110','95190','95320','95130','95870','95380','95570','93190','93390','95720','94160','93220','94120','93360','95850','93410','95560','95190','78800','95240','95560','94170','93290','92170','95560','92800','92150','92000','93370','78500','95530','95840','94200','95270','94205','94270','95570','94130','95380','94220','95270','95370','78420','77181','93470','94250','95150','95550','95380','95250','92500','92120','95560','95850','95380','93330','94410','92240','94340','92100','94360','93460','95740','95380','95590','94800','95220','95270','94140','95840','78600','94110','94700','95670','92130','92210','77270','77990','95270','95270','93160','77290','78360','77181','95480','77990','77500','94500','95270','92220','94350','95470','92320','94400','95270','78400','95540','95470','95270','92140','94100','94210','94340','78600','92190','92360','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','95270','92380','94430','77420','95590','94000','77177','92410','77410','92260','92330','95430','95630','95470','92310','94420','92430','92420','92340','78110','77230','78170','94320','92350','95270','95430','77230','77230','78290','78380','94550','95270','94600','95470','95270','77410','78560','78700','95590','95760','77186','92370','77290','78230','77185','95290','78430','77360','95260','94380','95610','77230','95260','92290','60128','95620','78140','94490','94880','94880','94310','94390','94150','95310','77200','60260','95660','60560','77184','78100','94260','78220','60580','92160','94460','77410','60520','78750','77400','94370','94380','78260','77410','77340','78570','77410','78150','78150','95300','77230','94510','78780','77230','78160','77400','95340','91370','60820','94290','95000','94470','78112','60128','91320','95300','78300','77090','77183','77230','95820','94190','78870','77600','77410','95300','78000','95340','95000','77230','78620','77400','77400','95690','91300','94450','60520','91570','77230','77400','78955','77410','77680','78590','77600','77600','78570','78350','91550','91200','60230','60270','94480','77400','78240','91560','77280','95520','95690','95300','95280','60520','77230','77600','77400','60530','95340','91430','94440','95490','95690','91330','78240','78350','78530','95650','60330','60950','77164','77230','91430','78590','91120','60460','91270','78670','78670','95690','91420','77410','77600','77230','95810','94440','91230','78510','77450','77144','60530','60500','91380','91160','77165','78330','78210','77135','95650','60500','91400','95000','77165','95650','77144','77700','78860','60530','77330','91160','91800','94440','77410','78540','77410','78480','77410','78630','95800','91140','77150','78117','95810','91260','60340','77165','77165','60340','91210','77450','78450','77600','77170','60300','60300','60530','60740','77230','95180','77150','60540','60540','95810','94520','94520','60460','77450','60530','60330','60950','78280','91160','77700','91860','78450','77700','78740','60300','91400','91170','78390','91390','91600','60540','91140','91800','95650','95650','77450','95810','91360','91190','77165','78117','78810','91360','91440','95810','60530','77450','91160','91190','78740','60540','95830','60300','60300','60330','95450','78180','60950','78340','91480','78130','78630','95450','60530','60300','78960','77700','77178','77450','95810','60300','77173','60300','77450','91350','91480','60660','60300','77124','78114','91000','91130','95450','95830','60160','60110','78190','77122','91940','78121','91450','77450','60540','77174','60110','91700','78920','78810','77178','60300','77170','77700','77380','78580','78470','91620','78130','95450','60330','95810','95640','78250','91940','91190','77860','78370','60300','91620','77220','60660','60660','60660','60660','91700','91940','95450','77100','77124','78410','77580','77100','91700','60160','78470','77124','95640','91090','91000','77220','78250','60180','91240','91450','77165','77165','78850','60100','91310','95450','78250','78470','77174','77860','60810','77166','91310','91310','91250','60440','60440','60110','60700','60440','95640','77124','78990','78250','60730','95640','91460','60570','60119','78580','77860','77220','78460','60810','91400','91070','91080','78250','77910','77127','77220','60250','91220','91220','91640','60810','95640','95640','77166','78640','77139','95450','78410','60730','60870','78580','91250','77100','60730','95640','91280','60570','60240','77910','78124','95450','60440','60550','78640','60175','91310','91470','78124','60119','77139','77610','78320','95450','60440','95450','78320','77580','77580','60660','78410','78126','91090','60440','60250','91470','77170','78580','60110','60290','78820','78650','60730','60290','78640','78720','77220','91100','77580','60810','95640','77580','78310','95450','91250','95450','60119','78760','91470','77111','78250','78460','77390','78720','60730','60870','91180','78410','78410','77470','77550','77470','78440','95450','60173','60810','77910','77580','78640','95750','60800','78310','60870','77610','91640','60250','78320','77139','60250','60290','91100','77163','91680','77139','95450','60140','91470','77111','78680','77470','60810','77470','60700','60240','78440','60940','91290','60440','78720','78440','77910','77610','77580','91640','60940','91290','60700','78770','78490','60149','78440','77610','78650','60110','60800','78770','60570','91470','77550','91680','77550','60940','91520','91340','78970','91810','60290','91540','77580','60440','95750','60810','60290','77470','91540','91540','78690','78490','77163','91630','77176','60430','60240','60800','60410','91630','60140','77550','78490','78490','77163','78440','78770','95420','60790','60140','91630','91250','91830','60790','60700','91640','78440','77390','78770','77440','60250','60700','60240','91630','77470','78720','77610','78690','95420','95450','78580','77440','77470','78770','78440','60620','60240','60790','78440','60250','91710','60290','91540','60620','60240','60250','60410','60430','60790','60240','60140','60620','78770','77610','60250','60240','77610','77390','77139','78440','78930','78830','91650','77176','77390','60240','60800','78490','77580','77515','78930','91530','60410','60250','60140','91630','78490','78490','91650','77240','95510','78770','77580','60620','60790','95420','77950','78490','60790','60430','60240','77240','78610','78490','77580','60800','95420','60700','91790','77240','77660','77390','60240','78440','77440','60240','60240','60430','60250','91770','60600','91750','77390','78830','60410','91650','77440','77440','95420','95420','60370','60620','91470','91830','77950','78440','60320','60700','91610','60800','60800','77390','77515','60370','60140','60620','78720','77950','77660','60620','78930','78520','60430','60370','60700','91730','60240','60800','78790','78790','77580','77310','60240','60410','77540','60240','78610','77950','95510','77440','77440','60410','78940','77515','60600','60600','77390','77310','95420','91760','60600','60840','91750','78125','60710','91530','91850','91530','60240','91910','91730','78890','77515','77390','60240','78930','78200','78711','60600','78490','78910','77120','78200','60600','60240','91510','91510','60800','60129','77440','77440','95420','60620','60800','78930','95510','77145','78520','78910','78790','60430','91580','60390','60710','78910','60134','91730','91410','60190','77120','60620','77350','78610','78930','78930','77390','77640','60134') AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='864' AND wish_id<>'635232' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
0.0001
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
0.0001
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)
0.0002
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 <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 549802
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 143984
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 547305
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 274132
0.0001
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
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 547305
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 546401
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 546386
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 544098
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 542210
0.0001
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
0.0001
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)
0.0001
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 <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 538486
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 864
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
0.0001
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
0.0003
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
0.0002
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
0.0002
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
0.0002
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
0.0002
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
0.0002
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
0.0002
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
0.0001
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
0.0001
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
0.0002
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
0.0002
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0002
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
0.0009
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0287
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'
0.0221
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

87 requetes sql en 0.0846

Taille variable Globale : 83.74 KB