Cold Steel Kobun
|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,4) ) 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 = '17TZ/17T ' AND (upper(f.web_text) = 'COLD STEEL' or upper(f.orig_text) = 'COLD STEEL' or upper(a.brand) = 'COLD STEEL') 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|
The Kobun® is a lightweight Tanto styled boot knife. It takes its namesake from the Japanese martial, or underworld where the word "Kobun" means "soldier". It's a fitting name for a knife like the Kobun®, which was effectively designed to be "a good soldier". In profile it closely resembles our Master Tanto, but it sports a thinner blade, and that supports its main function; to be a light weight boot knife.
Like our Tantos, it features the Tanto styled reinforced point. This contrasts sharply with most boot knives on the market today which are notorious for their paper thin points which are easily broken or bent. In contrast, the Kobun's® point is highly resistant to bending or breaking because it is reinforced by the full thickness of the blade's spine which runs almost to the very tip of the blade.
The Kobun's® deeply checkered Kray-Ex™ handle is designed to offer minimum bulk with maximum grip. Its cross section was made as thin as possible (approximately 1/2 inch), then contoured to resist turning or shifting in the hand. The Kobun® comes complete with a Secure- Ex® sheath.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review