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` = 122) WHERE (`e`.`entity_id` IN('2465', '2826', '2841', '2854')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') DRILL BITS TURBOMAX - TWIST DRILLS & MASONRY DRILLS - POWER DRILLS AND SCREWDRIVERS - HAND & POWER TOOLS
  1. See Detail

DRILL BITS TURBOMAX


View as Grid List

31 items

Page
per page
Set Descending Direction
  1. IMPACT TURBO MAX BIT
    $4.99 /EA
    1871021 IMP TURBOMAX 1/16 Learn More
  2. IRWIN TURBOMAX TM DRILL BIT WITH JET POINT TM TIP (CARDED)
    $5.99 /EA
    73322 11/32 TURBOMAX JOBBER Learn More
  3. IMPACT TURBO MAX BIT
    $5.49 /EA
    1871027 IMP TURBOMAX 5/32 Learn More
  4. IMPACT TURBO MAX BIT
    $5.89 /EA
    1871028 IMP TURBOMAX 3/16 Learn More
  5. IMPACT TURBO MAX BIT
    $6.39 /EA
    1871029 IMP TURBOMAX 7/32 Learn More
  6. IMPACT TURBO MAX BIT
    $7.39 /EA
    1871030 IMP TURBOMAX 1/4 Learn More
  7. IMPACT TURBO MAX BIT
    $8.29 /EA
    1871041 IMP TURBOMAX 9/32 Learn More
  8. IMPACT TURBO MAX BIT
    $10.99 /EA
    1871042 IMP TURBOMAX 3/8 Learn More
  9. IMPACT TURBO MAX BIT
    $14.99 /EA
    1871043 IMP TURBOMAX 7/16 Learn More
View as Grid List

31 items

Page
per page
Set Descending Direction