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` = 114) WHERE (`e`.`entity_id` IN('2465', '2597', '2612')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') PLIERS & LOCKING PLIERS - PLIERS, CUTTERS, AND NIPPERS - HAND & POWER TOOLS
  1. See Detail

PLIERS & LOCKING PLIERS


View as Grid List

227 items

Page
per page
Set Descending Direction
  1. COVER SNAP RING PLIER
    $10.99 /EA
    2078900 6-1/2" SNAP RING PLIER Learn More
  2. 8" GROOVE JOINT PLIERS
    $5.89 /EA
    21022 8" GROOVE JOINT PLIER Learn More
  3. FAST RELEASE VICE GRIP
    $16.49 /EA
    11T 10CR FAST REL VISEGRIP Learn More
  4. LAP JOINT DIAGONAL PLIER
    $23.49 /EA
    338 LAP JOINT DIAGONAL PLIE Learn More
  5. GROOVE JOINT PLIERS
    $15.99 /EA
    2078512 12" PLIER GRV JNT V JAW Learn More
  6. LOCKING WRENCH
    $19.99 /EA
    2 10LW LOCK WRENCH Learn More
  7. GROOVE JOINT PLIERS
    $8.99 /EA
    2078506 6" PLIER GRV JNT V Learn More
  8. GROOVE JOINT PLIERS
    $13.99 /EA
    84-647 FMX 8" GRV JT PLIER Learn More
  9. GROOVE JOINT PLIERS
    $17.99 /EA
    84-649 FMX GRV JT PLIERS Learn More
View as Grid List

227 items

Page
per page
Set Descending Direction