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` = 67) WHERE (`e`.`entity_id` IN('2465', '2569', '2594')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ONE MAN,TWO MAN & BOW SAWS - HAND SAWS - HAND & POWER TOOLS
  1. See Detail

ONE MAN,TWO MAN & BOW SAWS


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. COMBI-SAW
    $14.99 /EA
    218HP300 COMBI-SAW 12"/317MM HRD PT Learn More
  2. REPLACEMENT BLADES FOR BOW SAWS
    $4.49 /EA
    524B 24" REPLACEMENT BOW SAW BLADE Learn More
  3. REPLACEMENT BOWSAW BLADE
    $4.59 /EA
    80814 12" REPLC BLD 4BOWHAC Learn More
  4. BOW SAW
    $8.89 /EA
    BB24 24" BOW SAW Learn More
  5. BOW SAW
    $5.79 /EA
    LG2013 BOW SAW Learn More
  6. BOWHACK REPLACEMENT BLADE
    $12.99 /EA
    80799 BOWHACK 12" SAW NICHOLSON Learn More
  7. REPLACEMENT BLADES FOR BOW SAWS
    $12.99 /EA
    536B 36" REPLACEMENT BOW SAW BLADE Learn More
  8. BOW SAW BLADE
    $2.79 /EA
    70256935J BOW SAW BLADE 21" Learn More
  9. 12" BOWSAW/HACKSAW
    $9.99 /EA
    15550 12" COMBO BOWSAW/HACKSAW Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction