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

HACKSAW MINI


View as Grid List

17 items

Page
per page
Set Descending Direction
  1. CUSH GRIP MULTI-SAW Call for Price
    20-220 MULTIPURPOSE SAW CUSHION GR Learn More
  2. PROTOUCH TM MULTI-SAW Call for Price
    2015100 PRO MULTI SAW HACK & WOOD Learn More
  3. SHEFFIELD HANDI HACKSAW Call for Price
    58253 10" HD CLOSE QTR HACKSAW Learn More
  4. LENOX COMPACT HACKSAW FRAME Call for Price
    1805722 COMPACT HACKSAW FRAME Learn More
  5. CLOSE QUARTER ALUMINUM HACKSAW Call for Price
    HF25 10" CLOSE QTR HACK SAW 24TH Learn More
  6. MINI HACKSAW Call for Price
    20-807 MINI HACK UTILITY SAW 10" Learn More
  7. LENOX CLOSE QUARTERS HACKSAW Call for Price
    20908908 CLOSE QTR HACKSAW Learn More
  8. REPLACEMENT BLADES FOR MINI HACK SAW Call for Price
    PST125 REPL BLDS FOR INI HACK SAW Learn More
  9. TRUE CLOSE QUARTER HACKSAW Call for Price
    80070 TRUE CLOSE QUARTER HACKSAW Learn More
View as Grid List

17 items

Page
per page
Set Descending Direction