Table 'gemsportalk.veh_car' doesn't exist - SELECT V.car_id,V.car_dep,V.car_typ, V.car_cat, V.car_pics,V.car_nom, V.car_vittp, V.car_propx,V.car_protxt,V.car_vol,V.car_gar,V.car_ess,V.car_tra, V.car_neuf,V.car_lib, V.car_lit, V.car_tpx, V.car_etat,V.car_tpx_tot,V.car_mont,V.car_marq,V.car_nom,V.car_ma,V.car_spec,V.car_vid,V.car_360, M.ma_ma, M.ma_lk,M.ma_ctc, S.se_se, S.se_lk, O.mo_mo, F.fi_fi, C.CAT_fr, C.CAT_LK_fr, C.CAT_ID, D.DEP_fr, D.DEP_LK_fr, D.DEP_ID, TX.txt_id, TS.txt_fr, 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 AND TX.txt_dest = 'ess') LEFT JOIN veh_txt TS ON (V.car_spec = TS.txt_id AND TS.txt_dest = 'spec') 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 DEP_LK_fr = 'groupe-electrogene' AND car_kva IN ('4140','4131','4714','4138','4134','4713','4711') AND car_etat IN ('11') GROUP BY car_id Table 'gemsportalk.veh_car' doesn't exist - SELECT V.car_id,V.car_dep,V.car_typ, V.car_cat, V.car_pics,V.car_nom, V.car_vittp, V.car_propx,V.car_protxt,V.car_vol,V.car_gar,V.car_ess,V.car_tra, V.car_neuf,V.car_lib, V.car_lit, V.car_tpx, V.car_etat,V.car_tpx_tot,V.car_mont,V.car_marq,V.car_nom,V.car_ma,V.car_spec,V.car_vid,V.car_360, M.ma_ma, M.ma_lk,M.ma_ctc, S.se_se, S.se_lk, O.mo_mo, F.fi_fi, C.CAT_fr, C.CAT_LK_fr, C.CAT_ID, D.DEP_fr, D.DEP_LK_fr, D.DEP_ID, TX.txt_id, TS.txt_fr, 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 AND TX.txt_dest = 'ess') LEFT JOIN veh_txt TS ON (V.car_spec = TS.txt_id AND TS.txt_dest = 'spec') 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 DEP_LK_fr = 'groupe-electrogene' AND car_kva IN ('4140','4131','4714','4138','4134','4713','4711') AND car_etat IN ('11') GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC , car_tpx = 0, car_tpx ASC LIMIT 0,30
les + recherchés :
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
© 2024 autolink-trucks-and-machinery.com - by tbconcept.be