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', '2773', '2780', '2783')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') METAL CUTTING BLADES ABRASIVE COMBO AND CARBIDE - CIRCULAR SAW BLADES - POWER SAWS AND POWER SAW BLADES - HAND & POWER TOOLS
  1. See Detail

METAL CUTTING BLADES ABRASIVE COMBO AND CARBIDE


View as Grid List

57 items

Page
per page
Set Descending Direction
  1. COMBO BLADE
    $55.99 /EA
    4490728 D1260X 12" 60T COMBO BLD Learn More
  2. METAL CUTTING SAW BLADES
    $3.89 /EA
    08808 METAL CUTTING BLADE 8" CD Learn More
  3. METAL CUTTING SAW BLADES
    $4.59 /EA
    08806 METAL CUTTING 6 1/2" CD Learn More
  4. CHOP SAW BLADE
    $7.89 /EA
    08712 CHOP SAW BLADE 12"X3/32" Learn More
  5. METAL CUTTING BLADE
    $3.39 /EA
    8707 METAL CUT BLD 7" Learn More
  6. METAL WHEEL
    $1.99 /EA
    DW4518 4-1/2X1/8X7/8 METAL CUT WHEE Learn More
  7. RED CERAMIC METAL CUTTING ABRASIVE BLADE
    $4.29 /EA
    28050 7" RED CER/MTL BLD Learn More
  8. NORTON METALCUTTING BLADES
    $5.59 /EA
    89005 7" MET CUT BLADE Learn More
  9. METAL CUTOFF WHEEL
    $1.69 /EA
    08303 3X1/32 CUTOFF WHL Learn More
View as Grid List

57 items

Page
per page
Set Descending Direction