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', '2597', '2612', '2620')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') PLIERS FENCE TOOL - PLIERS & LOCKING PLIERS - PLIERS, CUTTERS, AND NIPPERS - HAND & POWER TOOLS
  1. See Detail

PLIERS FENCE TOOL


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. FENCE TOOL COMBO
    $26.99 /EA
    ATFC-FS/KT10 FENCE TOOL COMBO Learn More
  2. FENCE PLIERS
    $13.99 /EA
    FE10 10" FENCE PLIER Learn More
  3. IMPORTED FENCE PLIER
    $26.49 /EA
    41026/2T-1900 IMPORTED FENCE PLIER Learn More
  4. COMPOUND FENCE PLIER WITH POUCH
    $35.49 /EA
    FECB COMPOUND FENCE PLIER W/POUCH Learn More
  5. CRESCENT FENCE TOOL
    $45.49 /EA
    100010VN BTN FENCE TOOL 10-1/4" Learn More
  6. FENCING PLIERS
    $23.99 /EA
    2078901 FENCING PLIERS Learn More
  7. FENCE TOOL
    $43.99 /EA
    85 10 1/2" FENCE TOOL Learn More
  8. DIAMOND FENCE TOOL
    $27.49 /EA
    193410CVN FENCING TOOL Learn More
  9. CRESCENT HEAVY DUTY FENCE TOOL
    $36.99 /EA
    193610CVSMN CRESCENT FENCE TOOL Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction