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

HAND & POWER TOOLS


View as Grid List

7898 items

Page
per page
Set Descending Direction
  1. HANSON HIGH SPEED STEEL DRILL BITS
    $2.39 /EA
    60509 HSS 9/64" DRILL BIT Learn More
  2. 5 AMP JIGSAW
    $48.69 /EA
    RC3748 5AMP JIGSAW Learn More
  3. SMARTTOOL
    $137.99 /EA
    92296 SMARTTOOL 120CM 471/4 Learn More
  4. SKIDDING TONG
    $117.29 /EA
    4080051 SKIDDING TONG 1/2 Learn More
  5. 85 PIECE SAE AND METRIC SOCKET SET
    $34.99 /EA
    HM85 85PC SOCKET/RACHET SET MM/SAE Learn More
  6. QUICK RATCHETING BAR CLAMP & SPREADERS
    $16.29 /EA
    59002 18"QUICK BAR CLAMP & SPREADER Learn More
  7. BRITE DRILL BIT
    $13.29 /EA
    11626 LETTER Z BRITE DRILL BIT Learn More
  8. TIN SNIPS
    $13.25 /EA
    72726 TIN SNIPS 12" Learn More
  9. SELF FEED DRILL BIT
    $33.49 /EA
    38339 2 9/16 SELF FEED DRILL BIT Learn More
View as Grid List

7898 items

Page
per page
Set Descending Direction