Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Véhicule 9 places pour voyage association (3 jours

Retour Location Minibus Location minibus entre particuliers (77) Location minibus entre particuliers (77)

Discuter

Ce voisin demande à louer à Moissy-Cramayel (77550)

200€/Faire offre

Prix

200€/Faire offre

-6500kgqu'à l'achat

Description de l'annonce

Bonjour, Nous souhaitons louer un vehicule de 9 places pour un voyage de notre équipe de baseball jeunes (11 ans). Nous allons à un tournoi et devons faire 1200KM au total.
Merci de le contacter des que possible.
#minibus

Annonces similaires

Tout voir
Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION D'UN VAN (5 JOURS)
Profil du voisin
Laurent D

Montmagny 95360

600€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINIBUS / VAN / VITO (4 JOURS)
Profil du voisin
Tiphaine B

Levallois-Perret 92300

250€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE MINIBUS à LOUER (10 JOURS)
Profil du voisin
Vanessa V

Clichy 92110

1150€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOUER UN MINI BUS (PENDANT UNE SEMAINE)
Profil du voisin
Voisin #57105

Montmorency 95160

300€/sem

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

CHERCHE 2 SEMAINES MINIBUS 5 PLACES
Profil du voisin
Voisin #127210

Draveil 91210

750€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

DEMANDE DE LOCATION MINIBUS OU 8 PLACES
Profil du voisin
Marie clotaire B

Savigny-le-Temple 77176

150€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOCATION MONOSPACE OU MINI BUS
Profil du voisin
Voisin #33525

Lizy-sur-Ourcq 77440

450€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOUER MINIBUS 9 PLACES PENDANT 4 JOURS
Profil du voisin
Voisin #36846

Rosny-sous-Bois 93110

400€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION D'UNE GRANDE VOITURE EN JUILLET
Profil du voisin
Veronique J

Issy-les-Moulineaux 92130

175€/sem

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

CHERCHE MINIBUS 9 PLACES éTé 2022
Profil du voisin
Sophie P

Brétigny-sur-Orge 91220

500€

Louer un minibus entre particuliers ou proposer un minibus 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='538114'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='minibus' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='863'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'minibus' LIMIT 1

  5. 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'

  6. 0.0001

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='389448' 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` = 389448

  9. 0.0001

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

  10. 0.0002

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

    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.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 (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.0004

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

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

  22. 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 (173) ORDER BY ssrubr_order ASC

  23. 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 (83) ORDER BY ssrubr_order ASC

  24. 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 (93) ORDER BY ssrubr_order ASC

  25. 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 (193) ORDER BY ssrubr_order ASC

  26. 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 (91) ORDER BY ssrubr_order ASC

  27. 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 (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 = 538114

  30. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=863 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0001

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

  35. 0.0002

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

  36. 0.0001

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

  37. 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 = '538114'

  38. 0.0003

    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='389448' AND wish_id<>'538114' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 0.0001

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

  40. 0.0085

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.68333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.167039197041 AND ville_latitude_deg<49.066360802959 AND ville_longitude_deg>2.0031453945676 AND ville_longitude_deg<3.3635146054324 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0065

    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 (77550,77550,77390,77111,77950,77950,77111,77550,77390,77950,77166,77170,77950,77550,77390,77390,77240,77166,77950,77390,77240,77950,77390,77170,77390,77115,77176,77720,77000,77176,77000,77127,77390,77350,77380,77115,77220,77000,77390,77173,77720,91480,77190,77220,77350,77240,91480,77820,77310,77000,91800,77350,77170,77390,77720,77220,77150,94520,94520,91280,77610,91250,77390,91250,77310,77150,77390,94440,77310,91860,77220,91830,91250,91250,77720,91100,77590,77720,77820,77720,94440,91450,77190,77590,94440,77610,91800,77390,77330,77590,77610,91000,91090,91830,91330,91450,91100,77720,77930,77820,77930,77220,77930,77610,77720,91750,77920,91540,91540,94470,91230,77630,77850,94450,91090,77540,94510,91000,91130,77540,77610,94380,94370,77610,77135,77133,91560,91750,77680,91750,77930,77930,91080,77720,91210,94490,94880,94880,77930,77370,77340,77720,77870,94190,91540,77133,91270,77610,94460,91070,77540,91540,77630,94380,91840,91350,77540,94480,91170,77184,77210,77164,77830,91260,91700,94290,91200,77370,94430,77540,94420,77174,91810,77183,77090,77300,91610,77210,77630,94000,77540,94210,94100,94340,91710,77370,91490,77370,77370,77185,77600,91590,77174,91890,77370,91390,91600,77830,77810,77163,94500,94390,94310,77131,77430,94600,77830,91550,91700,91490,77600,77600,77600,94350,77700,77200,77186,91360,91490,77420,77515,77600,77600,91220,91220,77700,94360,93160,91420,94340,91770,94700,91360,91630,94320,94410,77131,91590,77670,77400,77400,94400,77400,77360,77540,91760,77670,93330,94130,77144,91240,94140,91700,77370,94150,77154,91590,91630,91320,77163,91490,93460,77250,77370,94170,91590,91310,77700,77250,77163,94550,94220,77970,77400,91380,91160,77130,77400,94120,77400,77177,77760,91160,91820,91490,77500,77700,77144,77141,91850,93360,77580,77515,77580,77130,77120,91310,91310,77370,77120,94260,77154,91620,91290,77370,77760,77123,77515,94800,94160,91630,77250,94200,94205,77148,93110,91820,91160,77370,91720,91630,77780,77580,77400,77450,93220,94239,94238,94237,94236,94235,94233,94232,94231,94230,77515,94234,94240,91590,77690,91590,94300,92160,91310,91180,91160,77580,77580,77860,91290,77760,91300,77250,77123,92340,94270,77450,91630,77250,77130,93250,77860,77520,91510,91510,93370,77700,91720,77130,77520,94110,77120,77450,77515,91460,77148,91140,91620,93100,77370,77450,77880,77410,77760,77410,77970,77130,93130,77123,77181,91120,77690,93340,93320,77250,91590,91140,77450,94250,77120,93170,91370,77181,93470,77760,77580,91730,91520,91340,92330,92260,92220,77860,93390,93190,91590,91880,92290,93230,93260,92120,77520,77370,77450,91790,91720,77140,93140,77130,77410,77120,77270,91680,92320,92350,77126,93000,92240,77130,77410,77760,91580,91730,77580,93310,77580,93410,77940,91580,77520,77580,77120,77940,77450,77130,91430,77520,75005,75003,75002,75000,75006,75116,75001,75013,75007,75014,75012,75020,75016,75004,75011,75010,75017,75018,75019,75009,75008,75015,92140,91720,77120,77120,93270,77250,77160,77130,91720,92170,77580,77410,77320,91650,77520,91570,77520,91720,77160,77940,77760,77580,77100,93500,91430,77410,77140,92130,91580,91400,77126,77126,77650,91910,91730,77970,77160,77450,77470,77710,91940,91650,93290,91940,77100,77760,77760,77130,92190,92360,77140,77410,77410,77140,93600,91150,77320,91440,77140,77650,93150,93700,91640,91720,91680,77130,77470,91640,91650,77410,77124,77100,77650,77520,77169,77970,92100,77160,93120,77470,93300,77940,77118,77120,77940,77120,77320,91400,91150,91150,91580,77470,93350,91580,45330,77520,77520,93420,77130,77580,93400,77410,77520,92370,77118,77520,77290,91940,77970,77760,91190,77710,77760,77760,77410,78350,77124,91640,77160,91640,91530,92310,91190,93440,77470,77760,77710,77156,78140,91400,91150,77710,92110,89340,91530,92210,93210,93200,77650,77940,77320,92200,77320,77230,77290,77167,77167,91150,77167,77650,77167,92410,77160,91470,77169,77124,77169,77760,77470,95500,92300,78220,77169,77160,77165,91190,93240,77470,92800,92150,91580,77650,77480,77940,77165,77165,91150,77124,95140,92390,93450,78350,78530,77890,77134,92600,89340,77118,77510,77560,78117,95500,91470,91150,77650,95700,77890,77710,77660,92380,92420,92430,45330,92400,77560,89140,77230,91150,89720,91150,77230,77230,45390,92250,77320,77320,77570,77167,78117,45330,77760,77320,77165,77990,77157,78470,77560,77640,92230,95500,91530,77160,45330,77710,91150,95400,78000,92270,77710,77890,93380,91150,89370,45330,77910,95500,93430,91470,77710,91470,91530,91150,77122,45330,77230,95360,77510,77160,92700,91150,93800,92500,77480,77480,77480,77230,77570,77910,77570,45390,45390,77230,89340,77114,77660,77260,91470,77650,77910,77560,77910,77990,77160,78170,45390,78150,78114,77165,91470,91870,95190,77260,77260,95880,95380,77890,77460,77320,92000,78460,77160,95410,77440,89140,77940,78830,77560,77560,29830,45300,95400,95200,77510,45330,78150,77510,95720,89140,91410,91690,95170,77710,77230,77230,95380,77640,78280,91150,78470,77460,77570,77440,77480,77230,95350,77230,77139,78800,95218,91410,95210,77320,78960,95100,77320,78290,78380,45390,78400,95870,77440,95380,77480,77890,91690,77750,95380,91690,77890,95230,78460,77320,77560,78420,77750,95440,77260,78210,45300,77165,77165,95160,91780,91780,77139,45300,77710,91410,77171,77320,78430) AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='863' AND wish_id<>'538114' AND wish_url='' ORDER BY rand() LIMIT 0,10

  42. 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='863' LIMIT 0,1

  43. 0.0001

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

  44. 0.0002

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

  45. 0.0003

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

  46. 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='863' LIMIT 0,1

  47. 0.0001

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

  48. 0.0002

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

  49. 0.0003

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

  50. 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='863' LIMIT 0,1

  51. 0.0001

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

  52. 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 = 181104 AND W.type_id = 1) OR (W.util_id != 181104 AND W.type_id = 2)) AND (`post_util_id` = 181104 OR `dest_util_id` = 181104) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0003

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

  54. 0.0004

    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='863' LIMIT 0,1

  55. 0.0001

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

  56. 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 = 57105 AND W.type_id = 1) OR (W.util_id != 57105 AND W.type_id = 2)) AND (`post_util_id` = 57105 OR `dest_util_id` = 57105) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0003

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

  58. 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='863' LIMIT 0,1

  59. 0.0001

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

  60. 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 = 127210 AND W.type_id = 1) OR (W.util_id != 127210 AND W.type_id = 2)) AND (`post_util_id` = 127210 OR `dest_util_id` = 127210) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0003

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

  62. 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='863' LIMIT 0,1

  63. 0.0001

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

  64. 0.0002

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

  65. 0.0003

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

  66. 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='863' LIMIT 0,1

  67. 0.0001

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

  68. 0.0002

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

  69. 0.0004

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

  70. 0.0002

    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='863' LIMIT 0,1

  71. 0.0001

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

  72. 0.0002

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

  73. 0.0003

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

  74. 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='863' LIMIT 0,1

  75. 0.0001

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

  76. 0.0002

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

  77. 0.0003

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

  78. 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='863' LIMIT 0,1

  79. 0.0001

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

  80. 0.0002

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

  81. 0.0003

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

  82. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 863

  83. 0.0017

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

  84. 0

    SELECT count(*) as nbwish FROM wish

  85. 0.084

    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

85 requetes sql en 0.1151

Taille variable Globale : 78.85 KB