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 CAT_LK_fr = 'groupe-electrogene' AND ma_lk = 'cummins' AND car_kva IN ('4142') 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 CAT_LK_fr = 'groupe-electrogene' AND ma_lk = 'cummins' AND car_kva IN ('4142') GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC , car_tpx = 0, car_tpx ASC LIMIT 0,30
330 Kva, Export Afrique Prix Bas !
