Worksharp Knife & Tool Sharpener MK.2
|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 = 'WSKTS2' 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 Knife and Tool Sharpener Mk.2 sharpens every knife and tool you own. The flexible belts, sharpening guides, and a two-speed motor makes sharpening faster, easier, and more versatile than before. Used by the pros, millions sold, never be dull again.
EASY TO USE REPEATABLE
The angle guide adjusts between 20° and 25° to create precise, repeatable bevels on any knife.
SHARPEN FAST, POWER GRIND
Switch between high and low sharpening speeds for more control or more power when you need it.
SHARPENS ANY KNIFE SHAPE
Flexible abrasive belts conform to any blade shape, meaning you can sharpen all your knives, scissors, axes, mower blades, garden shears, shovels and more.
No reviews have been written for this product.
Be the first one! – Write a Review