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_fr, C.CAT_LK_fr, C.CAT_ID,
D.DEP_fr, D.DEP_LK_fr, D.DEP_ID,
TX.txt_id,
TS.txt_fr,
TSER.TX_TIT_fr AS txt_titre,
TSER.TX_TXT_fr 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 = '4271' AND DEP_LK_fr 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 DESC' 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_fr, C.CAT_LK_fr, C.CAT_ID,
D.DEP_fr, D.DEP_LK_fr, D.DEP_ID,
TX.txt_id,
TS.txt_fr,
TSER.TX_TIT_fr AS txt_titre,
TSER.TX_TXT_fr 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 = '4271' AND DEP_LK_fr IN () GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC, car_tpx = 0, car_tpx DESC LIMIT 0,30
Transformations Export Afrique Prix Bas !
Rejoignez notre équipe !
Nous sommes en pleine expansion et recherchons des talents passionnés pour divers postes clés au sein de notre entreprise familiale. Si vous êtes motivé(e), dynamique, et prêt(e) à faire la différence dans le secteur automobile, consultez nos offres d'emploi et postulez dès maintenant ! Postuler
Transautomobile
1589 D, Chaussée de Waterloo - 1180 Bruxelles - Belgique
