Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche camion avec chauffeur

Annonces similaires

Tout voir
Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

URGENT ! CAMION POUR DéMéNAGEMENT
Profil du voisin
Voisin #53470

Moissy-Cramayel 77550

30€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LIVREUR
Profil du voisin
Valérie W

Cesson 77240

40€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

20 M3 POUR 1 JOUR
Profil du voisin
Madi R

Lizy-sur-Ourcq 77440

100€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMION 20 M2
Profil du voisin
Lucile B

Nogent-sur-Marne 94130

150€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

UTILITAIRE URGENT
Profil du voisin
Martial P

Maison-Rouge 77370

50€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

LOCATION UTILITAIRE (QUELQUES HEURES)
Profil du voisin
Djamila S

Neuilly-sur-Marne 93330

-- €

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

UTILITARE DIMANCHE 29 AM
Profil du voisin
Alex P

Pontault-Combault 77340

80€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CAMION AVEC CHAUFFEUR
Profil du voisin
Aline B

Créteil 94000

50€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

LOUER UN CAMION DE DéMéNAGEMENT
Profil du voisin
Voisin #73642

Saint-Germain-sur-Morin 77860

180€/j

Location camion camionnette
Location camion camionnette

Demande il y a + de 30j

Il y a + de 30j

CHERCHE à  LOUER : CAMION 20M3 (2 JOUR
Profil du voisin
Voisin #57943

Le Pin 77181

204€

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

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

  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='454238' AND wish_id<>'589219' 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='77120'

  40. 0.005

    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(((3.11667- 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>2.434230395336 AND ville_longitude_deg<3.799109604664 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 (77120,77120,77169,77120,77120,77120,77515,77120,77169,77120,77169,77120,77120,77320,77169,77515,77320,77320,77320,77515,77510,77131,77510,77120,77540,77320,77320,77515,77131,77510,77510,77141,77580,77515,77320,77320,77580,77970,77970,77540,77970,77320,77320,77163,77580,77970,77540,77750,77580,77163,77510,77970,77510,77560,77750,77320,77750,77540,77163,77320,77580,77320,77610,77510,77640,77260,77750,77640,77580,77540,77470,77540,77580,77560,77370,77580,77580,77580,77470,77260,77610,77580,77320,77610,77260,77260,77750,77540,77510,77160,77510,77560,77660,77470,77320,77560,77320,77370,77510,77260,77610,77470,77750,77560,77610,77470,77370,77138,77174,77660,77730,77860,77860,77610,77160,77580,77320,77730,77390,77320,77470,02310,77370,77370,77260,77860,77370,77730,77160,77700,77320,77160,77100,77560,77720,77440,77730,77390,77174,77450,77390,02310,77260,77700,77320,77720,77610,77320,77470,77560,02540,77450,51310,77220,77440,77440,51310,77100,77390,77720,77160,02310,02310,77370,77440,77450,77450,77700,51210,77151,02310,02310,77370,77440,77124,77100,02540,77370,77220,77160,77560,77700,77720,77390,77440,77440,02310,02540,02570,77440,77160,77910,02540,77220,02310,77370,02310,77600,77450,77910,77450,77320,77220,77700,77144,77124,77440,77440,51210,77560,77160,77650,77144,51310,77650,77390,02540,77220,02310,77370,51310,77600,02570,77124,77910,51210,02540,77370,77390,77160,51310,77650,77124,02400,77410,51210,51310,77450,77171,77390,77520,77450,77440,77720,77520,02310,02570,77390,77400,77720,02400,77600,77650,77160,77720,77164,51210,77135,77390,02540,77410,02540,77400,51310,77139,77720,77910,77650,77400,77600,77600,77160,77520,77440,77370,77840,51310,29830,02540,77560,51210,77400,77840,77400,02400,77145,77720,02810,51310,77650,77600,77139,77410,77440,77720,77650,77171,77410,77410,77111,77410,77330,77400,77390,77122,77170,02400,02400,77090,77183,77520,51310,77840,77400,77390,29830,77154,77520,77390,77173,77520,77520,02400,02810,77680,02400,77165,77165,51310,77115,60620,77139,02810,77650,77166,51210,77200,77111,02810,77139,77165,77520,02810,77360,02400,51210,51310,77165,77165,77114,77520,77520,60890,02810,77410,02330,77139,77150,51120,77186,02400,02400,77165,77134,77154,77820,77165,51310,77157,02330,77410,02330,77550,77184,60620,02810,02400,02400,02330,77114,77185,77171,60620,77150,77177,02810,77820,77410,60890,60620,77830,51120,77520,77340,02400,02400,02400,77410,02810,77950,77550,10400,10400,60440,02810,77166,77230,77230,51210,77950,77170,60620,51210,02400,77178,77171,77420,02810,77115,77410,10370,77230,77126,94510,77520,77230,60890,77178,02400,77230,77820,02400,02810,51120,77480,60620,77500,77181,10400,60620,02330,51210,77170,02330,77950,02400,77950,10400,02650,02330,77950,51120,77270,02470,51120,94420,77126,77290,02650,77114,02400,77950,51260,02330,93160,94440,51210,51260,51210,02470,60440,02470,77230,02330,93460,02400,77114,77830,77148,02470,94880,94490,94880,10400,77480,60890,51120,77480,77480,77480,77181,93470,77126,94350,60440,10400,77230,02330,94440,77148,60620,51210,77550,77590,60330,51210,02650,77550,10400,77480,93370,77380,51120,91480,77133,77830,60620,77130,94520,94520,77118,02460,77118,60890,60330,94370,94380,60890,77290,02330,02400,77118,10400,77230,60890,02470,51210,77000,77000,60620,02210,93330,77230,94440,77130,02470,77000,10400,60330,02400,93410,10400,10400,77133,02330,77240,93290,94430,51120,02470,93390,93190,94500,93220,94470,51260,02210,91800,77480,77480,51210,77230,94360,10400,77130,51120,10400,02850,02850,77480,91480,51120,77127,93360,02470,77130,77240,77230,51120,51260,02470,77350,10400,77850,02850,60330,02210,94100,94210,94340,77480,60440,77590,51120,51120,51120,91860,77480,51260,60620,77480,02850,77000,02460,94170,93320,93340,51210,60620,91330,02330,93270,77920,77990,02210,10400,77176,77280,02850,51270,77176,02210,51700,77130,91800,51270,10400,77190,60440,77130,02460,51270,94380,93250,77130,60141,77870,77590,94130,51270,94450,60440,02210,60141,02600,94120,77230,51260,02210,77350,77130,93420,93110,02210,60950,60950,10400,51270,77130,10400,60620,89140,02210,94000,93600,51120,94340,94460,77990,02210,51260,51270,10100,89140,02600,91250,02210,77670,94410,02850,02210,77430,60800,77130,02600,02850,51270,02130,51120,93130,77210,91280,51120,51120,51120,51260,77240,77310,77350,51260,51700,77810,77230,94190,02600,60440,93140,02210,60950,77940,91560,10400,91250,77670,60117,91230,51120,95380,51270,51120) 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<>'589219' 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=53470 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 = 53470 AND W.type_id = 1) OR (W.util_id != 53470 AND W.type_id = 2)) AND (`post_util_id` = 53470 OR `dest_util_id` = 53470) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0001

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

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

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

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

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

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 862

  83. 0.0011

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

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

Taille variable Globale : 78.87 KB