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', '1646', '1653', '1658')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SPRAYERS HOSE END - HAND SPRAYERS/DUSTERS/INSECTICIDES - LAWN ROLLERS, SPREADERS,GARDEN S - LAWN AND GARDEN
  1. See Detail

SPRAYERS HOSE END


View as Grid List

5 Items

per page
Set Descending Direction
  1. DIAL-N-SPRAY MULTI-USE HOSE END SPRAYER Call for Price
    0841010/0836560 DIAL-A-SPRAY HSEND Learn More
  2. MIRACLE GRO WATERPROOF GARDEN FEEDER Call for Price
    1004102/101 MIRGRO NOCLOG 4N1 Learn More
  3. HOSE END MIX SPRAYER Call for Price
    051 HOSE END MIX SPRAYER Learn More
  4. CAMELEON CONVERTIBLE HOSE END Call for Price
    62140 CAMELON CONVERTIBLE HOSE END Learn More
  5. ECONOMICAL HOSE END SPRAYER Call for Price
    2100 ECONOMICAL HOSE END SPRAYER Learn More
View as Grid List

5 Items

per page
Set Descending Direction