SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '43') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '43') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('39', '50')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Common Kits with Standard Hardware - Strip Doors

Common Kits with Standard Hardware

We're sorry, an error has occurred while generating this email.
View as List Grid

120 items

Page
per page
Set Descending Direction
View as List Grid

120 items

Page
per page
Set Descending Direction