|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '1557TI' AND (upper(f.web_text) = 'KERSHAW' or upper(f.orig_text) = 'KERSHAW' or upper(a.brand) = 'KERSHAW') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
This strongly liner design is barracuda sleek and engineered to provide great tip control. The deep contour toward the back of the blade spine provides a place to rest your finger when choking up on the blade for detailed work. The clipped spear-point style blade looks great, slims the blade for excellent piercing capability, and enhances control.
The steel handle is purposely smoothed for an easy pocket carry, but it also features a double finger contour for excellent grip. The Ferrite is SpeedSafe equipped for fast and easy, one-handed opening. Just pull back on the flipper or push outward on the thumb stud. Once the blade is started out of the handle, SpeedSafe takes over and opens the knife with ease.
Grey titanium carbo-nitride coating on both blade and steel handle help give the knife a long, lean look. A frame lock secures the blade during use. The pocketclip can be reversed for either left-handed or right-handed carry. Like many of Rick’s custom knives, the Ferrite features a “filler tab” that gives the handle an extra touch of class and adds a finished look to the side of the handle opposite the pocketclip.
- SpeedSafe assisted opening
- Flipper and thumbstud
- Frame lock, lockbar stabilizer
- Reversible pocketclip (right/left, tip-up)
- Steel: 8Cr13MoV, titanium carbo-nitride coating
- Handle: Steel, titanium carbo-nitride coating
- Blade length: 3.3 in. (8.4 cm)
- Closed length: 4.25 in. (10.8 cm)
- Open length: 7.5 in. (19.1 cm)
- Weight: 4.2 oz. (119.1 g)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review