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

PLIERS, CUTTERS, AND NIPPERS


View as Grid List

334 items

Page
per page
Set Descending Direction
  1. PRO SERIES LINESMAN COMPOUND ACTION PLIERS
    $26.99 /EA
    PS20509C PRO LINESMAN PLIER Learn More
  2. LINEMAN CRIMPERS PROPLIERS
    $27.49 /EA
    20509CVSMLN 9-1/4" LINESMAN PLIERS Learn More
  3. GRIPLOCK PLIER
    $19.99 /EA
    GL12 12" GRIPLOCK PLIER Learn More
  4. 4PC SNAP RING PLIERS
    $10.99 /EA
    25012 4PC SNAP RING PLIERS Learn More
  5. FENCING PLIERS
    $19.49 /EA
    2078901 FENCING PLIERS Learn More
  6. 2 PC PLIER SET-SLIP JOINT-GROOVE JOINT
    $18.49 /EA
    2078701 2PC PLIERS 6" SLIP 10G Learn More
  7. GROOVE JOINT PLIERS
    $13.99 /EA
    2078500 10 SMOOTH JAW SLIP PLIERS Learn More
  8. IRON WORKERS PLIER
    $18.99 /EA
    2078909 9" IRON WORKERS PLIER Learn More
  9. PRO PLIERS DIAGONAL CUTTING PLIERS
    $13.99 /EA
    2078306 6" DIA CUT PLIER Learn More
View as Grid List

334 items

Page
per page
Set Descending Direction