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', '1748', '1752')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') BRUSH KILLER HERBICIDES - WEED-BRUSH-STUMP CONT./HERBICIDE - FERTILIZERS, SOIL CONDITIONERS - LAWN AND GARDEN
  1. See Detail

BRUSH KILLER HERBICIDES


View as Grid List

8 Items

per page
Set Descending Direction
  1. BRUSH KILLER, SUPER BK32 Call for Price
    330 BRUSH KILLER BK32 PT Learn More
  2. BRUSH KILLER, SUPER BK32 Call for Price
    331 BRUSH KILLER BK32 QRT Learn More
  3. GORDON'S ALL SEASON BRUSH-NO-MORE Call for Price
    78316 BRUSH-NO-MORE QUARTS Learn More
  4. GORDON'S BRUSH KILLER Call for Price
    2321072/8881072 BRUSH KILLER GALLON Learn More
  5. BRUSH KILLER Call for Price
    332 BRUSH KILL GAL CONC Learn More
  6. IMAGE BRUSH AND VINE KILLER Call for Price
    100509331 IM BRUSH&VINE KIL Learn More
  7. IMAGE HERBICIDE BRUSH AND VINE KILLER Call for Price
    100504775 IM BRUSH&VINE KIL Learn More
  8. IMAGE BRUSH AND VINE KILLER Call for Price
    100099398 IM BRUSH&VINE KILLER Learn More
View as Grid List

8 Items

per page
Set Descending Direction