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

PET TOYS


View as Grid List

13 items

Page
per page
Set Descending Direction
  1. DOGZILLA SNARL TUG Call for Price
    30891 SNARL TUG-MED Learn More
  2. DOGZILLA SPIKE BALL Call for Price
    52048 SPIKE BALL DOGZILLA Learn More
  3. RAWHIDE BONES Call for Price
    019009 RAWHIDE BONES 13-14" Learn More
  4. DOGZILLA MONSTER TUG Call for Price
    52039 MONSTER TUG Learn More
  5. DOGZILLA DINO LINKS Call for Price
    52057 DINO LINKS SMALL Learn More
  6. DOGZILLA SNARL TUG Call for Price
    30892 SNARL TUG-LARGE Learn More
  7. DOGZILLA SQUEAKY TREAT BONE Call for Price
    52054 SQKY TREAT BONE MED Learn More
  8. COMPRESSED BONE Call for Price
    00003 COMPRESSED BONE 8.5" Learn More
  9. DOGZILLA TREAT POD Call for Price
    52041 TREAT POD LARGE Learn More
View as Grid List

13 items

Page
per page
Set Descending Direction