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', '2791')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') DIABLO CIRCULAR SAW BLADES - CIRCULAR SAW BLADES - POWER SAWS AND POWER SAW BLADES - HAND & POWER TOOLS
  1. See Detail

DIABLO CIRCULAR SAW BLADES


View as Grid List

13 items

Page
per page
Set Descending Direction
  1. Combo Blade
    $37.99 /EA
    4490421 D1244X 12" 44T COMBO BLADE Learn More
  2. General Purpose Saw Blade
    $42.49 /EA
    4494480 D1040A 10X40ATB GEN/PUR BLD Learn More
  3. Finish Blade
    $86.49 /EA
    4490413 D1296N 12" 96T FINISH BLADE Learn More
  4. Finish Saw Blade
    $48.99 /EA
    4493060 D1060X 10" 60T FINISH BL Learn More
  5. CROSSCUT BLADE
    $19.49 /EA
    4494464 D0740A 7-1/4 FINISH BL 40TH Learn More
  6. Thin Kerf Finish Saw Blade
    $69.99 /EA
    4496683 D1280X 12" 80T FINISH BL Learn More
  7. Ripping Blade
    $34.99 /EA
    4493037 D1024X 10" 24TH BL RIP BLDE Learn More
  8. HARDIBLADE
    $70.99 /EA
    449-0181 D0704DH 7-1/4 HARDIBLADE Learn More
  9. Thin Kerf Saw Blade
    $45.99 /EA
    4493052 D1050X 10" 50T COMBO BLADE Learn More
View as Grid List

13 items

Page
per page
Set Descending Direction