Worksharp Guided Field Sharpener
|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 = 'WSGFS221' AND (upper(f.web_text) = 'WORKSHARP ' or upper(f.orig_text) = 'WORKSHARP ' or upper(a.brand) = 'WORKSHARP ') 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 Work Sharp Guided Field Sharpener 2.2.1. is the complete knife sharpener for field, home or shop use. It is the first Angle Guided, 5 stage sharpening solution designed for sportsmen who need a complete, robust and compact field sharpening solution.
Legendary knife maker, Ken Onion said of the Guided Field Sharpener, “ I am impressed with the clever details like the magnetic plate holders, angle guides, round ceramics and strop, all in a small easy to carry package. It is by far the best manual, portable sharpener I have ever used…. I especially like the versatility of it. I have used it on flat and re-curve blades as well as fishing hooks and leather punches and it performed well. Something for everyone in this little package.”
(2) Diamond Plates, (2) Ceramic Rods, (1) Leather Strop and Sharpening Guides provide a fast, easy and consistent sharpening solution for knives and camp tools. The 20° and 25° sharpening guides create consistent blade edge angles with speed, ease and repeatability. The sharpening guides are purpose built for your hunting knives, pocket knives and filet knives. Strong rare earth magnets secure the easily interchangeable diamond plates and also provide coverage for the Broadhead Wrench and small storage compartment. Compact design and Lanyard Hole make it easy to pack carry on your next outdoor adventure so you can sharpen anytime, anywhere with speed and ease. Also sharpens serrated knives, fish hooks, broadheads and many common camp tools. Work Sharp Guided Field Sharpener 2.2.1.
Includes: (1) Coarse Diamond Plate, (1) Fine Diamond Plate, (1) Large Ceramic Rod with 3 Positions (coarse, fine and fish hook grooves), (1) Small Ceramic Rod, (1) Leather Strop conditioned with Micro-Abrasive, Broadhead Wrench and User's Guide. This tool is assembled and quality checked in Ashland, Oregon and has a Limited Lifetime Warranty. Includes a detailed User's Guide inside the tool under the diamond plate for convenient storage.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review