Table 'gemsportalk.veh_txt' 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 ('essential','sprinter','station','stralis','28kva') GROUP BY car_id ORDER BY car_typ ASC , IF((car_tpx + 0) = 0, 9999999, (car_tpx + 0))
Search Essential, Sprinter, Station, Stralis, 28kva | Price tax free for Export to Africa
