Unknown column 'TX_txt_pt' in 'field list' -
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_px, V.car_ext,
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_pt, C.CAT_LK_pt, C.CAT_ID,
D.DEP_pt, D.DEP_LK_pt, D.DEP_ID,
TX.txt_id, TX_txt_pt as carburant,
TS.txt_pt,
TSER.TX_TIT_pt AS txt_titre,
TSER.TX_TXT_pt 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 DEP_LK_pt = 'caminhoes' AND CAT_LK_pt = 'chassi-com-cabine' AND ma_lk = 'iveco-astra' GROUP BY car_id
Warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given in /home/belgapha/www/transauto/new/inc/PARAM_CONNECT.php on line 43
Unknown column 'TX_txt_pt' in 'field list' -
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_px, V.car_ext,
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_pt, C.CAT_LK_pt, C.CAT_ID,
D.DEP_pt, D.DEP_LK_pt, D.DEP_ID,
TX.txt_id, TX_txt_pt as carburant,
TS.txt_pt,
TSER.TX_TIT_pt AS txt_titre,
TSER.TX_TXT_pt 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 DEP_LK_pt = 'caminhoes' AND CAT_LK_pt = 'chassi-com-cabine' AND ma_lk = 'iveco-astra' GROUP BY car_id ORDER BY car_typ ASC, car_vol ASC, if(M.ma_ma = '' or M.ma_ma is null,1,0),M.ma_ma DESC , V.car_nom ASC, car_tpx = 0, car_tpx DESC LIMIT 0,30
Warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given in /home/belgapha/www/transauto/new/inc/PARAM_CONNECT.php on line 43
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 329
Notice: Trying to get property 'car_dep' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 329
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 329
Notice: Trying to get property 'DEP_pt' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 329
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 330
Notice: Trying to get property 'DEP_pt' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 330
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 348
Notice: Trying to get property 'ma_ma' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 348
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 349
Notice: Trying to get property 'ma_ma' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 349
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 364
Notice: Trying to get property 'CAT_pt' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 364
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Trying to get property 'car_dep' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Trying to get property 'car_cat' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 429
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Trying to get property 'car_dep' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Trying to get property 'car_cat' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 430
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Trying to get property 'car_dep' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Undefined offset: 0 in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Trying to get property 'car_cat' of non-object in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Undefined index: in /home/belgapha/www/transauto/new/newliste.php on line 431
Notice: Trying to access array offset on value of type null in /home/belgapha/www/transauto/new/newliste.php on line 431
os mais procurados :
Transautomobile
1589 D, Chaussée de Waterloo - 1180 Bruxelas - Bélgica
Tel : +32 2 352 01 31 - Fax : +32 2 352 01 51
TVA : BE 0424.019.365