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('2465', '2569', '2584')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HACK SAWS - HAND SAWS - HAND & POWER TOOLS
  1. See Detail

HACK SAWS


View as Grid List

90 items

Page
per page
Set Descending Direction
  1. CLOSE QUARTER ADJUSTABLE HACKSAW Call for Price
    58252 SHF ADJ 10" HACKSAW Learn More
  2. MOLYBDENUM HACKSAW BLADES Call for Price
    GM212 10-32 MOLY BLDS 2-CD Learn More
  3. HACKSAW BLADE Call for Price
    GF212 12" STD HACKSAW BLADE 2PK Learn More
  4. HACKSAW BLADE Call for Price
    GF213 12" HACKSAW BLD 24T Learn More
  5. HACKSAW BLADE Call for Price
    GF51C 10" HACKSAW BLD 5-PK Learn More
  6. COLBALT HACKSAW BLADE Call for Price
    4418 COLBALT BLD 12X18 Learn More
  7. COLBALT HACKSAW BLADE Call for Price
    4424 COLBALT BLD 12X24 Learn More
  8. 3 PC COBALT HACKSAW BLADE SET Call for Price
    4433 COLBALT BLD 3PC SET Learn More
  9. HACKSAW BLADE Call for Price
    4333 CARBON BLADE 2PC 12X18 Learn More
View as Grid List

90 items

Page
per page
Set Descending Direction