Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

20m3 camionnette (4 jours)

Annonces similaires

Tout voir
Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMION POUR DéMéNAGEMENT (UR
Profil du voisin
Voisin #8817

Vandoeuvre-lès-Nancy 54500

-- €

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMIONNETTE à  LOUER
Profil du voisin
Jennifer C

Vaxoncourt 88330

50€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CAMION 20M3
Profil du voisin
Bélinda B

Nancy 54000

100€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CAMIONNETTE à  LOUER (DEMENAGE
Profil du voisin
Voisin #47560

Essey-lès-Nancy 54270

30€

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

POUR UN DéMéNAGEMENT
Profil du voisin
Myriam D

Vandoeuvre-les-Nancy 54500

100€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

DEMENAGEMENT (2 JOURS)
Profil du voisin
Marine C

Dieulouard 54380

150€

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

3 CAMIONS 20M3 AVEC CHAUFFEUR (2 JOURS)
Profil du voisin
Stéphanie B

Nancy 54000

1000€

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

LOCATION CAMIONNETTE
Profil du voisin
Stéphanie B

Saint-Nicolas-de-Port 54210

40€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UTILITAIRE
Profil du voisin
Carine K

Chatel-sur-Moselle 88330

100€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

LOUER UN CAMION (3 JOURS)
Profil du voisin
Voisin #72738

Baccarat 54120

200€

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

  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

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

  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='403799' AND wish_id<>'548207' 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='54360'

  40. 0.0037

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.5333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.083639197041 AND ville_latitude_deg<48.982960802959 AND ville_longitude_deg>5.7042665078761 AND ville_longitude_deg<7.0623934921239 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0075

    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 (54360,54360,54360,54360,54360,54360,54290,54290,54360,54300,54360,54210,54360,54360,54290,54290,54300,54830,54210,54300,54290,54290,54290,54290,54830,54290,54110,54290,54290,54110,54300,54290,54290,54210,54290,54110,54830,54300,54290,54110,54830,54290,54210,54290,54370,54830,54740,54830,54110,54290,54110,54210,54300,54210,54300,54740,54110,54300,54290,54290,54290,54830,54110,54300,54830,54210,54740,54210,54830,54290,54740,54300,54290,54370,54210,54740,54830,54740,54300,54830,54210,54740,54118,54300,54740,54110,54370,88130,54370,54630,54300,54740,54510,54370,88330,54300,54300,54134,54950,54110,54134,54950,54290,54129,54740,88330,54710,54110,54110,54110,54300,54740,54410,88700,54160,54740,54630,54122,54740,54370,88130,88700,54300,54710,54500,88700,54370,54122,54110,54160,54850,54180,54370,54160,54330,88130,54370,54420,88130,54140,54740,54420,54740,54850,88330,88700,54180,54160,54116,88130,54122,54330,54370,54300,54425,88330,54740,54510,88330,54740,88130,88700,54280,54990,54450,54330,54100,54000,88700,88130,54230,88700,54370,54270,88700,88130,54370,88130,54330,54280,54370,54550,54330,54130,88130,54280,88130,88130,88700,54930,88450,88130,88700,54600,54550,54330,54230,54330,54122,54370,88450,54280,88700,88700,54330,54122,54450,54330,88700,54330,88700,54930,54116,54370,88700,54130,88130,88130,54520,54450,54550,54330,54122,54280,54280,54280,54370,54220,54450,54330,54930,54230,54330,54450,54370,54770,54370,88130,88330,54370,88500,54770,54330,54770,88450,54370,88500,88700,54450,88700,54370,54450,54370,54120,54330,54320,88500,88440,88330,54370,88130,54330,88500,54280,88330,54550,54330,54123,54120,88330,54450,54690,54930,88450,88500,88700,54230,54770,54120,88500,54120,54450,54330,54120,54770,88450,54250,54450,54120,54115,57810,54450,88700,88440,54690,57630,54370,54930,54370,54930,88330,54330,57170,88150,57170,54280,57170,88330,54930,54450,54115,57630,54115,88500,88500,88270,54170,54120,57170,88450,88330,54120,88700,88450,88500,54136,57170,54450,88700,54540,54370,88500,57810,88700,54930,57170,57810,54115,88150,54760,54760,57630,88500,54450,54170,54120,57810,88270,88700,88500,88700,57630,54115,57630,88500,88700,88500,88150,54170,54540,88270,54760,54450,54170,54115,54115,54170,88500,88700,88500,54930,88500,88150,88500,88700,54450,88150,88150,57590,54760,88270,88150,88700,54390,88500,57810,88500,54115,54540,54450,88500,54760,54120,88270,54450,54170,54540,54340,57630,54760,57170,54120,57810,88000,54840,88500,54115,54115,54540,54115,54840,54760,54760,54450,88500,57770,57810,54120,88500,57590,57590,88600,88270,57590,54450,57170,88390,88150,54450,54670,57630,57630,88270,54840,57170,54610,88500,54760,88700,88700,54115,54670,88500,88600,88600,54460,54450,54170,88500,88700,54540,57170,54450,57810,54450,88270,57260,88500,88600,54115,88500,54540,88390,54115,88500,88600,88390,57590,54200,88000,88000,54170,54450,57260,57590,88270,54840,54840,88600,54460,88270,88600,88270,54610,88270,54610,54540,54200,57260,57260,88270,88270,88500,88500,54113,54115,54115,88500,54610,57170,54670,57260,88000,57170,57170,54450,54450,54450,54170,54200,54540,57170,54114,54820,88500,54450,88600,88390,57590,54380,88390,88170,57590,54113,88190,54540,57830,57590,57170,88270,57810,57590,88110,88170,54450,88270,88600,54940,88000,88270,54200,88500,54113,88500,88170,88600,57170,88600,54540,88170,88000,88500,54380,88300,88500,54200,88500,88170,57260,88270,88480,57810,88390,57590,88390,57590,54200,88500,54115,57590,57170,57170,88600,57590,88500,88000,54200,54170,54480,54170,54540,54610,57590,54385,54113,88300,54380,57260,54200,57260,88270,88270,88470,88170,88600,57260,57810,88500,88600,57830,54380,57170,54113,88270,57590,57830,57590,57340,57340,88270,88300,57590,57590,57590,88270,54380,88390,88000,88470,88170,88470,88390,54113,54480,54540,57590,54610,88480,57170,57260,88270,57590,88170,57260,88800,88170,88390,54112,54480,54540,54480,54700,57340,54610,54113,88170,88170,54385,57260,88630,88170,54380,88600,54610,88800,88170,88110,54700,57340,57340,88270,88270,57810,54200,88420,57420,57590,54380,54380,57810,54610,54200,54170,88460,88600,57810,88170,57420,57590,57830,54380,54480,88600,88600,54385,57930,54610,88390,57340,54610,54200,88270,57590,88600,88270,54380,88800,54119,57142,88270,54610,54700,88460,88600,54200,57260,88300,57340,57340,88170,88170,88470,54200,54480,54112,57340,88460,57790,54170,54385,88600,88600,88600,57590,57590,57420,88800,88170,57340,57340,88260,54480,88600,57790,57830,88800,57810,54200,88300,54610,57340,88000,88470,57260,54700,88600,88170,57340,54200,88600,57340,57830,88210,88600,57420,57790,57830,88300,88630,57260,88260,57260,54700,54700,88460,88260,54200,88170,57830,88630,88600,88260,54610,57420,54200,57830,88600,54700,54700,57340,57580,57340,57590,88170,54385,88800,88210,57830,88600,57590,54112,88430,54570,88260,57420,54700,57260,54540,88110,88260,54200,54570,57790,57560,57340,88630,88460,88300,88300,88170,88170,88170,88600,88800,57340,54380,54385,88800,88800,88210,88380,88380,57790,54385,88210,88300,88210,57560,54200,88260,57260,57930,57420,54112,88170,88600,54700,88220,57580,57580,88550,88600,88800,57260,57830,54570,88220,88210,57580,57580,88210,57420,57340,57260,88260,88260,88460,54470,54700,88600,88270,57580,88640,57830,57830,88800,55140,54700,57560,57670,88460,57380,57580,57420,88170,55140,88110,57670,88800,88170,57380,88630,57790,88100,54385,57340,88210,55140,54570,88260,57420,57340,55140,57670) 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<>'548207' 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=8817 AND note_visu IN (1,3,4)

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

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

  49. 0.0001

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

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

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

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

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 862

  83. 0.0009

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

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

Taille variable Globale : 78.85 KB