Входные и межкомнатные двери
Пн-Пт: 10.00-20.00 Сб: 10.00-20.00 Вс: 10.00-18.00
ЋиЁЎЄ  ўў®¤ /ўлў®¤  Ѓ„:
SELECT `d7_steel_door`.`id`, `d7_steel_door`.`itemId`, `d7_steel_door`.`folderId`, `d7_steel_door`.`groupId`, `d7_steel_door`.`path`, `d7_steel_door`.`name` as name, `d7_steel_door`.`altNames`, `d7_steel_door`.`zamok1`, `d7_steel_door`.`zamok2`, IF(`d7_steel_door`.`zamkiText` IS NOT NULL, `d7_steel_door`.`zamkiText`, `group`.`zamkiText`) as zamkiText, `d7_steel_door`.`photoId`, `d7_steel_door`.`smallPhotoId`, `d7_steel_door`.`outType`, `d7_steel_door`.`outColor`, `d7_steel_door`.`outThick`, `d7_steel_door`.`outPanel`, `d7_steel_door`.`outPhoto`, `d7_steel_door`.`inType`, `d7_steel_door`.`inColor`, `d7_steel_door`.`inThick`, `d7_steel_door`.`inPanel`, `d7_steel_door`.`inPhoto`, `d7_steel_door`.`otdelkaText`, `d7_steel_door`.`complekt`, IF(`d7_steel_door`.`steelSize` IS NOT NULL, ROUND(`d7_steel_door`.`steelSize`/10, 1), ROUND(`group`.`steelSize`/10, 1)) as steelSize, IF(`d7_steel_door`.`steelSize` IS NOT NULL, ROUND(`d7_steel_door`.`steelKorob`/10, 1), ROUND(`group`.`steelKorob`/10, 1)) as steelKorob, `d7_steel_door`.`steelText`, `d7_steel_door`.`street`, `d7_steel_door`.`furnColor`, `d7_steel_door`.`conturs`, `d7_steel_door`.`size`, `d7_steel_door`.`sizeText`, `d7_steel_door`.`sizeZakaz`, `d7_steel_door`.`tags`, `d7_steel_door`.`minCost`, `d7_steel_door`.`maxCost`, `d7_steel_door`.`isZakaz`, `d7_steel_door`.`pos`, `d7_steel_door`.`hide`, `folder`.`name` as folderName, `folder`.`bigName`, `folder`.`description`, `folder`.`path` as folderPath, `d7_zamok1`.`name` AS zamok1Id, `d7_zamok1`.`displayName` AS zamok1Name, `d7_zamok1`.`descr` AS Zamok1Descr, `d7_zamok1`.`vzlom_class` AS zamok1VzlomClass, `d7_zamok1`.`system_type` AS zamok1SystemType, `d7_zamok_system_type1`.`displayName` AS zamok1SystemName, `d7_zamok2`.`name` AS zamok2Id, `d7_zamok2`.`displayName` AS zamok2Name, `d7_zamok2`.`descr` AS zamok2Descr, `d7_zamok2`.`vzlom_class` AS zamok2VzlomClass, `d7_zamok2`.`system_type` AS zamok2SystemType, `d7_zamok_system_type2`.`displayName` AS zamok2SystemName, `d7_cover_type`.`displayName` as outCoverName, `d7_cover_type`.`name` as outCoverId, `d7_cover_color`.`displayName` as outColorName, `d7_cover_color`.`name` as outColorId, `d7_cover_type_in`.`displayName` as inCoverName, `d7_cover_type_in`.`name` as inCoverId, `d7_cover_color_in`.`displayName` as inColorName, `d7_cover_color_in`.`name` as inColorId, `d7_size`.`displayName` as sizeName, `d7_size`.`name` as sizeId, `d7_size_pinfo`.`titleName` as sizeTitle, `d7_size_pinfo`.`useFurnColor` as sizeuseFurnColor, `d7_conturs`.`displayName` as contursName, `d7_conturs`.`name` as contursId, `d7_conturs_pinfo`.`titleName` as contursTitle, `d7_conturs_pinfo`.`useFurnColor` as contursuseFurnColor, `photo`.`filename`, `folder`.`name` as folderName, `folder`.`name2` as folderName2, `folder`.`itemHaveTitle` as haveFolderTitle, `folder`.`itemUrl` as itemUrlTemplate, `folder`.`itemImageUrl` as imageUrlTemplate, `d7_steel_door_color_groups`.`coverColors`, `d7_steel_door_color_groups`.`colorGroups` FROM `d7_steel_door` Inner Join `folder` ON `d7_steel_door`.`folderId` = `folder`.`id` Left Join `d7_steel_door` as `group` ON IF(`d7_steel_door`.`groupId` IS NULL, `group`.`itemId` = -1 AND `group`.`folderId` = `d7_steel_door`.`folderId`, `d7_steel_door`.`groupId` = `group`.`itemId` AND `group`.`folderId` = `d7_steel_door`.`folderId`) Left Join `d7_zamok` as `d7_zamok1` ON IF(`d7_steel_door`.`zamok1` IS NOT NULL, `d7_steel_door`.`zamok1`, `group`.`zamok1`) = `d7_zamok1`.`name` Left Join `d7_param_info` as `d7_zamok1_pinfo` ON `d7_zamok1_pinfo`.`name` = 'zamok1' Left Join `d7_zamok` as `d7_zamok2` ON IF(`d7_steel_door`.`zamok2` IS NOT NULL, `d7_steel_door`.`zamok2`, `group`.`zamok2`) = `d7_zamok2`.`name` Left Join `d7_param_info` as `d7_zamok2_pinfo` ON `d7_zamok2_pinfo`.`name` = 'zamok2' Left Join `d7_zamok_system_type` as `d7_zamok_system_type1` ON `d7_zamok1`.`system_type` = `d7_zamok_system_type1`.`name` Left Join `d7_zamok_system_type` as `d7_zamok_system_type2` ON `d7_zamok2`.`system_type` = `d7_zamok_system_type2`.`name` Left Join `d7_cover_type` ON `d7_steel_door`.`outType` = `d7_cover_type`.`name` Left Join `d7_cover_color` ON `d7_steel_door`.`outColor` = `d7_cover_color`.`name` Left Join `d7_cover_type` as `d7_cover_type_in` ON `d7_steel_door`.`inType` = `d7_cover_type_in`.`name` Left Join `d7_cover_color` as `d7_cover_color_in` ON `d7_steel_door`.`inColor` = `d7_cover_color_in`.`name` Left Join `photo` ON `photo`.`id` = IF(`d7_steel_door`.`smallPhotoId` IS NOT NULL, `d7_steel_door`.`smallPhotoId`, `d7_steel_door`.`photoId`) Left Join `d7_steel_door_color_groups` ON `d7_steel_door_color_groups`.`id` = `d7_steel_door`.`id` Left Join `d7_size` as `d7_size` ON IF(`d7_steel_door`.`size` IS NOT NULL, `d7_steel_door`.`size`, `group`.`size`) = `d7_size`.`name` Left Join `d7_param_info` as `d7_size_pinfo` ON `d7_size_pinfo`.`name` = 'size' Left Join `d7_conturs` as `d7_conturs` ON IF(`d7_steel_door`.`conturs` IS NOT NULL, `d7_steel_door`.`conturs`, `group`.`conturs`) = `d7_conturs`.`name` Left Join `d7_param_info` as `d7_conturs_pinfo` ON `d7_conturs_pinfo`.`name` = 'conturs' Left Join `d7_furn_color` as `d7_furnColor` ON IF(`d7_steel_door`.`furnColor` IS NOT NULL, `d7_steel_door`.`furnColor`, `group`.`furnColor`) = `d7_furnColor`.`name` Left Join `d7_param_info` as `d7_furnColor_pinfo` ON `d7_furnColor_pinfo`.`name` = 'furnColor' Left Join `d7_creator` as `d7_created` ON IF(`d7_steel_door`.`created` IS NOT NULL, `d7_steel_door`.`created`, `group`.`created`) = `d7_created`.`name` Left Join `d7_param_info` as `d7_created_pinfo` ON `d7_created_pinfo`.`name` = 'created' WHERE `d7_steel_door`.`itemId` = 1747