Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Location d'un mini bus pour le week-end

Annonces similaires

Tout voir
Location location renault trafic
Location : location renault trafic

Demande il y a + de 30j

Il y a + de 30j • 91310

Cherche van ou trafic (pour 3 semaines)
Profil du voisin
Voisin #79397

Leuville-sur-Orge 91310

1500€

Louer mon van
Location location renault trafic
Location : location renault trafic

Demande il y a + de 30j

Il y a + de 30j • 92700

Loue trafic 8-9 places (août 15 jours)
Profil du voisin
Ayman B

Colombes 92700

850€

Louer mon van
Location location renault trafic
Location : location renault trafic

Demande il y a + de 30j

Il y a + de 30j • 77420

Louer véhicule 9 places (5 jours)
Profil du voisin
Thomas C

Champs-sur-Marne 77420

450€

Louer mon van

Louer un renault trafic entre particuliers ou proposer un renault trafic en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php
  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 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='251104'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='location-renault-trafic' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='484'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'location-renault-trafic' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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='173'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='23814' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 23814

  9. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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 (176) ORDER BY ssrubr_order ASC

  17. 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

  18. 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 (208) ORDER BY ssrubr_order ASC

  19. 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 (228) ORDER BY ssrubr_order ASC

  20. 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 (207) ORDER BY ssrubr_order ASC

  21. 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

  22. 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

  23. 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

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 251104

  30. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='251104'

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='251104' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  32. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 23814 AND util_tel != ''

  33. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 23814 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  34. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 23814 AND W.type_id = 1) OR (W.util_id != 23814 AND W.type_id = 2)) AND (`post_util_id` = 23814 OR `dest_util_id` = 23814) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='23814' AND note_visu IN (1,3,4)

  36. 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 = '251104'

  37. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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='23814' AND wish_id<>'251104' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  38. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='93220'

  39. 0.0064

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.53333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.8495268758251 AND ville_longitude_deg<3.2171331241749 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0008

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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 (93220,93360,93340,93320,93250,93370,93460,93330,93390,93190,93110,93160,94170,93130,77500,94120,77181,93470,93140,93270,94350,94360,93410,77420,93000,94130,77181,93230,93260,77177,94500,93600,93100,94420,94300,77186,77185,93700,77270,93150,93290,93170,77360,94340,94410,93420,77410,77200,94430,94100,94210,94340,77184,93310,93500,93350,94160,77340,77400,77400,94490,94880,94880,77183,77090,94220,93440,93300,77600,93120,94510,94700,95500,94000,77400,95140,94140,77680,77290,95500,77600,77600,94370,94380,95700,93240,94200,94205,77400,77410,94380,95500,77400,77400,77600,95500,77410,93200,93210,95400,75010,75001,75000,75002,75014,75007,75018,75008,75013,75012,75009,75011,75015,75006,75017,75019,75004,75003,75005,75116,75020,75016,77410,94270,77164,77400,93400,94400,94470,93380,77135,77410,94800,77600,94600,94460,95190,77990,92390,93450,77410,77144,77290,77330,95360,93430,94250,77410,95720,94440,95380,77600,95380,95400,95200,94320,77700,77144,77990,94450,92110,94110,95410,77450,92120,77230,94310,94390,77150,94190,77230,95350,92230,92170,93800,77230,77150,95880,95170,92300,77450,94233,94230,94232,94240,94234,94238,92600,94231,94239,94235,94236,94237,95440,94440,95380,95380,92240,94550,77700,94440,91330,95720,94290,77170,77410,77410,92220,92200,91560,77230,95190,95160,77700,77410,92270,92340,95350,77230,94150,95230,94480,94520,94520,95218,95210,92320,91800,95470,92400,95460,77230,95380,92250,77450,77700,77230,77450,77174,92130,77173,91200,95720,77230,77230,92700,91230,95190,77410,92330,92260,95580,77165,95580,77450,92100,77700,77230,92140,95850,94260,77450,95100,77450,92150,92800,91270,95330,91550,91320,77220,91800,77450,91860,95670,95470,95600,77165,77165,95120,77220,92350,77230,95720,77165,92160,95110,95570,91480,92360,92190,95850,77170,77860,77174,77580,92290,95680,95570,92210,95870,95270,91210,77220,91480,95470,77380,77166,95470,92500,77860,60128,77220,77230,92000,95390,91370,95130,95270,77124,78800,91300,95270,77280,91260,95270,95270,77100,91420,77230,95570,60330,95570,77100,95130,77124,95320,92310,77610,77165,77860,95560,92410,78420,92380,92370,60128,77166,60950,77122,91170,95560,91160,77220,91380,78500,91450,77124,95240,92420,92430,77580,77580,95560,95270,77170,95530,78140,60330,95560,91000,95270,91130,77390,77100,77580,91570,95270,91600,91390,77610,95270,95840,60520,60560,91120,77127,77124,95370,91250,78400,77580,91350,77111,91360,77178,91450,91160,78360,78170,78220,91000,91090,95250,95550,95150,77610,91430,77163,95590,91360,78600,77178,77610,91140,77111,77580,78290,78380,77470,60330,77910,91430,91160,77165,77165,95740,60520,91280,95220,77910,78350,91250,60520,95840,77550,60580,77163,77163,91160,78600,95270,60950,91700,78560,77139,78110,77580,78430,60260,78150,95480,77470,77610,78000,95270,77470,60330,78150,95590,91700,77390,77580,91080,77550,60950,91140,77470,95270,91700,91250,91400,91070,77550,77610,91100,78230,95540,77610,77470,77910,78350,78530,77550,60440,91620,77580,77515,95590,91090,77390,91240,77139,91400,78750,78100,60440,95630,78160,95430,77390,77910,77470,78870,95260,91310,60300,60300,77390,77176,78700,77139,91220,91220,95430,77390,77470,91440,91100,78117,60440,95260,95290,91310,91310,91620,77580,78112,78620,77580,60820,95760,77515,78590,60270,77139,95660,91190,77540,60300,60440,95620,60300,77950,91940,95610,77440,60440,60300,60300,95820,77390,91250,91830,78260,78210,77515,77176,60300,60500,77390,91460,95340,77950,77240,60500,95310,77390,91190,77240,78300,78590,95340,78570,78117,60300,91540,91540,91940,77660,78330,77515,91310,78780,91540,77950,78280,77580,78240,95300,77440,77120,91190,91940,77950,77131,77390,77440,77240,95000,60460,91810,78955,77120,77390,77540,60740,60300,77440,95300,60230,77660,91180,77390,95690,78240,95300,95000,78860,60530,60440,78114,60340,77390,77720,78570,78450,91640,77515,60340,60810,91540,78960,60300,91630,77139,77720,91290,77540,78470,60620,78180,77120,91400,77310,78390,60300,77310,60810,77950,91710,60620,60440,95340,91830,60530,77131,78470,91630,91290,77640,95280,77440,77440,95690,77350,91750,78670,78670,77115,95520,77440,60620,95300,60440,60810,77950,91680,60460,77440,77440,95690,77540,95490,77000,77000,60530,91630,60530,78630,78450,78510,78190,77120,77720,91520,91340,60620,95650,95690,60620,60800,77540,77310,78460,91640,77260,77260,77720,91630,78340,77120,77350,60700,77540,95810,91610,91750,77350,78540,60530,78470,60160,60800,78810,60810,91770,77190,77120,95000,78480,77260,95650,77145,91470,91470,60620,60800,91630,60660,77540,91470,95650,77115,60540,60540,77720,77000,91680,77440,95800,60620,60530,91640,91750,60100,95810,95180,77120,60180,60540,60160,60810,91760,78370,95810,91470,77820,91650,77000,91790,77720,60620,78121,91640,78460,91470,78810,78740,77440,60810,60660,60660,60530,78720,77120,78990,77640,78630,91850,60620,91650,60800,60540,60660,60660,77260,77930,60550,77169,60870,60810,91590,91730,78320,60890,77190,77720,78130,95650,95650,77840,95810,60620,78720,60800,77370,78740,77510,95810,77930,60800,78320,91510,91510,78580,91530,60540,78850,77169,91590,77440,91650,78920,60110,95450,95830,77720,60410,60800,95450,60620,95810,77260,77720,77141,78720,77590,77930,60870,60870,77260,95450,91840,77930,91590,60700,60110,77720,78320,60290,60700,91730,91910,78640,60290,60890,95830,60620,77370,78130,77820,91890,91730,78640,78310,77120,60700,78830,77930,60250,78410,60800,60620,60660,60800,78250,78310,78580,60410,95810,77750,77590,77120,78760,91470,60890,95450,60730,60410,77590,60117,77970,95640,77840,78720,91580,77370,91530,78250,60320,60730,91590,77169,78640,60890,77930,60940,60940,60940,95450,77260,77138,60140,91490,60700,77630,60800,60129,95640,77820,78250,60250,60290,60410,60110,78124,60570,77750,78124,02810,78650,91590,60730,60890,78580,78830,91530,95450,91580,77440,78640,60410,78250,78250,78410,77730,91580,77169,60570,60141,60119,91590,78690,95640,78690,77320,60250) AND fami_id='5' AND cate_id='173' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='484' AND wish_id<>'251104' AND wish_url='' ORDER BY rand() LIMIT 0,10

  41. 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='484' LIMIT 0,1

  42. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=79397 AND note_visu IN (1,3,4)

  43. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 79397 AND W.type_id = 1) OR (W.util_id != 79397 AND W.type_id = 2)) AND (`post_util_id` = 79397 OR `dest_util_id` = 79397) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  44. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 79397

  45. 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='484' LIMIT 0,1

  46. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104215 AND note_visu IN (1,3,4)

  47. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104215 AND W.type_id = 1) OR (W.util_id != 104215 AND W.type_id = 2)) AND (`post_util_id` = 104215 OR `dest_util_id` = 104215) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  48. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 104215

  49. 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='484' LIMIT 0,1

  50. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=61030 AND note_visu IN (1,3,4)

  51. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61030 AND W.type_id = 1) OR (W.util_id != 61030 AND W.type_id = 2)) AND (`post_util_id` = 61030 OR `dest_util_id` = 61030) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  52. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 61030

  53. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 484

  54. 0.001

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  55. 0

    SELECT count(*) as nbwish FROM wish

  56. 0.0508

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

56 requetes sql en 0.0653

Taille variable Globale : 75.6 KB