Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

9 places pour association (3 semaines)

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

Discuter

Ce voisin demande à louer à Gavrelle (62580)

1000€/Faire offre

Prix

1000€/Faire offre

-6500kgqu'à l'achat

Description de l'annonce

Bonjour, je suis à la recherche d'une location d'un 9 places du 05/07 au 29/07 pour l'Association d'Education Populaire de Gavrelle (62580)
#minibus

Annonces similaires

Tout voir
Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION D'UN MINI BUS 9 PLACES
Profil du voisin
Voisin #524467

Cuincy 59553

115€/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

MINIBUS/VAN (2 SEMAINES)
Profil du voisin
Barbara D

Festubert 62149

1000€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINIBUS (2 JOURS)
Profil du voisin
Romuald G

Lille 59000

250€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINIBUS 9 PLACES
Profil du voisin
Lorenza D

Vendin-le-Vieil 62880

650€/sem

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

VEHICULE 9 PLACES
Profil du voisin
Christophe D

Iwuy 59141

1500€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINIBUS : 8 JOURS 700KM
Profil du voisin
Blandine C

Hazebrouck 59190

680€

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

RECHERCHE UN MINIBUS 9 PLACES (3 JOURS)
Profil du voisin
Bertrand U Voisin vérifié

Santes 59211

330€

Location minibus
Location minibus

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOCATION MINIBUS 9 PLACES
Profil du voisin
Geoffrey A

Wervicq-Sud 59117

485€/sem

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

  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

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

  7. 0.0001

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

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=863 LIMIT 1

  31. 0

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

  32. 0.0001

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

  33. 0

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

  34. 0

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

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

  36. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='402228' 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 = '546759'

  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='402228' AND wish_id<>'546759' 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='62580'

  40. 0.0052

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.35*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.35*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.91667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.900339197041 AND ville_latitude_deg<50.799660802959 AND ville_longitude_deg>2.2119714660788 AND ville_longitude_deg<3.6213685339212 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0041

    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 (62580,62490,62580,62580,62490,62580,62320,62320,62320,62580,62320,62580,62490,62580,62490,62118,62580,62118,62118,62118,62680,62118,59553,62580,62117,62118,62110,62420,62210,62223,62430,62580,62950,62223,62490,62740,62118,62640,59552,62490,62156,62112,62221,62218,62223,62223,62112,59553,59553,62970,62300,62156,62119,62580,59552,59500,59169,62223,59128,62490,62156,62300,62490,62156,62440,62710,62580,62156,62128,62223,62156,62128,62217,59151,62223,59950,62000,62153,62223,62141,59259,62800,62128,62880,62156,62217,62880,62880,62217,62128,62880,59169,62590,59162,62860,59286,62143,59151,62790,62217,62217,62128,59187,62128,59450,62750,62860,59119,62153,62128,59151,62182,59283,62220,59169,62144,62217,62860,62860,62410,62182,62144,62161,62161,62410,62182,62860,62000,59283,62410,62820,62128,59287,59169,62410,62182,62128,62160,59261,62175,59194,62160,62160,59194,59151,62161,59239,62860,59182,59287,62144,59151,62860,59167,62128,59169,62217,62860,62173,62128,62128,59185,62161,62860,59221,59112,62138,62144,62860,62860,62128,59133,59239,62175,62172,62860,62123,59182,62138,59246,62980,59234,62175,62860,62530,59133,62121,62114,59265,62123,59176,62690,59310,62670,62690,62144,62138,62530,62128,59112,59551,62175,62980,59251,62173,59496,59148,59551,62138,62123,59147,59265,62173,62123,62149,62175,62121,62860,59496,59176,62690,62121,59234,59146,62690,59710,62149,62530,62860,62149,62690,59480,59234,62123,62123,59235,62173,59272,59184,62159,62138,62690,62860,62121,59147,59274,59165,62113,62113,59147,62159,62149,59310,62123,62123,59247,62290,59265,59870,62690,62123,59247,62123,59710,59710,62150,59490,59113,59580,62690,62123,59580,62690,62620,62159,59136,62116,62860,62116,62124,62113,59134,59554,59134,62147,62150,59252,62810,62121,62121,59480,59263,62660,62116,62690,59265,59310,59265,62123,59554,59247,59870,62147,59870,62150,62121,59710,59242,62111,62149,62116,59175,62840,62121,62131,62620,59310,59252,59268,62123,62450,62124,59554,62690,62450,59134,59490,62690,62131,62131,62620,62123,62123,62124,62690,59175,62450,62124,59400,59252,62810,62147,62147,62810,59870,59139,62450,59554,62620,62940,59242,59273,62150,59400,62690,62810,62147,59179,62690,59215,62150,62690,59554,59139,62840,62121,59111,59172,59134,62450,59211,62196,62124,59155,62158,59249,59320,62450,62232,62810,59295,59295,62810,62136,62450,62400,59320,59249,59171,59267,62121,62147,62116,62400,59267,62111,62450,59870,62127,59310,62810,59310,59400,59161,62158,59141,62232,59554,62111,59111,62150,59242,62232,62232,59320,62111,59810,62136,59267,59171,62450,59320,62124,59320,59320,62450,59134,62127,59870,59111,59273,62400,59310,62700,59161,59830,62158,62199,62124,59320,62127,62158,59172,62810,62136,59159,62116,80300,62450,59400,62150,59870,59120,62124,62450,62810,62111,59790,80300,62127,62127,59124,62127,59310,59178,62150,62122,59156,59141,59159,59141,80300,62158,59262,62111,62124,59293,59230,59830,62920,59320,62150,62450,59320,59310,62147,59161,59171,62124,59178,59830,62920,59830,62232,59159,59111,62127,62760,59281,62124,62460,62810,62450,59400,59230,62460,62810,62810,62111,59260,62122,62540,80300,62450,59161,62760,59310,59690,62127,62127,59220,59000,62840,59800,59160,59350,59777,62124,59830,62127,62450,62111,59231,59840,59280,59160,62124,59241,59282,80300,62124,59830,62840,80360,59178,62136,59282,62810,62158,59400,59226,62470,80360,59400,59152,59152,59255,62127,59135,62460,59130,62810,62810,59940,59830,62920,80300,62127,62810,62350,62540,59296,59152,59110,62840,59277,62158,59253,62130,59780,62810,62111,80560,62470,59370,62760,80300,80360,80360,62450,80360,59840,59178,80360,59220,62127,59350,62127,59840,80360,80560,62157,80360,62270,62760,62760,62260,80600,59400,59231,59400,62760,59780,80360,59152,62350,80560,59258,80560,59226,59195,62810,59135,59220,62127,59510,80300,80560,62450,80300,59121,59217,80360,62260,62760,62130,59930,59129,59700,59280,62550,59198,62810,80360,62350,59258,59231,59258,59660,59193,59266,59188,62810,59237,80360,80240,62550,59940,59520,59230,62151,59195,62130,62130,62760,80300,59121,62130,62550,59400,59217,62130,59118,80560,59224,62270,80300,62550,62350,59188,80560,62350,59780,59494,80300,80560,59170,59290,80122,59510,80360,59116,59297,62810,59217,59266,62190,62130,62130,80600,62270,80300,59850,80560,62350,80300,62130,62550,80560,59390,80240,59940,59224,62270,59127,59292,59217,62760,59158,62260,59181,59227,59227,80240,80300,59157,62760,62550,59188,59266,62270,59174,59158,59494,80300,59491,59493,59650,59655,59590,59125,62130,62130,62550,59233,80560,80300,80240,80600,80200,59236,62190,80760,59214,62760,59157,62760,62550,59910,62190,80300,59390,80360,59890,62130,59227,62270,59158,59230,80360,62130,59410,80300,59390,59191,59192,62130,62350,80560,80560,80560,59230,59390,62810,62190,62190,59420,62190,80740,62260,62550,80560,62760,80600,62550,59213,80560,80300,62130,62330,59158,59890,62130,59100,59300,02420,80300,62550,80112,62550,62190,62120,59294,59540,62270,62270,62130,80360,62270,62760,80560,59191,02420,80300,62550,59127,80360,80240,59269,80300,59199,59300,59213,59191,80240,80240,80360,59300,62130,59232,62130,62130,59127,59860,59115,59540,62760,62550,59200,62760,80600,80300,80560,62130,80560,59223,59250,59126,59560,59150,59730,62330,62270,59270,59199,59127,02420,80810,80740,80200,80200,59270,59142,80200,80200,62120,62190,80240,59770,59880,59271,62550,62134,59225,59730,59213,59213,62130,80560,59270,59269,62270,59225,59730,59270,62130,02420,80300,62134,02420,62134,80340,80240,80600,62120,62270,62960,62960,62270,62120,80600,59540,80600,02420,59189,62130,80300,59127,59970,59730,59990,80200,80240,62130,80200,80600,59278,59189,80300,59269,59213,59213,62120,59560,80200,80340,59730,59540,80600,62134,02420,62120,62960,80300,80300,80600,59117,80240,80340,62130,62130,59990,59960,62270,02110,80240,59990,80300,59166,62120,62120,62134,62134,62270,59980,59190,80600,59190,59980,59970,80200,80300,59530,62120,59189,59270,80200,80200,80600,02420,80200,80560,59270,80340,80240,80340,59990,62130,62130,59990,59163,62134,59264,62270,62270,59190,80200,59238,80560,80300,62145,80240,80300,62120,59190,62134,02110,62134,59360,59970,62130,62270,59530,80600,02490,80340,59980,59980,80300,59730,80340,02490,80560,80560,62130,62145,62270,59243,59190,59144,80980,02420,80630,62130,02420,62270) 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<>'546759' 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=524467 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 = 524467 AND W.type_id = 1) OR (W.util_id != 524467 AND W.type_id = 2)) AND (`post_util_id` = 524467 OR `dest_util_id` = 524467) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0002

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

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

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

  49. 0.0002

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

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

  53. 0.0001

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

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

  57. 0.0001

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

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

  61. 0.0001

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

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

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

  65. 0.0001

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

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

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

  69. 0.0001

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

  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=269054 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 = 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

  73. 0.0001

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

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

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

  77. 0.0001

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

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

  81. 0.0001

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 863

  83. 0.0008

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

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

Taille variable Globale : 78.9 KB