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

SNIPS TINNERS AND DUCKBILL


View as Grid List

23 items

Page
per page
Set Descending Direction
  1. TIN SNIPS
    $8.75 /EA
    T10SC 10" TIN SNIPS Learn More
  2. STRAIGHT TINNER SNIP
    $19.49 /EA
    MWT-87S STRT TINNER SNIP Learn More
  3. STRAIGHT TINNER SNIP
    $28.75 /EA
    MWT-127S STRT TINNER SNIP Learn More
  4. PROSNIP FLAT BLADE TINNER SNIPS
    $15.35 /EA
    22007 007 7" MULTI PURP TINNER SNIP Learn More
  5. PROSNIP FLAT BLADE TINNER SNIPS
    $18.75 /EA
    22010 010 MULTI PUR TINNER SNIP 10" Learn More
  6. PROSNIP FLAT BLADE TINNER SNIPS
    $23.05 /EA
    22012 012 TINR SNIP STR 12-3/4" Learn More
  7. PROSNIP DUCKBILL TINNER SNIPS
    $16.05 /EA
    23007 207 7" DUCKBILL CIRC CUT SNIP Learn More
  8. PROSNIP DUCKBILL TINNER SNIPS
    $19.59 /EA
    23010 210 10" DUKBILL CIRC CUT SNIP Learn More
  9. PROSNIP DUCKBILL TINNER SNIPS
    $23.69 /EA
    23012 212 12-3/4 DUCK BILL CUT SNIP Learn More
View as Grid List

23 items

Page
per page
Set Descending Direction