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('1977', '2004', '2005')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') DOG & CAT SUPPLIES - PET SUPPLIES - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

DOG & CAT SUPPLIES


View as Grid List

124 items

Page
per page
Set Descending Direction
  1. SUPER BEAST TIE OUT Call for Price
    Q6830-000-99 30'SUPER BEAST TIEOUT Learn More
  2. SUPER BEAST TIE OUT Call for Price
    Q6820-000-99 20'SUPER BEAST TIEOUT Learn More
  3. CABLE TROLLEYS Call for Price
    Q5100/63564 100' DOG TROLLEY Learn More
  4. CABLE TROLLEYS Call for Price
    Q5050 50' DOG TROLLEY SYSTEM Learn More
  5. CABLE TROLLEYS Call for Price
    Q5070-000-99 70' DOG TROLLEY SYSTEM Learn More
  6. COW HOOVES Call for Price
    013267 COW HOOVES 6PK Learn More
  7. ASSORTED FLAVORED STICKS Call for Price
    PP-010796 5"AST FLV STICKS Learn More
  8. ASSORTED FLAVOR ROLLS Call for Price
    PP-010833 5"AST FLV ROLLS Learn More
  9. BULLY STICKS (2 PACK) Call for Price
    012017 BULLIES STICKS 12"2P Learn More
View as Grid List

124 items

Page
per page
Set Descending Direction