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` = '46') 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` = '46') AND (`at_is_active`.`store_id` = 90) WHERE (`e`.`entity_id` IN('1460', '1966', '1972', '1973')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LABEL HOLDERS CLEAR CHIPS BREAD TAG STYLE AND WALL RACKS - STORE FIXTURES&ACCESSORIES - STORE FIXTURES & ACCESSORIES - LAWN AND GARDEN
  1. See Detail

LABEL HOLDERS CLEAR CHIPS BREAD TAG STYLE AND WALL RACKS


View as Grid List

13 items

Page
per page
Set Descending Direction
  1. PERFBOARD HOOK TICKET HOLDER Call for Price
    SERIES L CLOSURE LABEL #2 OPEN Learn More
  2. SNAP LOCK LABEL HOLDER Call for Price
    R35L-250 21/2"LABEL HOLDER Learn More
  3. SCAN HOOKS Call for Price
    R33-8-212 2PC SCAN HOOK 8" Learn More
  4. BIN TAG HOLDER Call for Price
    206-1 BIN TAG HOLDER Learn More
  5. SCAN HOOKS Call for Price
    R33-4-212 2PC SCAN HOOK 4" Learn More
  6. CLEAR SCAN PLASTIC CHIP Call for Price
    3"CLEAR PLAS CHIP (250) Learn More
  7. SNAP LOCK LABEL HOLDER Call for Price
    R35L-3 3" LABEL HOLDER Learn More
  8. SCAN HOOKS Call for Price
    R33-10-212 2PC SCAN HK 10" Learn More
  9. TICKET HOLDER Call for Price
    RNC-278 TICKET HOLDER 27/8 Learn More
View as Grid List

13 items

Page
per page
Set Descending Direction