Table 'gemsportalk.veh_m_ma' doesn't exist - SELECT V.*, M.ma_id, S.se_id, O.mo_mo, F.fi_fi, C.CAT_ID, D.DEP_ID, TX.txt_id, DE.DEV_DEV FROM veh_car V LEFT JOIN veh_m_ma M ON (V.car_ma=M.ma_id) LEFT JOIN veh_m_se S ON (V.car_se=S.se_id) LEFT JOIN veh_m_mo O ON (V.car_mo=O.mo_id) LEFT JOIN veh_m_fi F ON (V.car_fi=F.fi_id) LEFT JOIN veh_car_cat C ON (V.car_cat = C.CAT_ID) LEFT JOIN veh_car_dep D ON (V.car_dep = D.DEP_ID) LEFT JOIN veh_txt TX ON (V.car_ess = TX.txt_id) LEFT JOIN veh_param_devise DE ON V.car_mont = DE.DEV_ID WHERE car_sta = '1' AND car_cat != '0' AND car_typ = '1' AND se_lk IN ('966h','966gc','automatique','28kva','mobile') GROUP BY car_id ORDER BY car_typ ASC , IF((car_tpx + 0) = 0, 9999999, (car_tpx + 0)) Recherche 966h, 966gc, Automatique, 28kva, Mobile | Prix hors taxes Export Afrique

Recherche 966h, 966gc, Automatique, 28kva, Mobile

Autolink Trucks & Machinery

Chaussée de Waterloo 1595 - 1180 Bruxelles - Belgique

Tel : + 32 2 352 01 50 - Fax : +32 2 352 01 51

TVA : BE.0456.984.717

Mentions légales

Vie privée

Conditions générales de vente

Gestion des cookies

© 2024 autolink-trucks-and-machinery.com - by tbconcept.be