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', '1788', '1842', '1848')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SPRINKLERS ROTARY ROTOR - SPRINKLERS & SOAKERS - HOSE,HOSE ACCESSORIES/TUBING - LAWN AND GARDEN
  1. See Detail

SPRINKLERS ROTARY ROTOR


View as Grid List

7 Items

per page
Set Descending Direction
  1. SPRINKLER BRASS 3 ARM ROTARY Call for Price
    RS3B SPRINKLER BRASS 3ARM ROTARY Learn More
  2. THREE-ARM ROTARY SPRINKLER Call for Price
    883 CIRCLE PATTERN ROTARY SPRINKLER Learn More
  3. SQUARE PATTERN ROTARY SPRINKLER Call for Price
    WS450S SQ PATTERN ROTARY SPRINKLER Learn More
  4. SPRINKLER Call for Price
    RS3APDQ SPRINKLER Learn More
  5. HIGH RISE GARDEN SPRINKLER Call for Price
    894 HIGH RISE SPRINKLER SQ Learn More
  6. ROTOR SPRINKLER Call for Price
    22SAF 1" ROTARY POPUP SPRAY 18'-24' Learn More
  7. ROTOR SPRINKLER Call for Price
    22SAH 4" RORARY POPUP SPRAY 18'-24' Learn More
View as Grid List

7 Items

per page
Set Descending Direction