You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '23) DESC LIMIT 2' at line 6 SELECT ic.`ic_id`,ic.`ic_orders`,iav.*,`items_values`.`iv_value_ua`,`items_attributes`.`ia_subtitle_ua` FROM `items_cats` ic
LEFT JOIN `items_attribute_value` iav ON iav.`iav_i_id` = 461
LEFT JOIN `items_attributes` ON iav.`iav_ia_id` = `items_attributes`.`ia_id`
LEFT JOIN `items_values` ON `iv_id` = `iav_iv_id`
WHERE ic.`ic_id` = 41
ORDER BY FIELD(`iav_ia_id`,,23) DESC LIMIT 2
Фільтри
