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', '2627', '2679', '2683')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') NUT DRIVER SETTER FOR DRILLS IMPACT RATED - NUT DRIVERS - WRENCHES - HAND & POWER TOOLS
  1. See Detail

NUT DRIVER SETTER FOR DRILLS IMPACT RATED


View as Grid List

19 items

Page
per page
Set Descending Direction
  1. IMPACT PRO MAGNETIC NUTTSETTERS
    $4.49 /EA
    66824 3/8 I.P. MAG NUTSET STD Learn More
  2. MAG IR NUT DRIVER
    $3.69 /EA
    DW2221IR 1/4X2-9/16 MAG IR NUT DRV Learn More
  3. IMPACT NUTSETTERS
    $3.89 /EA
    1837533 IMPT NUTSET 1/4X1-7/8 Learn More
  4. MAG IR NUT DRIVER
    $3.99 /EA
    DW2222IR MAG IMP RDY NUTDRIVER15/16 Learn More
  5. MAG IR NUT DRIVER
    $3.99 /EA
    DW2223IR 3/8X2-9/16 MAG IMP DRIVER Learn More
  6. SHOCKWAVE NUT DRIVER
    $3.99 /EA
    49-66-4533 SHKWAVE 5/16 NUTDRVR Learn More
  7. IMPACT NUTSETTERS
    $4.59 /EA
    1837542 IMPT NUTSET 7/16X1-7/8 Learn More
  8. MAG IR NUT DRIVER
    $3.79 /EA
    DW2219IR 5/16X1-7/8 IR MAG NUT DRV Learn More
  9. MAG IR NUT DRIVER
    $3.49 /EA
    DW2218IR 1/4X1-7/8 MAG IR NUT DRV Learn More
View as Grid List

19 items

Page
per page
Set Descending Direction