Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Volkswagen crafter (16M3) 7 places

Retour Location Fourgon

(Photo non contractuelle)

Location fourgon 62 entre particuliers Location fourgon 62 entre particuliers

Réserver

Ce voisin propose en location à Lorgies (62840)

90€/jour

Prix

90€/jour

-9000kgqu'à l'achat

-13% qu'en magasin

Description de l'annonce

Location d'un Volkswagen crafter 7 places 16 M3, idéal sortie vélo, moto ou tout autre loisirs.
Sortie clubs...
Livraison possible ou stationnement de vos véhicules sur place


#fourgon

Autres annonces du voisin

Tout voir
Service mecanique auto
Service : mecanique auto

Lorgies 62840

Mécanique auto/moto
Profil du voisin
Jouglard A

Lorgies 62840

30€/h

Demander ce mécanicien
Location motoculteur
Location : motoculteur

Lorgies 62840

Location motoculteur
Profil du voisin
Jouglard A

Lorgies 62840

45€/jr

Louer le motoculteur
Location utilitaire
Location : utilitaire

Lorgies 62840

Location plateau porte voiture 2.5t
Profil du voisin
Jouglard A

Lorgies 62840

60€/jr

Louer l'utilitaire
Location utilitaire
Location : utilitaire

Lorgies 62840

Location plateau porte voiture 2.5t
Profil du voisin
Jouglard A

Lorgies 62840

60€/jr

Louer l'utilitaire
Location outils auto
Location : outils auto

Lorgies 62840

Location outillage mécanique auto
Profil du voisin
Jouglard A

Lorgies 62840

20€/jr

Louer ces outils
Location remorque
Location : remorque

Lorgies 62840

Remorque moto
Profil du voisin
Jouglard A

Lorgies 62840

45€/jr

Louer la remorque
Location remorque
Location : remorque

Lorgies 62840

Remorque moto
Profil du voisin
Jouglard A

Lorgies 62840

45€/jr

Louer la remorque

Annonces similaires

Tout voir
Location fourgon
Location : fourgon

Bruay-la-Buis... 62700

Jumpy hdi
Profil du voisin
Vincent

Bruay-la-Buissiere 62700

50€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Lille 59000

Camion 20m3
Profil du voisin
Fast n S

Lille 59000

80€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Montigny-en-O... 59182

Location de camion avec chauffeur
Profil du voisin
Hossain B
100% fiable

Montigny-en-Ostrevent 59182

30€/h

Louer le fourgon
100%
Location fourgon
Location : fourgon

Lens 62300

Location camion 20m3 avec hayon
Profil du voisin
Mehdi M

Lens 62300

-- €

Louer le fourgon
Location fourgon
Location : fourgon

Lille 59000

Camionnette disponible
Profil du voisin
Khalil O

Lille 59000

8€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Arleux-en-Goh... 62580

Kangoo cabine approfondie
Profil du voisin
Anthony B

Arleux-en-Gohelle 62580

80€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Ronchin 59790

Location fourgon
Profil du voisin
Voisin #291162

Ronchin 59790

100€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Annoeullin 59112

Master 2.5 cdi 120 chx
Profil du voisin
Jean-pierre H

Annoeullin 59112

60€/jr

Louer le fourgon
Location fourgon
Location : fourgon

Lille 59000

Fourgon 8 m3
Profil du voisin
Marc D

Lille 59000

55€/jr

Louer le fourgon

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='fourgon' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='978'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'fourgon' 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='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='111707' 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` = 111707

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

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

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

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

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

  30. 0.0001

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

  31. 0.0001

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

  33. 0

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

  34. 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 = 111707 AND W.type_id = 1) OR (W.util_id != 111707 AND W.type_id = 2)) AND (`post_util_id` = 111707 OR `dest_util_id` = 111707) 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='111707' 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 = '312440'

  37. 0.0002

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

  38. 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='963' LIMIT 0,1

  39. 0.0001

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

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

  41. 0.0003

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

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

  43. 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 = 111707 AND W.type_id = 1) OR (W.util_id != 111707 AND W.type_id = 2)) AND (`post_util_id` = 111707 OR `dest_util_id` = 111707) 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 = 111707

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

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

  47. 0.0002

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

  48. 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='730' LIMIT 0,1

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

  50. 0.0002

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

  51. 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='1146' LIMIT 0,1

  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 = 111707 AND W.type_id = 1) OR (W.util_id != 111707 AND W.type_id = 2)) AND (`post_util_id` = 111707 OR `dest_util_id` = 111707) 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 = 111707

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

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

  56. 0.0001

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

  57. 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='727' LIMIT 0,1

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

  59. 0.0001

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

  60. 0.0001

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

  61. 0.0046

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.133639197041 AND ville_latitude_deg<51.032960802959 AND ville_longitude_deg>2.0751460928827 AND ville_longitude_deg<3.4915139071173 HAVING distance <= 50 ORDER BY distance ASC

  62. 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 (62840,62840,62136,59480,59249,62136,59249,59134,62149,62138,59480,62840,62136,59134,62149,59496,59274,59134,59940,62138,62138,62840,62149,62136,59134,59253,59496,62138,62840,62400,59184,62400,62138,59136,59134,62149,59272,59320,62660,59221,59280,62149,62113,62113,59940,59320,59320,62410,62410,62410,62980,62232,59211,59660,59112,62400,59185,59940,59193,62980,62410,62350,62113,59320,59181,59320,59251,62232,62232,59280,59850,62920,59147,62350,59930,62290,59840,62232,62131,62131,59320,59320,62670,62880,59320,59147,62131,62880,62880,62750,59160,62232,59112,59147,62160,59320,62350,62920,59263,62350,59840,62196,62199,59133,59116,62880,62620,62920,62114,59139,59232,59120,62350,59270,62440,62122,62300,59270,62220,62160,62530,59270,62221,62218,59840,59113,59133,59236,62710,59270,62350,62800,62300,62143,62350,59139,59237,59175,62620,59130,62122,62740,62590,62940,62620,62160,62430,62640,62820,59155,59175,62700,59551,62172,59350,62420,59890,62620,62210,59777,59350,59800,59160,59000,62157,59270,62530,59261,59270,59239,62540,59190,62680,62190,59890,59110,62540,62110,62330,59560,59190,59118,62119,59239,59710,62530,62580,62190,62153,59790,59520,59190,62150,62153,59190,62150,59270,62144,59190,62151,59162,62150,59700,59189,59551,62150,62950,62320,59810,62690,59189,62190,62320,59370,59260,62330,62460,62470,62150,62320,62320,62580,62260,62141,59710,62190,59299,62580,62150,62970,59273,62470,62580,62690,59189,59710,62260,59246,59710,62144,62150,59114,59910,59270,59283,62460,62190,62120,62580,62580,62790,62150,62190,62190,62580,59560,59114,62690,62690,62580,62550,59950,62144,62490,59173,62580,59223,59250,59190,59126,62260,59283,59262,62120,62120,59273,62120,59290,59170,62580,62144,62120,59650,59493,59491,59655,59242,62260,62690,59117,59190,62127,59128,62223,59420,59114,62490,59310,62690,62550,59242,62150,59286,62580,59235,62550,59830,62120,62690,62690,62127,62120,62580,59510,62460,62550,62690,59670,59553,59553,59553,62550,62690,62550,59166,62120,62120,59152,59152,62120,62120,62223,59830,62190,62490,62223,62144,59173,59200,59114,62550,62690,59190,62550,59100,59173,62161,62161,59510,62550,62550,62145,59152,59830,59670,62690,59152,62960,62960,59194,62130,62550,59242,62490,59500,62690,59310,59670,62223,62223,62223,62223,59173,59960,59390,59390,62120,59390,62120,59830,59670,62127,59552,62127,62120,62120,59780,62118,62161,59670,62690,62117,59119,59552,62161,62550,62118,62690,62118,62145,59780,59310,59780,59194,59830,59390,59150,59148,62123,62550,62000,62960,59670,62127,59670,62112,62120,59670,62118,62123,62123,62223,62000,62127,59450,59173,62550,62130,62120,62123,62118,62127,59830,59310,62134,59169,59830,59310,62123,59670,62490,62690,62118,59115,62130,62130,62120,62127,62120,62127,59187,59167,62550,62112,62217,62217,62217,62217,62145,62960,62810,59470,62127,62127,62129,59310,62118,62123,59670,62810,62145,59670,62123,62129,62134,62130,59287,62490,62810,62490,62130,59870,59310,62156,62123,62217,62130,59169,62127,62134,62810,59151,59182,59670,62128,59182,59287,62575,62960,62134,59470,62128,62130,62810,62490,59870,59146,62127,59285,62156,59169,62129,62960,59310,59310,62217,62156,62130,62810,62156,59470,62129,62134,62134,62130,59470,62127,62960,62156,62217,62810,62510,62173,62128,62960,59122,62156,59176,62128,62575,62128,59169,62127,59259,59151,62173,62123,62500,62570,62130,62130,59285,62134,62130,62130,62123,62128,62123,62810,62810,59470,62134,59176,59169,62810,59151,59870,62123,59310,59690,62134,62130,62810,62156,62129,62175,59870,59151,62270,62128,62810,62130,59490,62134,62130,62173,62860,62130,62134,59870,59285,62129,62173,59470,62570,62570,62810,59226,62860,59230,59143,62860,62158,62128,62130,62130,62500,62270,62134,59380,62123,62860,62860,62219,59165,59178,62270,59234,62810,62560,62560,62123,62182,62570,62175,62175,62130,62128,62175,62380,59122,62310,62134,62810,59230,62310,62175,59490,59870,62130,62380,62500,62810,62310,59470,59151,59870,62130,59580,62128,62182,59178,62134,62182,62310,62310,59380,62219,59143,59179,62130,62500,62810,62134,62310,59470,62123,59470,62860,59234,62158,62130,62130,62182,62380,62310,59580,59265,62380,62121,62121,62270,59234,59143,59470,62128,62560,59171,59380,62116,62810,62860,62158,62860,62158,62130,62560,62310,62500,62270,59380,62111,62810,59122,62128,62128,59226,62860,62560,62270,62270,59171,62130,62130,62130,62500,59215,62270,59265,62860,62310,62310,62310,62810,62860,59178,62121,62111,62380,62121,62116,62310,62500,62116,59470,62310,59122,62158,62860,59380,59178,62270,59247,59143,62130,62130,59158,62130,59252,62380,62770,62158,62860,62380,62380,62560,59470,62128,59247,62770,62270,62810,62111,62860,62910,62158,62380,62310,62270,62910,59171,59252,62111,59143,62760,59158,62270,62310,59380,62310,59630,80600,62560,59172,62116,62500,62310,62159,62770,62310,59143,59380,62270,62500,59124,62760,62860,59158,59247,59230,62770,62270,62770,59265,59158,59252,59380,62560,59380,62310,59230,59265,62159,80600,62910,59380,59135,59156,59230,80600,62270,59111,62770) AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='978' AND wish_id<>'312440' AND wish_url='' ORDER BY rand() LIMIT 0,10

  63. 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='978' LIMIT 0,1

  64. 0.0001

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

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

  66. 0.0001

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

  67. 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='978' LIMIT 0,1

  68. 0.0001

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

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

  70. 0.0001

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

  71. 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='978' LIMIT 0,1

  72. 0.0001

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

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

  74. 0.0001

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

  75. 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='978' LIMIT 0,1

  76. 0.0001

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

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

  78. 0.0001

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

  79. 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='978' LIMIT 0,1

  80. 0.0001

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

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

  82. 0.0001

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

  83. 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='978' LIMIT 0,1

  84. 0.0001

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

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

  86. 0.0001

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

  87. 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='978' LIMIT 0,1

  88. 0.0001

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

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

  90. 0.0001

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

  91. 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='978' LIMIT 0,1

  92. 0.0001

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

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

  94. 0.0001

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

  95. 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='978' LIMIT 0,1

  96. 0.0001

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

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

  98. 0.0001

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

  99. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 978

  100. 0.0008

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

  101. 0

    SELECT count(*) as nbwish FROM wish

  102. 0.0501

    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

102 requetes sql en 0.0706

Taille variable Globale : 78.93 KB