24080

9686

23015

13245

322325

+


«Экспострой»
+7 (495) 925 05 11
«Artplay на Яузе»
+7 (495) 925 51 57
«Конструктор»
+7 (495) 921 41 67

Дилерский отдел


+7 (495) 925 05 71

Где купить?

Фабрика / Коллекция

Материал / Назначение

Каталог

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