Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Vehicule 9 places

Annonces similaires

Tout voir
Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE à  LOUER J9
Profil du voisin
Maxime G

Montigny-en-Ostrevent 59182

-- €

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION DE VOITURE 9 PLACES
Profil du voisin
Voisin #64454

Santes 59211

519€/sem

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOUER : MINIBUS 9 PLACES
Profil du voisin
Voisin #75397

Avesnes-sur-Helpe 59440

545€/sem

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINIBUS (3 JOURS)
Profil du voisin
Hamri A

Hem 59510

375€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION : VéHICULE 9 PLACES (11 JOURS)
Profil du voisin
Perrine P

Sars-et-Rosières 59230

500€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE MINIBUS (8 SEMAINES)
Profil du voisin
Voisin #101874

Duisans 62161

3600€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE MINIBUS
Profil du voisin
Keïna D

Courcelles-les-Lens 62970

80€/j

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE MINIBUS POUR 17 JOURS (2 SEMAI
Profil du voisin
Voisin #331932

Conde-sur-l'Escaut 59163

980€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOUER UN MINIBUS
Profil du voisin
Elisabeth D

Courchelettes 59552

45€/j

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

9 PLACES POUR ASSOCIATION (3 SEMAINES)
Profil du voisin
Elodie F

Gavrelle 62580

1000€

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

    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='571924'

  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='59'

  7. 0.0001

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

  8. 0.0001

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

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

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

  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.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 (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.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 (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 = 571924

  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='571924'

  32. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='571924' 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` = 432007 AND util_tel != ''

  34. 0.0001

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 432007 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 = 432007 AND W.type_id = 1) OR (W.util_id != 432007 AND W.type_id = 2)) AND (`post_util_id` = 432007 OR `dest_util_id` = 432007) 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='432007' 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 = '571924'

  38. 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='432007' AND wish_id<>'571924' 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='59141'

  40. 0.0073

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.767039197041 AND ville_latitude_deg<50.666360802959 AND ville_longitude_deg>2.5972723247262 AND ville_longitude_deg<4.0027276752738 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0055

    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 (59141,59161,59141,59141,59400,59161,59161,59295,59295,59161,59277,59554,59554,59400,59111,59111,59268,59247,59554,59252,59554,59265,59129,59111,59217,59296,59265,59188,59400,59111,59400,59252,59247,59247,59252,59400,59188,59217,59292,59267,59198,59188,59172,59400,59282,59265,59217,59172,59217,59400,59554,59554,62860,59214,59293,59265,59234,59157,59400,59227,59227,59265,59234,59282,59400,59157,59281,59156,59580,59267,59159,59234,59540,59241,59215,59127,59294,59151,62860,59258,59540,59124,59580,59191,59258,62860,59730,59165,59159,59224,59271,59224,59151,59191,59227,59730,59220,62860,59169,59121,59730,59400,59213,62860,62860,59220,59121,59225,59540,62860,59191,59258,62147,59176,59233,59169,59151,59220,59540,59213,59176,59255,59225,59730,59127,59179,62860,59730,59490,59171,59169,59171,59213,59213,62860,62860,59490,59269,59151,59125,59267,59171,59980,59182,59195,59287,62860,59213,59213,59360,59169,59135,59266,62860,62147,59195,59287,59980,59159,59182,59127,59730,62860,59870,59127,59300,59151,59231,62147,62860,59127,59135,62860,59146,59187,59174,59259,59980,59980,59980,59266,59269,62490,59530,59218,59218,59238,59269,62490,59142,59870,62156,59218,59494,02420,62182,59300,59167,59530,59870,62112,59360,59169,59222,59450,59494,59360,59870,62182,59266,59231,62147,59218,59222,59410,62490,59990,62112,62147,62156,62860,59990,62147,59300,59870,59552,62490,59530,59590,59119,59231,59360,02110,62860,59194,59178,02420,59297,59552,59770,62156,59192,59500,62124,59137,59530,59222,59530,59990,62117,59360,59530,62156,59530,62147,02110,59870,02420,59178,59870,59178,59530,02420,59880,59148,02110,59550,59860,62182,59530,59360,02110,59990,62182,59360,62124,59144,59178,62124,62156,59530,59194,02110,62118,62156,59288,59553,59553,62124,59230,59530,59990,62490,62159,59550,59230,59553,59230,62124,62156,59530,62118,62124,02420,80740,59310,62124,59310,59128,59286,62124,59360,02110,80122,02110,80360,62124,59144,62128,59530,62128,02110,62128,62128,80740,02420,59144,02420,59530,62128,80240,62490,02110,02110,59310,59264,62118,59144,59360,59144,62124,02110,59950,59283,80240,59226,80360,62118,62159,59990,62118,59360,59243,59278,62124,62790,62490,02110,59144,02420,80112,59310,02420,59310,62128,59530,59310,59690,02110,59158,80240,59226,62128,02420,62490,59990,59550,80240,62970,02420,62124,62118,62124,59144,59283,59310,59360,80360,59310,62450,62141,59970,02420,02230,59230,02630,62128,62124,62580,62118,62128,59360,62450,59199,59970,59970,80240,02630,59235,02420,02420,62950,59570,59144,62450,59310,59199,59230,59920,59162,80360,62128,62580,62450,02110,59246,62128,59163,62223,62159,59158,80240,02490,62320,62320,62119,62450,80240,02630,80240,62580,62450,02450,59158,62128,02110,02490,59570,59154,59550,02420,59310,02420,59550,02420,62121,80240,02110,62450,59570,62320,62450,62580,59570,59710,80360,02110,80240,62110,02450,80240,59158,62128,62128,62223,62121,62121,62580,59570,59239,62450,62217,59163,62121,59242,59570,62217,62320,62580,59551,62450,59261,80760,62580,02100,02100,02490,62640,02490,02100,62175,59570,59570,62217,02110,80240,02110,62450,59242,02490,62590,59145,59710,62820,02510,59163,02110,02510,02450,62420,59570,59239,02450,62450,80240,59570,62580,62740,59550,62450,59550,80360,59242,02120,80240,02510,62223,62710,62121,62450,59145,62175,62680,80360,62450,02100,59710,59830,62217,62121,02100,80200,59830,02120,02120,80200,62000,59570,62450,59550,02110,80200,59830,02490,59551,62220,62121,59138,62430,59620,62175,02170,80360,80360,62121,59620,62580,02110,62217,62217,62223,59710,62121,62223,62440,80240,62580,02110,80200,02120,62880,59273,62210,02100,59133,80240,02450,59830,02450,80200,80360,62223,59244,62221,62218,02100,59830,80360,62175,59138,59830,02760,80200,02120,59620,02510,80240,80360,02120,59273,62223,59570,59244,59550,59133,59440,80240,59138,62173,02490,62175,62450,59138,62880,62880,59570,62223,62580,62116,59620,62121,02100,02100,62300,59112,59780,59570,80200,62300,80200,62217,02170,62116,02760,02720,80200,02120,59440,02170,80300,59244,80360,80300,02490,02120,62880,02490,62173,59330,02450,59830,59113,59147,59262,02490,02120,62116,80200,62000,62580,80360,59175,80200,80300,02390,02120,80300,02100,59175,59780,02720,59810,62116,59330,59185,59152,59251,80200,80300,80200,62450,80360,59152,62410,59152,02720,62153,59147,02170,80360,62410,80200,62116,59440,59112,62173,62800,59330,62173,59620,59147,59155,80300,80200,62161,62161,80300,62116,80360,59440,59263,80200,62410,59139,80200,02430,02100,59221,02120,02390,02120,02680,62161,59750,59152,59790,62750,62143,02390,59330,59330,62144,59330,62111,02170,59440,02240,02590,62410,02120,02590,62138,62153,62123,59440,59139,59440,80200,62123,02590,02590,59272,62161,80300,02390,80200,80200,80300,80360,62123,62123,80300,02120,80200,59260,02680,59440,62144,02240,62123,59780,02680,02680,80300,80200,59184,02590,02680,02590,80340,59496,02120,02120,02120,62138,80300,59510,02590,02620,02120,02260,62111,59440,02240,59219,62123,59330,62123,59136,62123,80400,80300,80200,02590,59440,59440,80300,59320,59720,59440,62111,02120,02240,62160,62160,59600,59600,62144,62160,80300,59274,59390,59320,02690,80340,80200,02120,62123,59496,62111,02120,80200,62144,80340,02790,62123,80300,59440,62138,59510,02240,62111,59219,59120,02260,02480,62123,62111,80200,59600,62144,59800,59350,59777,59160,59000,59370,80980,59211,02120,80200,62123,62123,80300,59219,62138,59134,62690,02120,59320,59600,80300,59680,02590,02590,62980,62111,59480) 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<>'571924' 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=71554 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 = 71554 AND W.type_id = 1) OR (W.util_id != 71554 AND W.type_id = 2)) AND (`post_util_id` = 71554 OR `dest_util_id` = 71554) 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 = 71554

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

  49. 0.0002

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

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

  53. 0.0002

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

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

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=269054 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 = 269054 AND W.type_id = 1) OR (W.util_id != 269054 AND W.type_id = 2)) AND (`post_util_id` = 269054 OR `dest_util_id` = 269054) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0002

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

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

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232643 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 = 232643 AND W.type_id = 1) OR (W.util_id != 232643 AND W.type_id = 2)) AND (`post_util_id` = 232643 OR `dest_util_id` = 232643) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0002

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

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

  65. 0.0002

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

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

  69. 0.0002

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

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

  71. 0.0001

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

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

  73. 0.0002

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

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

  75. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=42540 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 = 42540 AND W.type_id = 1) OR (W.util_id != 42540 AND W.type_id = 2)) AND (`post_util_id` = 42540 OR `dest_util_id` = 42540) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  77. 0.0002

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

  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=402228 AND note_visu IN (1,3,4)

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

  81. 0.0002

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

  82. 0.0002

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 863

  83. 0.002

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

  84. 0.0001

    SELECT count(*) as nbwish FROM wish

  85. 0.0813

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

Taille variable Globale : 78.87 KB