Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche utilitaire 20m3

Retour Location Camion camionnette Location camion camionnette entre particuliers (59) Location camion camionnette entre particuliers (59)

Discuter

Ce voisin demande à louer à Aubencheul-au-Bac (59265)

75€/j

Prix

75€/j

-6000kgqu'à l'achat

Description de l'annonce

Bonjour cherche utilitaire 20 m3 à louer pour le week-end du 17 avril 9h pour la journée sur aubigny au bac ou alentours .
Pas au prix du commerce qui propose 84e la journée.
Merci pour vos propositions
#camion camionnette

Annonces similaires

Tout voir
Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UTILITAIRE POUR WEEK END
Profil du voisin
Ludovic M

Baisieux 59780

180€/w-e

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CAMMIONETTE AVEC ATTELAGE (2 JOURS)
Profil du voisin
Frederic D

Marly 59770

220€/w-e

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

12 M3 OU PLUS AVEC ATTELAGE DEMENAGEMENT
Profil du voisin
Voisin #101939

Valenciennes 59300

300€

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UTILITAIRE (2H)
Profil du voisin
Stéphanie N

Coutiches 59310

50€

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CAMION POUR DéMéNAGEMENT
Profil du voisin
Voisin #67813

Lille 59000

-- €

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

MINI DéMENAGEMENT
Profil du voisin
émeline R

Saint-Quentin 02100

90€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CAMION AVEC CHAUFFEUR
Profil du voisin
Dominique D

Marquion 62860

30€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMIONNETTE 15 M3
Profil du voisin
Benoit

Brebieres 62117

110€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CAMION AVEC CHAUFFEUR (DéMéNAGEMENT)
Profil du voisin
Aurore S

Noyelles-sous-Lens 62221

500€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

TRANSPORT D UNE MOTO DE 110 KILOGRAMMES
Profil du voisin
Franck C

Villers-Outreaux 59142

45€/h

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='camion-camionnette' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='862'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'camion-camionnette' 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='5287' 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` = 5287

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=862 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

  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='5287' AND wish_id<>'345763' 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='59265'

  40. 0.0074

    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.16667- 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.4639423247262 AND ville_longitude_deg<3.8693976752738 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0104

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

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

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

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

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

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

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

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

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

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

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

  82. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 862

  83. 0.0012

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

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

Taille variable Globale : 78.87 KB