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', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Anti Scratch Ribbed Strip Doors - Strip Doors

Anti Scratch Ribbed Strip Doors

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

105 items

Page
per page
Set Descending Direction
View as List Grid

105 items

Page
per page
Set Descending Direction