Фабрика / Коллекция
Материал / Назначение
Цвет
SELECT DISTINCT `d_collections`.`collection_id`, `collection_name`, `trademark_id`, `trademark_name`, `country_name`, `option`, IFNULL(`collection_order`, -1) AS `main_order`, CASE WHEN `option` & 16 THEN 'Exclusive' WHEN `option` & 1 THEN 'New' WHEN `pricegroup` = 16 THEN 'Sale' WHEN `pricegroup` = 36 THEN 'Stop' ELSE '' END AS `sticker` FROM `d_collections` NATURAL JOIN `d_items` NATURAL JOIN `d_trademarks` NATURAL JOIN `d_countries` NATURAL LEFT JOIN `d_order` NATURAL LEFT JOIN (SELECT `collection_id`, `collection_order` FROM `d_order`) AS `collection_order` WHERE `d_collections`.`collection_id` IN () ORDER BY `main_order` DESC, `collection_id` DESC, `sticker` DESC: 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 `main_order` DESC, `collection_id` DESC, `sticker` DESC' at line 1