Cold Steel Outdoorsman Lite
|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(?,?,?) ) 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 = ? AND (upper(f.web_text) = ? or upper(f.orig_text) = ? or upper(a.brand) = ?) 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|
As a nod to the great success of our Pendleton Lite Hunter, we have decided to make more economical versions of our popular Tanto and Outdoorsman knives. They resemble their more expensive versions in that they feature similar blades, guards, handles, and pommels. The only significant change was the use of slightly thinner German 4116 Stainless Steel blades, and the implementation of less costly materials in the handles.
The handles are made in two parts. They feature a Polypropylene guard, pommel, and core section, which totally envelopes the knives' full tangs. The core is then over-molded in a deeply checkered Kray-Ex™ for a non-slip grip that's impervious to the elements and is easily cleaned with soap and water.
To carry your knives safely and conveniently in the field, we are including a pouch-style Cor-Ex sheath complete with belt loop so it can be easily worn on the belt or tucked into your pack or tackle box.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review