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', '2983', '2984', '2993')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') TAPS AND DIES WIRE SIZE - TAPS AND DIES - BOLT THREADING HDW. - HAND & POWER TOOLS
  1. See Detail

TAPS AND DIES WIRE SIZE


View as Grid List

20 items

Page
per page
Set Descending Direction
  1. HIGH CARBON STEEL MACHINE SCREW HEXAGON DIES
    $3.79 /EA
    9328 HANSON 10-24NC HEXDIE Learn More
  2. HEX DIE
    $3.49 /EA
    96106 NC HEX DIE 12-24 CD Learn More
  3. HIGH CARBON STEEL MACHINE SCREW TAPS
    $3.29 /EA
    8035 14-20NS TAP HANSON Learn More
  4. PLUG TAP
    $2.79 /EA
    95006 NC PLUG TAP 10-24 CD Learn More
  5. HEX DIE
    $3.49 /EA
    96104 NC HEX DIE 10-24 CD Learn More
  6. HIGH CARBON STEEL MACHINE SCREW TAPS
    $2.89 /EA
    8024 HANSON 8-32NC TAP Learn More
  7. PLUG TAP
    $2.59 /EA
    95002 NC PLUG TAP 4-40 CD Learn More
  8. HEX DIE
    $3.49 /EA
    96101 NC HEX DIE 4-40 CD Learn More
  9. HEX DIE
    $3.49 /EA
    96103 NC HEX DIE 8-32 CD Learn More
View as Grid List

20 items

Page
per page
Set Descending Direction