Входные и межкомнатные двери
Пн-Пт: 10.00-20.00 Сб: 10.00-20.00 Вс: 10.00-18.00
Быстрый подбор двери
Показать цветовую карту
ЋиЁЎЄ  ўў®¤ /ўлў®¤  Ѓ„:
SELECT `room_doors`.`id`, `room_doors`.`name`, `room_doors`.`imagePath`, `room_doors`.`colors`, `room_doors`.`cost1`, `room_doors`.`glass`, `room_doors`.`parentId`, `room_doors`.`order`, `room_doors`.`imagePostfix`, `room_folder`.`id` as folderId, `room_folder`.`name` as folderName, IF(`room_folder`.`parentId` IS NOT NULL, `room_folder`.`parentId`, `room_folder`.`id`) as rootFolderId, `room_folder`.`path`, `room_folder`.`prefix`, `room_folder`.`title`, `room_folder`.`furnitura`, `room_folder`.`costKomplekt`, `room_folder`.`costDobor`, `room_folder`.`material`, `room_folder`.`itemDescr`, `room_folder`.`searchSynonim` as folderTags, `room_folder`.`order` as folderOrder, `room_folder`.`size` FROM `room_doors` Inner Join `room_folder` ON `room_doors`.`parentId` = `room_folder`.`id` WHERE (`room_doors`.`hide` IS NULL) AND ( CONCAT(';', colors, ';') LIKE '%;bereza_mor;%') ORDER BY cost1