You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY car_id' at line 46 -
SELECT
V.car_id, V.car_dep, V.car_tx, V.car_typ, V.car_cat,V.car_ma,V.car_se,
SUBSTRING_INDEX(V.car_pics, '#', 1) AS car_pic_principale, 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_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_en, C.CAT_LK_en, C.CAT_ID,
D.DEP_en, D.DEP_LK_en, D.DEP_ID,
TX.txt_id,
TS.txt_en,
TSER.TX_TIT_en AS txt_titre,
TSER.TX_TXT_en AS txt_contenu,
COL.COL_RGB, COL.COL_REF, COL.COL_RGB2, COL.COL_PICS, COL.COL_TYP,
COL_MA.COM_RGB AS COM_RGB1, COL_MA.COM_RGB2 AS COM_RGB2, COL_MA.COM_REF,
GROUP_CONCAT(COL.COL_REF ORDER BY COL.COL_REF SEPARATOR ',') AS COL_REF,
GROUP_CONCAT(DISTINCT COL_MA.COM_RGB ORDER BY COL.COL_REF SEPARATOR ',') AS COL_RGB,
GROUP_CONCAT(DISTINCT COL_MA.COM_RGB2 ORDER BY COL.COL_REF SEPARATOR ',') AS COL_RGB2,
GROUP_CONCAT(COL.COL_TYP ORDER BY COL.COL_REF SEPARATOR ',') AS COL_TYP,
GROUP_CONCAT(COL.COL_PICS ORDER BY COL.COL_REF SEPARATOR ',') AS COL_PICS,
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
LEFT JOIN txt_serie TSER ON (
TSER.TX_DEP = V.car_dep
AND TSER.TX_MA = V.car_ma
AND TSER.TX_CAT = V.car_cat
AND TSER.TX_SE = V.car_se
)
LEFT JOIN veh_car_color COL ON V.car_id = COL.COL_CAR
LEFT JOIN veh_car_color_ma COL_MA ON COL.COL_REF = COL_MA.COM_REF AND COL_MA.COM_MA = V.car_ma
WHERE car_sta = '1' AND car_cat != '0'
AND car_spec = '3901' AND DEP_LK_en IN () GROUP BY car_id You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC , car_tpx = 0, car_tpx ASC' at line 46 -
SELECT
V.car_id, V.car_dep, V.car_tx, V.car_typ, V.car_cat,V.car_ma,V.car_se,
SUBSTRING_INDEX(V.car_pics, '#', 1) AS car_pic_principale, 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_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_en, C.CAT_LK_en, C.CAT_ID,
D.DEP_en, D.DEP_LK_en, D.DEP_ID,
TX.txt_id,
TS.txt_en,
TSER.TX_TIT_en AS txt_titre,
TSER.TX_TXT_en AS txt_contenu,
COL.COL_RGB, COL.COL_REF, COL.COL_RGB2, COL.COL_PICS, COL.COL_TYP,
COL_MA.COM_RGB AS COM_RGB1, COL_MA.COM_RGB2 AS COM_RGB2, COL_MA.COM_REF,
GROUP_CONCAT(COL.COL_REF ORDER BY COL.COL_REF SEPARATOR ',') AS COL_REF,
GROUP_CONCAT(DISTINCT COL_MA.COM_RGB ORDER BY COL.COL_REF SEPARATOR ',') AS COL_RGB,
GROUP_CONCAT(DISTINCT COL_MA.COM_RGB2 ORDER BY COL.COL_REF SEPARATOR ',') AS COL_RGB2,
GROUP_CONCAT(COL.COL_TYP ORDER BY COL.COL_REF SEPARATOR ',') AS COL_TYP,
GROUP_CONCAT(COL.COL_PICS ORDER BY COL.COL_REF SEPARATOR ',') AS COL_PICS,
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
LEFT JOIN txt_serie TSER ON (
TSER.TX_DEP = V.car_dep
AND TSER.TX_MA = V.car_ma
AND TSER.TX_CAT = V.car_cat
AND TSER.TX_SE = V.car_se
)
LEFT JOIN veh_car_color COL ON V.car_id = COL.COL_CAR
LEFT JOIN veh_car_color_ma COL_MA ON COL.COL_REF = COL_MA.COM_REF AND COL_MA.COM_MA = V.car_ma
WHERE car_sta = '1' AND car_cat != '0'
AND car_spec = '3901' AND DEP_LK_en IN () GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC , car_tpx = 0, car_tpx ASC LIMIT 0,30
Transformations Export Africa Low price!
Join our team!
We are expanding and looking for passionate talents for various key positions within our family business. If you are motivated, dynamic, and ready to make a difference in the automotive industry, check out our job openings and apply now! Apply
Transautomobile
1589 D, Chaussée de Waterloo - 1180 Brussels - Belgium
