MySQL Query Error: SELECT vap.ac_articul, vap.ac_color, biep.PROPERTY_127 as id_ac, biep_m.VALUE, biep.PROPERTY_124 AS User_name, biep.PROPERTY_129 AS User_city, bie.DETAIL_TEXT AS user_comment,
bie.PREVIEW_TEXT AS user_answer, bie.DATE_CREATE AS user_dt, vap.ac_id, biep.IBLOCK_ELEMENT_ID as rv_id, biep.PROPERTY_305 AS id_mp3_file,
biep.PROPERTY_290 AS rating, biep.PROPERTY_289 AS kod_intrest,
biep.PROPERTY_359 AS rost, biep.PROPERTY_360 AS cl_param, biep.PROPERTY_361 AS ac_size, biep.PROPERTY_362 AS ac_color_old, bie.DATE_CREATE, bie.TIMESTAMP_X, bie.SORT
from b_iblock_element_prop_s19 biep
LEFT OUTER JOIN b_iblock_element bie ON bie.ID = biep.IBLOCK_ELEMENT_ID
LEFT OUTER JOIN b_iblock_element_property biep_m ON biep_m.IBLOCK_ELEMENT_ID = biep.PROPERTY_127 and biep_m.IBLOCK_PROPERTY_ID = 21
LEFT OUTER JOIN vw_ac_properties vap ON vap.ac_id = biep.PROPERTY_127
WHERE bie.ACTIVE = 'Y'
AND biep_m.VALUE like '/%'
AND biep.PROPERTY_127 <> '18996'
AND vap.tm_id =
order by bie.SORT asc, biep.PROPERTY_305 desc LIMIT 999[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 'order by bie.SORT asc, biep.PROPERTY_305 desc LIMIT 999' at line 15]
DB query error.
Please try later.
|
|
