Kershaw Emerson CQC-7K
|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 = '6034T' 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|
WINNER OF THE 2014 BLADE SHOW'S BEST BUY AWARD
Kershaw Knives and Emerson Knives have joined forces on a series of knives that combine the precision engineering of Kershaw with Emerson's uncompromising functional design.
The CQC-7K features a modified tanto blade for both slicing and punching capability. The blade has two finishes: a satin finish on the grind and a stonewashed finish on the upper. The handle's front scale of textured G-10 offers a secure grip and the handle's stainless steel back has a solid frame lock.
The CQC-7K is a manual opener using either the thumb disk or the patented Emerson "wave shaped feature." This opening feature enables the knife to be opened as it is removed from the pocket. By the time the knife has been fully withdrawn from the pocket, the blade is deployed and ready for use. A small wave-shaped tab on the top of the blade is built to catch on the pocket seam, opening the knife as it comes out of the pocket. This instant-open feature is a favorite among military, rescue, and law enforcement knife users.
The pocketclip is reversible for left- or right-handed carry.
Designed by Emerson, built by Kershaw
Thumb disk; "waved shaped opening feature"
Steel: 8Cr13MoV, stonewashed & satin finish
Handle: textured G-10, 410 bead-blasted finish back
Blade length: 3.25 in. (8.3 cm)
Closed length: 4.5 in. (11.4 cm)
Weight: 5.1 oz. (144.6 g)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review