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', '1702', '1720', '1738')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LIVESTOCK SPRAYS AND INSECTICIDES PESTICIDES - INSECTICIDES/REPELLENTS/FUNGICIDE - FERTILIZERS, SOIL CONDITIONERS - LAWN AND GARDEN
  1. See Detail

LIVESTOCK SPRAYS AND INSECTICIDES PESTICIDES


View as Grid List

12 items

Page
per page
Set Descending Direction
  1. GORDON'S HORSE AND STABLE SPRAY Call for Price
    7681112 HORSE/STABLE 32OZ Learn More
  2. RTU EQUINE SPRAY Call for Price
    46181 RVNGE EQUINE SPRAY GAL REFILL Learn More
  3. RTU REVENGE EQUINE SPRAY Call for Price
    46182 RVNGE EQUINE SPRAY 1.33 GAL Learn More
  4. REVENGE BARN AND STABLE SPRAY (READY TO USE) Call for Price
    46186 RVNGE BARN & STABLE 1.33 GRTU Learn More
  5. HY32202 GARDEN PET & LIVESTOCK DUST 4 LB BAG Call for Price
    HY32202 GARDEN PET & LIVESTOCK DUST Learn More
  6. LAWN, GARDEN, PET & LIVESTOCK INSECT CONTROL Call for Price
    32005 PT GARDEN PET & LVSTK CONTROL Learn More
  7. BARN AND STABLE SPRAY Call for Price
    46178 RVNG BARN&STABLE CONC QT Learn More
  8. BARN AND STABLE SPRAY Call for Price
    46177 RVNG BARN&STABLE CONC PT Learn More
  9. HORSE AND STABLE SPRAY Call for Price
    46175 RVNG HORSE&STABLE RTU 1.33G Learn More
View as Grid List

12 items

Page
per page
Set Descending Direction