Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Loue camion 18m3 IVECO, option chauffeur

Autres annonces du voisin

Tout voir
Location remorque
Location remorque
REMORQUE 2 ESSIEUX AVEC BACHE ET PORTE E
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

20€/j

75%
Service electricien
Service electricien
éLECTRICIEN CONFIRMé
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

15€/h

75%
Location avec chauffeur
Location avec chauffeur
CAMION PLACES PMR OU CABRIOLET AUDI
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

150€/j

75%
Location betonniere
Location betonniere
LOCATION BéTONNIèRE 125L
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

15€/j

75%
Location minibus
Location minibus
CAMION 9 PLACES + PMR
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

80€/j

75%
Location cabriolet
Location cabriolet
AUDI A4 CABRIOLET
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

80€/j

75%
Location campingcar
Location campingcar
CAMPING CAR MC LOUIS 2015
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

80€/j

75%
Déménageur avec camion
Déménageur avec camion
CAMION 9 PLACES + ASCENSEUR
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

10€/h

75%
Service transport personne
Service transport personne
PROPOSE TRANSPORT PERSONNES POUR COURSES
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

20€/h

75%
Service service a personne
Service service a personne
MENAGE COURSES REPAS
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

12€/h

75%
Service couture
Service couture
TRAVAUX DE COUTURE
Profil du voisin
Olivier F Voisin vérifié

Bruay-sur-l'Escaut 59860

-- €

75%

Annonces similaires

Tout voir
Location camion camionnette
Location camion camionnette
LOUE CAMIONNETTE
Profil du voisin
Arnaud F

Faches-Thumesnil 59155

100€/j

Location camion camionnette
Location camion camionnette
LOCATION CAMION
Profil du voisin
Voisin #440032

Wattignies 59139

-- €

Location camion camionnette
Location camion camionnette
LOCATION CAMIONNETTE 12M3 & 20M3
Profil du voisin
Mustapha O

Vendin-le-Vieil 62880

70€/j

100%
Location camion camionnette
Location camion camionnette
LOCATION CAMIONNETTE CITROEN 13M3
Profil du voisin
Sabrina T

Oignies 62590

105€/j

Location camion camionnette
Location camion camionnette
LOCATION VéHICULES UTILITAIRES
Profil du voisin
Nadir E

Harnes 62440

137€/j

Location camion camionnette
Location camion camionnette
LOCATION CAMIONNETTE
Profil du voisin
Sofian G

Feignies 59750

30€/j

Location camion camionnette
Location camion camionnette
OPEL MOVANO
Profil du voisin
Florent M

Hallennes-lez-Haubourdin 59320

100€/j

Location camion camionnette
Location camion camionnette
BERLINGO UTILITAIRE 3 PLACE
Profil du voisin
Quentin P

Roubaix 59100

40€/j

Location camion camionnette
Location camion camionnette
LOCATION CAMION
Profil du voisin
Ben B

Lens 62300

70€/j

Location camion camionnette
Location camion camionnette
LOCATION CAMION à LA JOURNéE
Profil du voisin
Karom A

Marcq-en-Baroeul 59700

100€/j

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

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

  7. 0.0001

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

  9. 0

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

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

  32. 0.0001

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

  34. 0

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

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

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

  39. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1

  40. 0.0001

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

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

  42. 0.0002

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

  43. 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='583' LIMIT 0,1

  44. 0.0002

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

  45. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='868' LIMIT 0,1

  46. 0.0001

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

  47. 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='73' LIMIT 0,1

  48. 0.0001

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

  49. 0

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

  50. 0.0001

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

  51. 0

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

  52. 0.0001

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

  53. 0

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

  54. 0.0001

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

  55. 0

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

  56. 0.0001

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

  57. 0

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

  58. 0.0001

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

  59. 0

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

  60. 0.0001

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

  61. 0

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

  62. 0.0001

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

  63. 0.0001

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

  64. 0.0038

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.53333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.933639197041 AND ville_latitude_deg<50.832960802959 AND ville_longitude_deg>2.8281367973589 AND ville_longitude_deg<4.2385232026411 HAVING distance <= 50 ORDER BY distance ASC

  65. 0.0069

    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 (59860,59880,59192,59410,59590,59300,59770,59494,59278,59264,59174,59494,59300,59243,59990,59970,59990,59970,59195,59990,59135,59300,59970,59990,59195,59125,59163,59990,59220,59230,59154,59990,59269,59199,59920,59144,59121,59199,59135,59163,59233,59990,59220,59255,59121,59178,59230,59158,59224,59144,59163,59269,59178,59269,59171,59144,59220,59224,59230,59530,59144,59213,59213,59226,59144,59530,59227,59282,59178,59124,59158,59171,59158,59870,59530,59158,59213,59213,59230,59570,59156,59178,59282,59144,59171,59870,59293,59230,59870,59570,59530,59179,59213,59213,59530,59172,59198,59530,59570,59226,59570,59215,59570,59530,59530,59227,59227,59490,59690,59310,59870,59144,59530,59296,59144,59111,59730,59294,59870,59172,59530,59111,59570,59310,59530,59310,59570,59570,59111,59490,59530,59188,59730,59218,59218,59188,59870,59580,59310,59218,59870,59580,59570,59252,59570,59111,59570,59165,59730,59146,59730,59218,59188,59141,59176,59252,59570,59252,59129,59310,59295,59295,59310,59530,59570,59530,59292,59310,59176,59730,59277,59530,59234,59730,59141,59182,59310,59141,59148,59288,59214,59247,59247,59167,59310,59234,59570,59222,59182,59161,59287,59271,59830,59400,59234,59222,59550,59138,59169,59554,59222,59550,59194,59217,59287,59161,59169,59830,59360,59161,59247,59138,59242,59265,59217,59830,59554,59138,59217,59194,59830,59145,59161,59540,59750,59151,59540,59265,59330,59268,59145,59400,59235,59620,59119,59450,59360,59157,59187,59310,59242,59330,59780,59265,59830,59540,59138,59265,59600,59550,59157,59540,59830,59554,59620,59554,59242,59360,59169,59151,59217,59400,59600,59780,62860,59400,59169,59360,59550,59980,59360,59330,59265,59330,59286,59550,59400,59710,59360,59246,59400,59283,59225,59151,59600,59283,59600,59550,59400,59710,59152,59620,59273,59710,59554,62860,59500,59552,59830,59191,59720,62860,62790,59980,59554,59169,59152,59152,59620,59267,59151,59273,59980,59600,62860,59400,59620,59191,59262,59553,59553,59152,59128,59151,59551,59950,59552,59550,59225,62112,59600,59330,59780,59330,62860,59360,59127,62112,59360,59191,59400,62490,59600,59131,59980,59980,59440,59281,59440,62141,59360,59330,59710,59239,59600,59440,59162,62490,59680,62860,62860,59239,59390,59553,59267,59258,62970,59810,62860,59159,02110,59360,59600,62117,59261,62490,59241,59510,02110,59550,59440,59551,59360,62860,59244,59258,59127,59259,59680,59510,59440,59238,59390,59244,59440,59680,62820,59245,59168,62860,59390,59159,59244,59175,59115,62860,59127,59790,59680,62860,62490,62860,59440,62950,59390,59137,59260,02450,59400,59360,62119,62490,62490,59133,62156,59258,59155,59175,59680,59113,62156,59680,62590,59164,59127,62147,59127,59440,02110,02110,59139,02110,59216,62860,59740,02110,02630,02450,59440,59740,62156,59460,62118,62182,59440,62490,59170,59290,59370,59550,62220,59133,59150,59680,02450,02170,59267,59440,59216,62860,59216,62147,59440,62182,59142,59440,59147,62118,59266,02110,02450,59680,62110,59112,59139,62156,62640,59263,59740,62490,59147,59000,62710,59160,59777,59800,59350,59159,02420,59650,59493,59491,59655,62156,59149,62147,62320,62320,59100,59231,62580,02110,59740,62156,59266,59740,62740,59147,59740,59110,02170,59440,02630,59251,62880,62118,59320,59700,59120,02110,62860,62320,62860,62420,62156,59740,59420,62118,02510,62182,59266,62440,02170,59112,02110,59177,59320,59200,59740,59231,62147,62320,59185,62580,59130,62182,62118,59149,62147,62580,62147,59177,59350,02630,59520,62580,02420,59910,02510,59219,59320,62118,02420,59219,62128,02510,62880,62880,59740,62118,02170,02420,59740,62680,62580,62430,59272,59231,59297,02450,02110,02450,62128,62218,62221,59118,02260,59211,62410,59149,59320,02110,62147,62880,59136,59219,02110,59221,62124,59177,02120,62128,59184,62580,59320,62580,02230,62159,59740,59960,62124,59740,02510,62128,62128,59840,02170,62138,62128,02420,62124,62410,62210,59320,59320,59320,02450,62223,62580,59134,59160,02420,62300,62124,62128) AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='862' AND wish_id<>'258350' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

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

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

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

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

  83. 0.0001

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

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

  85. 0.0002

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

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

  87. 0.0001

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

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

  89. 0.0002

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

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

  91. 0.0001

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

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

  93. 0.0002

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

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

  95. 0.0001

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

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

  97. 0.0002

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

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

  99. 0.0001

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

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

  101. 0.0002

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

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

  103. 0.0001

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

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

  105. 0.0002

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

  106. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 862

  107. 0.0009

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

  108. 0

    SELECT count(*) as nbwish FROM wish

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

109 requetes sql en 0.0737

Taille variable Globale : 79.42 KB