Cold Steel Double Agent II
|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 = '39FNZ/39FN ' 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|
Cold Steel's new Double Agent® neck knives possess a significant set of advantages worth noting. Designed by Zach Whitson, with either a Karambit or Clip Point blade style, they're thin, flat, and super light (a little over 3 ounces including sheath). This makes them easy to conceal and very comfortable to wear. Their most audacious and notable feature, however, is their double ring handle design. Slip an index finger through the front ring nearest the blade and your pinky finger through the rear ring and close your fist to obtain a forward grip and vice versa for a reverse grip.
It doesn't matter how hard you cut, chop, hack, hammer or thrust with the Double Agent®. Its twin rings will always prevent your hand from sliding forward on the razor sharp edge and will likewise resist the effects of centrifugal force or the efforts of an adversary to wrest the Double Agent® from your grasp.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review