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` = 93) WHERE (`e`.`entity_id` IN('1460', '1788', '1789', '1791')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
  1. See Detail

GARDEN WATER HOSES SOAKER WEEPER SPRINKLER


View as Grid List

11 items

Page
per page
Set Descending Direction
  1. SOAKER HOSE
    $17.29 /EA
    270142 50' SPRINKLER/SOAKER HOSE Learn More
  2. SOAKER HOSE
    $11.69 /EA
    ELSP38025/SNUER12025 SOAKER HOSE 25 Learn More
  3. SPRINKLER HOSE
    $24.49 /EA
    2030-50 SPRINKLER HOSE Learn More
  4. SOAKER HOSE
    $18.89 /EA
    ELSP38050/SNUER12050 SOAKER 1/2"X50 Learn More
  5. HOSE SOAKER
    $13.59 /EA
    1030-25' HOSE SOAKER Learn More
  6. WEEPER HOSE
    $16.39 /EA
    27058025 25' WATER WEEPER HOSE Learn More
  7. SOAKER HOSE
    $25.39 /EA
    ELSP38075/SNUER12075 SOAKER HOSE 75 Learn More
  8. SPRINKLER HOSE
    $16.89 /EA
    ELTEC050/SNTEC050 SPRKLR/SOAKR 50' Learn More
  9. HOSE SOAKER
    $17.39 /EA
    1030-50' HOSE SOAKER Learn More
View as Grid List

11 items

Page
per page
Set Descending Direction