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', '1856', '1857')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') INDUSTRIAL HOSE FITTINGS - HOSE AND HOSE FITTINGS-INDUSTRIA - LAWN AND GARDEN
  1. See Detail

INDUSTRIAL HOSE FITTINGS


View as Grid List

176 items

Page
per page
Set Descending Direction
  1. DRAIN COCK Call for Price
    6-5465 DRAIN COCK 1/8" NPT Learn More
  2. 3 INCH MANIFOLD TRIPOD Call for Price
    6-5275 3" 1 MANIFOLD TRIPOD 1/4" Learn More
  3. COMPRESSOR FILTER Call for Price
    6-5485 COMPRESSOR FILTER Learn More
  4. RECOIL AIR HOSE Call for Price
    6-5320 1/4"X12' RECOIL AIR HOSE Learn More
  5. MALE COUPLER Call for Price
    6-5217 MALE COUPLER 1/4" NP Learn More
  6. ALUMINUM POCKET BLOWGUN Call for Price
    M522 ALUM POCKET BLOWGUN Learn More
  7. FLEX BLOW GUN TIP Call for Price
    M519 FLEX BLOW GUN TIP Learn More
  8. 7 PCS HOSE REPAIR KIT 3/8' Call for Price
    M479 7PC HOSE REPAIR KIT Learn More
  9. 1/4' NPT UNIVERSAL COUPLER Call for Price
    M461 1/4" NPT UNVI COUPLER Learn More
View as Grid List

176 items

Page
per page
Set Descending Direction