Discuter
Description de l'annonce
Cherchons à louer un camion 120m3 avec chauffeur pour environ 5 jours, voir 6 jours
Distance allée / retour 1100km.
Pour le mois d'août
Faire offre svp
Merci #avec chauffeur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Cherchons à louer un camion 120m3 avec chauffeur pour environ 5 jours, voir 6 jours
Distance allée / retour 1100km.
Pour le mois d'août
Faire offre svp
Merci #avec chauffeur
Annonces similaires
Tout voirLouer un vehicule (avec chauffeur) entre particuliers ou proposer un vehicule (avec chauffeur) en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
700€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='362275'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='avec-chauffeur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='868'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'avec-chauffeur' LIMIT 1
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'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='172109' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 172109
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 362275
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=868 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='362275'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='362275' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 172109 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=172109 LIMIT 1
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 172109 AND W.type_id = 1) OR (W.util_id <> 172109 AND W.type_id = 2)) AND (M.post_util_id = 172109 OR M.dest_util_id = 172109) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='172109' AND note_visu IN (1,3,4)
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 = '362275'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='172109' AND wish_id<>'362275' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59990'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>2.8624652035945 AND ville_longitude_deg<4.2708747964055 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('59990','59990','59269','59990','59990','59300','59300','59144','59269','59770','59990','59300','59530','59269','59530','59880','59144','59125','59233','59213','59174','59990','59144','59530','59213','59410','59144','59264','59860','59213','59213','59224','59227','59494','59990','59243','59144','59121','59224','59192','59530','59195','59144','07387','59530','59213','59213','59121','59590','59494','59220','07387','07387','59530','59530','59195','59920','59530','59530','07387','59570','59220','59135','59278','59730','59970','59530','07387','59144','07380','07387','07387','59255','59144','59227','59530','59227','59154','59294','59530','59570','59198','59570','59970','59218','59218','07380','59135','07387','59220','59570','59282','59218','59730','07382','59282','59570','59570','59163','59970','59163','59218','59296','59293','59171','07370','07350','59156','59570','59188','07387','59124','59570','59530','59730','07387','59163','59530','59730','59230','07370','59188','59111','59570','07387','59172','59730','07350','59530','59570','59199','59178','59188','59199','07370','59171','59178','07350','59730','59288','07370','59570','59111','59129','59292','07320','59222','59171','59111','59158','59230','59222','07350','59215','59570','59172','59550','07322','59550','59222','59179','59214','59230','59271','59870','59870','59141','59178','59570','59277','07321','07603','59226','07340','59360','07322','07300','59490','59111','59178','59230','07600','59295','59295','59138','07608','07321','59570','59252','59870','59138','59141','59158','59145','59252','59141','59230','59145','59360','59158','59158','59580','59550','59540','59870','07301','59580','59138','59870','59217','07340','07080','59217','07340','59252','07973','59161','59620','59540','07330','07334','59490','07340','59540','59217','07040','59360','07601','59165','59540','07973','07972','07971','07080','07604','07080','59138','59400','59226','59620','59161','07040','59360','59360','59550','59157','07333','59330','07622','59330','07620','07390','59360','07623','07334','59247','59310','59690','59157','59550','59750','59234','59161','07604','59980','59176','07602','07971','59400','07390','07080','59870','07971','59310','59554','59247','07604','59550','07971','07040','07624','59146','59870','59161','07621','59620','59554','07604','07332','07012','59400','59217','59176','59234','59225','07040','07640','07331','59310','59265','59330','59980','07040','07040','59550','07620','59620','59330','59247','07604','07080','07620','59268','59360','59980','59600','59234','07620','07012','59310','59400','59182','07040','59191','07040','07640','59400','59554','59360','07904','59554','59620','59360','07972','59265','59169','07538','07620','59600','59225','07033','07641','07332','07970','59191','59182','59287','59600','59440','07643','07950','59440','59310','59265','59720','59400','59980','59980','07024','59330','07640','59330','07904','59400','07620','59167','07040','59265','07011','59400','59600','59191','59550','59169','59151','07972','02110','59440','02110','59360','59360','59287','59148','59310','59244','59127','59310','07041','07534','07022','07611','62860','59310','07022','07642','59330','59265','59244','07618','07950','59600','07530','59267','59440','07500','59194','07022','07022','07050','59554','59440','59151','59131','07000','07903','59244','59238','59554','02450','59680','59360','59310','07521','07903','59600','59600','59169','07950','07906','59127','59440','07050','59187','59600','07032','59281','59258','07610','59137','07536','59450','07506','59194','07500','59119','07020','62860','07050','59127','59400','59440','59258','07951','59169','02450','62860','59680','07812','59151','02110','07534','59241','02630','07022','07504','07903','59830','07041','02110','02110','59680','07802','62860','07901','59159','59680','07950','59267','59550','02110','07050','59440','07548','07502','07030','07020','02450','02170','07531','07532','07904','59440','59440','59600','62860','59680','59168','59151','59245','59127','59242','59127','07950','07900','07900','07500','02450','07870','59235','07540','59310','59680','59830','59830','59440','59258','59440','59159','59216','07812','07501','07533','07911','59169','59151','59440','59740','07812','59552','07050','59830','07031','07034','59500','07812','59242','59286','07120','59216','59216','62860','59740','06560','07801','02110','62860','62860','07911','07120','07120','59283','07812','07522','62112','59830','62112','59164','62490','02170','59142','59552','59400','07522','07940','07811','02630','07503','62860','07050','59780','07540','59242','59830','07540','59283','07120','59553','59553','07810','62860','59680','07911','07034','02510','02110','59246','07941','62147','07942','62790','07540','07021','59128','07940','59740','59710','62860','07800','59680','62490','07911','59460','02110','59440','59740','62490','02420','02170','59266','07870','07120','07061','07870','59259','59950','62860','07543','07522','59740','07812','07760','07522','62860','07120','59780','07120','06560','59710','02630','59267','07870','59149','59710','02510','62117','59177','02510','07911','07911','07803','02170','07542','59553','07120','59219','07760','59740','07070','59219','59266','07120','07943','59273','07910','62156','02450','02450','59551','07110','59177','62141','02110','62860','59159','59740','59152','62147','59273','59830','07070','02260','59231','07130','62860','59740','62490','07910','62970','59162','07520','62156','07110','07061','07910','59266','59152','59152','02120','59219','62147','62182','07743','59262','07870','59239','02110','07800','07804','07070','02110','02510','02170','62490','07910','02420','07911','59177','59152','07910','07910','02420','07520','06560','07743','07063','62490','62182','06560','62156','59740','02420','59710','02110','07861','59239','07822','59231','07130','02450','07120','59261','59149','02230','07830','07830','07070','59740','07823','59780','07822','07804','06567','07830','02120','62118','02120','02110','02110','02120','07910','07131','59551','62950','07110','07730','59740','07760','62147','02260','62820','07063','62156','59297','02260','59740','02620','07912','06560','62119','02110','07134','59810','07100','07890','06567','06567','62860','59231','07130','07822','07134','62118','02420','62147','59740','59390','02110','62860','62490','62147','07740','62156','59149','07912','07730','07730','62156','59510','06560','07910','62590','07760','02420','07830','07100','07830','59133','07110','59610','02420','59175','07861','07742','06470','62490','62124','02260','62182','59510','59212','59390','62156','59790','06542','62182','07750','06470','59113','07740','59175','06567','07133','02110','62147','06500','07060','59260','59390','07062','07100','59155','62118','02420','07730','07866','06543','62110','62580','62118','59132','02120','02120','02120','07830','62220','07890','07134','59115','02120','06500','02420','59390','62320','02110','02110','02120','62320','62640','80740','02420','07060','07730','80740','59133','62124','06470','59132','02120','59139','62124','62128','08587','02420','02420','07890','07110','62710','02120','07750','07862','02260','02260','02420','62128','08587','62159','07760','62124','07750','62118','07830','62118','02260','07750','09600','07860','02110','02120','02120','59147','02120','02120','07100','62740','62320','07100','80122','08587','06540','59112','06500','07730','02420','07070','62124','07134','02120','07866','06530','07730','07880','62124','80360','02100','07750','62580','62128','62128','62118','62420','06500','59370','62580','59147','02260','62580','59263','59170','59290','02420','07141','07863','02110','59139','80240','62124','62124','62880','62124','62320','02260','02420','62128','02110','59132','62128','80240','06533','59132','02120','02100','02100','59610','80240','59150','08583','62440','02120','02260','07760','06500','59147','80112','06540','02420','59251','59000','59800','59160','59777','59350','06470','08510','08582','62580') 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='868' AND wish_id<>'362275' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=449268 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 449268 AND W.type_id = 1) OR (W.util_id <> 449268 AND W.type_id = 2)) AND (M.post_util_id = 449268 OR M.dest_util_id = 449268) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 449268
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271183 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 271183 AND W.type_id = 1) OR (W.util_id <> 271183 AND W.type_id = 2)) AND (M.post_util_id = 271183 OR M.dest_util_id = 271183) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 271183
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=70025 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 70025 AND W.type_id = 1) OR (W.util_id <> 70025 AND W.type_id = 2)) AND (M.post_util_id = 70025 OR M.dest_util_id = 70025) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 70025
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 868
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous