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

SNIPS AVIATION LEFT CUT


View as Grid List

9 Items

per page
Set Descending Direction
  1. 9 3/4'' METALMASTER COMPOUND ACTION SNIPS
    $18.99 /EA
    M1R WISS TINNERS SNIP,LEFT CUT Learn More
  2. LEFT AVIATION SNIP
    $20.49 /EA
    MWT-6716L LEFT REG AVIAT/SNIP Learn More
  3. PROSNIP 9 1/2" OFFSET SNIPS
    $21.99 /EA
    2073211 20SL IRWIN OFFSET SNIP LEFT Learn More
  4. PROSNIP 10" AVIATION SNIPS COMPOUND LEVERAGE
    $18.99 /EA
    2073111/2073101 LEFT CUT AVIAT SNIP Learn More
  5. WISS OFFSET SNIPS
    $26.49 /EA
    M6R OFFSET SNIP-LEFT Learn More
  6. AVIATION SNIP EDGE
    $20.99 /EA
    M1X AVAITION SNIP EDGE LEFT Learn More
  7. AVIATION SNIPS
    $9.99 /EA
    72701 LEFT CUT AVIATION SNP Learn More
  8. FATMAX AVIATION SNIPS
    $20.99 /EA
    FMHT73755/14-562 FATMAX L AVIATION Learn More
  9. AVIATION TIN SNIPS
    $11.49 /EA
    TA10L AVIATION TIN SNIPS LIFT CUT Learn More
View as Grid List

9 Items

per page
Set Descending Direction