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` = 90) 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 Call for Price
    66824 3/8 I.P. MAG NUTSET STD Learn More
  2. MAG IR NUT DRIVER Call for Price
    DW2221IR 1/4X2-9/16 MAG IR NUT DRV Learn More
  3. IMPACT NUTSETTERS Call for Price
    1837533 IMPT NUTSET 1/4X1-7/8 Learn More
  4. MAG IR NUT DRIVER Call for Price
    DW2222IR MAG IMP RDY NUTDRIVER15/16 Learn More
  5. MAG IR NUT DRIVER Call for Price
    DW2223IR 3/8X2-9/16 MAG IMP DRIVER Learn More
  6. SHOCKWAVE NUT DRIVER Call for Price
    49-66-4533 SHKWAVE 5/16 NUTDRVR Learn More
  7. IMPACT NUTSETTERS Call for Price
    1837542 IMPT NUTSET 7/16X1-7/8 Learn More
  8. MAG IR NUT DRIVER Call for Price
    DW2219IR 5/16X1-7/8 IR MAG NUT DRV Learn More
  9. MAG IR NUT DRIVER Call for Price
    DW2218IR 1/4X1-7/8 MAG IR NUT DRV Learn More
View as Grid List

19 items

Page
per page
Set Descending Direction