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

POWER DRILLS AND SCREWDRIVERS


View as Grid List

1968 items

Page
per page
Set Descending Direction
  1. 18V 2.8AH NIMH DEWALT REPLACEMENT BATTERY
    $101.39 /EA
    TOL2603 18V 2.8AH DEWALTXRP Learn More
  2. PIVOT BIT TIP HOLDER WITH RING
    $13.49 /EA
    DWPVTHLD PIVOT BIT TIP HLDR W/RING Learn More
  3. POWER DRIVER
    $8.69 /EA
    68588 POWER DRIVER Learn More
  4. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $39.89 /EA
    3043014/47418 1-1/8" SHIP AUGER BIT Learn More
  5. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $24.99 /EA
    3043004/47406 3/8X17"OL PWR AUGER Learn More
  6. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $25.79 /EA
    3043005/47408 1/2X17"OL POWR AUGER Learn More
  7. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $27.09 /EA
    3043006/47409 9/16X17"OL POWR AUGER Learn More
  8. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $27.59 /EA
    3043007/47410 5/8"X17"OL POWR AUGER Learn More
  9. SPEEDBOR SHIP AUGER BITS WITH WELDTEC
    $30.89 /EA
    3043009/47412 3/4X17"OL POWR AUGR Learn More
View as Grid List

1968 items

Page
per page
Set Descending Direction