Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche utilitaire type Renault Trafic

Retour Location Utilitaire Location utilitaire entre particuliers (92) Location utilitaire entre particuliers (92)

Discuter

Ce voisin demande à louer à Le Plessis-Robinson (92350)

50€/j

Prix

50€/j

-11800kgqu'à l'achat

5x moins cher qu'en magasin

Description de l'annonce

Je cherche un utilitaire à  louer, type Renault Trafic ou semblable (pour déménagement) pour la journée du 9 novembre 2019 à  partir de 8h30 jusqu'à  17h. Par avance merci. Cordialement. #utilitaire

Annonces similaires

Tout voir
Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

VEHICULE UTILITAIRE FRIGO IVECO AVEC HAY
Profil du voisin
Jean marie V

Saint-Germain-en-Laye 78100

300€

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOUER UN VéHICULE UTILITAIRE
Profil du voisin
Voisin #133868

Montigny-lès-Cormeilles 95370

75€/j

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOCATION UTILITAIRE MINIMUM 6M2 (3 JOURS
Profil du voisin
Valentin D

Ivry-sur-Seine 94205

150€

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOCATION : UTILITAIRE (DéMéNAGEMENT)
Profil du voisin
Mélany F

Villejuif 94800

50€/j

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOCATION FOURGON POUR TRANSPORTER TABLE
Profil du voisin
Voisin #538121

Champigny-sur-Marne 94500

50€/j

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

PRET D'UTILITAIRE (4H)
Profil du voisin
Voisin #274895

Bouray-sur-Juine 91850

160€

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOCATION D'UN UTILITAIRE DE 12 à  15M3
Profil du voisin
Voisin #63098

Noiseau 94880

192€

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UTILITAIRE à LOUER POUR 3H
Profil du voisin
Jessica P

Taverny 95150

50€

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMION BENNE
Profil du voisin
Eric S

Acheres 78260

75€/j

Location utilitaire
Location utilitaire

Demande il y a + de 30j

Il y a + de 30j

LOCATION : UTILITAIRE (11M3)
Profil du voisin
Laurence S

Tournan-en-Brie 77220

50€/j

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='utilitaire' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='730'

  4. 0.0001

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

  7. 0.0001

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

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=730 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

  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='56947' AND wish_id<>'272109' 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='92350'

  40. 0.0059

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.333639197041 AND ville_latitude_deg<49.232960802959 AND ville_longitude_deg>1.584230395336 AND ville_longitude_deg<2.949109604664 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.012

    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 (92350,92330,92260,92290,92140,92320,92220,92190,92360,91370,92130,92340,92160,92240,94237,94234,94235,94236,94233,94232,94240,94239,94230,94231,94238,91570,94260,92370,94110,92120,91300,92100,92170,92310,94250,78140,94550,91430,94150,92410,91320,91430,92210,91120,94800,78220,78350,94270,92430,92420,94320,92380,91400,91160,94205,94200,91140,91380,91160,92800,92150,94400,78530,78000,78350,75015,75014,75009,75002,75008,75001,75007,75006,75005,75004,75000,75011,75010,75016,75003,75013,75017,75018,75019,75020,75012,75116,91550,94310,94390,91420,91400,92200,91160,94140,94600,78170,78150,91140,94220,78117,91440,92500,91190,91200,94160,78150,94290,94700,92400,91160,92250,92300,92110,94480,91190,91940,78117,78380,78290,91360,92000,91360,93400,78400,91260,94300,92600,91390,91600,78430,93170,91270,94410,94190,94000,78210,78280,93310,91940,91190,91620,92270,92700,91940,91700,91620,94340,94460,93100,78870,91560,91170,78800,78560,91210,78114,94380,78420,93500,78330,78960,78160,91230,78470,78590,93260,93230,91310,91310,91310,78590,94130,94450,78470,91240,91460,92230,78110,91400,95870,93120,93300,78360,91350,91640,94100,94210,94340,78180,78620,91700,92390,93450,78750,94120,78230,93200,93210,91700,93110,93130,78112,78460,94430,78390,91130,91000,91310,95100,94170,91330,78100,93000,94500,94470,93800,91220,91220,78450,94360,78470,91470,91800,78500,78190,93140,91470,94380,94370,78860,78600,93350,91450,91470,93430,93250,91070,93240,78600,91640,91180,95110,95210,95218,93360,95880,94880,94880,94490,93330,94440,91080,91680,78340,95360,95530,93150,93700,91090,91000,78460,91860,78240,94350,94440,93440,91640,78720,93380,91470,78450,91680,91470,91450,91290,95120,91290,94420,95230,95130,78240,93340,93320,93220,91800,78720,91340,91520,78320,94520,94520,95240,95170,78300,95410,95370,95140,91090,91640,93160,94510,78990,94440,91480,78370,78320,78720,95500,78810,93460,91250,91630,91630,95600,91630,95580,95580,95130,91630,78320,77170,91250,91480,95160,95400,91530,91650,77340,78260,91650,95350,95220,91810,78955,78830,91280,78700,93190,78630,93390,93370,77420,77380,78720,95400,95200,93270,78310,91100,77184,78310,91630,95390,95500,95320,95680,91100,91540,93600,78810,91650,91790,77185,77150,95250,78570,91250,77127,91470,95350,78850,78121,77500,78760,78670,78670,78830,91710,95480,91540,91540,78640,95440,78640,77150,93470,77181,93410,91540,77186,78690,91730,77170,78570,95150,95550,77680,78780,95500,91530,91530,95330,93420,91770,78640,78690,91730,91910,78720,95720,95610,95460,95500,77200,77177,78540,91580,78490,77330,78640,78630,77360,91830,91410,91250,78510,77181,78580,78610,91510,91510,95560,95840,93290,91850,95570,95190,95000,77183,77090,91730,95720,95740,91610,91760,95570,78650,95700,77173,95570,91750,78480,78730,78730,77166,78490,78490,77270,77550,91530,78580,95280,95720,77176,78124,78125,77166,77600,95000,78920,95310,95840,95560,91580,95560,77410,78130,77135,77400,91580,95540,78610,78490,78490,78124,91830,95300,91590,78650,95430,91580,77164,78120,95000,77400,95190,91750,77600,77600,95380,95490,91410,77550,78490,78490,95720,77400,95180,77240,91410,95590,78770,91580,77176,95560,78580,78410,95630,95430,95300,95850,78580,77290,91590,95800,77111,78740,77600,95570,77400,78770,78490,95190,78610,77170,78730,77240,78490,95270,77310,77220,95380,77550,95520,78126,78770,77400,78740,95650,78770,78120,95270,91590,78130,77240,91580,91590,95380,91590,77400,78770,77310,95380,77600,95760,77990,78410,77410,91590,95270,77550,77600,95650,91750,78120,77400,95850,78250,77410,77990,95450,95380,77111,77220,78730,95650,78250,91410,95300,78770,77144,78490,78410,78940,78410,78410,77410,77950,77310,77220,91590,77390,95590,95290,78250,95620,95300,91890,78250,91150,91590,78730,78610,95670,91410,95450,95270,95270,77410,77350,91870,78680,77220,77290,77220,77950,77410,78890,95270,77700,77144,78770,91150,95270,78580,95470,78250,77700,95470,77230,95650,95650,91840,95270,77350,77410,77950,78820,95260,77950,77390,95660,95260,95590,91880,95270,77230,78940,77230,91410,95270,77350,77174,78490,95450,77930,78660,95270,95690,78910,91820,77450,78930,78125,77390,91820,95270,77930,78910,78970,77230,78125,77230,95450,95810,95690,91150,91490,95470,77450,77930,78930,77190,91410,77390,78125,91150,95450,95810,77000,77000,77700,95340,78440,95470,77390,77930,77950,77700,78790,78790,78250,95450,77410,78910,77700,95830,77190,77610,91490,95690,91720,95450,77610,91490,91780,91780,77230,95690,77174,78790,78910,78125,95830,77410,78440,77230,77610,95810,77410,60128,77230,77930,77450,77390,78930,78440,77230,77930,60260,95810,77000,91150,60230,95340,78440,78440,95450,95340,95820,77230,91410,77450,60560,95450,77950,78660,60820,77000,78910,77450,78125,95810,60580,78440,77450,91150,91720,60520,77450,91410,78910,77580,91410,78660,77165,77410,78440,77390,78550,78440,78950,77450,77860,78113,77610,78930,78113,95450,60128,95450,77630,60530,91150,77230,78790,91720,95640,78930,78930,77390,91410,77630,78660,77390,77165,77165,77165,78930,78520,77115,77610,78125,77720,95450,78125,78660,91490,77115,78711,78200,77280,78790,77390,91780,95640,95640,77860,78660,77230,78440,60520,95640,95450,95450,78790,60270,78113,77610,78200,60330,78550,95810,77590,28230,60530,91720,78200,91150,60530,77390,78660,78790,60540,60540,60950,95640,77610,78125,91150,77630,78125,28230,28700,95810,95640,60520,78440,60460,77860,77100,28320,77124,91490,77720,78440,77230,78125,77390,91690,95640,78910,77580,77580,78200,95510,95420,95640,77590,28700,60110,91690,77163,77100,78200,77124,78550,78550,77580,78520,77165,77163,91690,91720,77820,78200,91740,78790,28700,91150,60530,78113,91150,60540,91150,60530,60540,78910,78113,60240,77720,60330,28700,60500,91150,60110,78200,77390,78550,77580,77122,91720,91690,60119,60500,77163,95750,78550,77720,60340,95510,91690,78200,77124,77100,78111,60460,91740,95450,95420,77123,60340,95750,78200,28700,77590,77720,28130,78113,60119,95420,95420,78520,28210) 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='730' AND wish_id<>'272109' 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='730' 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=322460 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 = 322460 AND W.type_id = 1) OR (W.util_id != 322460 AND W.type_id = 2)) AND (`post_util_id` = 322460 OR `dest_util_id` = 322460) 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 = 322460

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

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

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

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

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

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

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

  72. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 223871 AND W.type_id = 1) OR (W.util_id != 223871 AND W.type_id = 2)) AND (`post_util_id` = 223871 OR `dest_util_id` = 223871) 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 = 223871

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

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

  82. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 730

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

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

Taille variable Globale : 78.9 KB