Turner's Outdoorsman Pro Grade Turks 7" Cutter
|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 = 'TUR-7NTK' AND (upper(f.web_text) = 'TURNER`S OUTDOORSMAN' or upper(f.orig_text) = 'TURNER`S OUTDOORSMAN' or upper(a.brand) = 'TURNER`S OUTDOORSMAN') 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|
Turks Head Tool Series: These "West Coast" style pliers are made from case hardened steel. We have added Chormium to the metal to make these tools stiffer as not to torque when removing hooks. Each cutting surface has a second tempering process added to ensure a longer lasting cutter. Each tool is then Nickel Plated to make it corrosion resistant for years of use in saltwater. The cable cord wrapped handles are a work of art This type of cord is wrapped tightly around the frame, then glued to the plier in stress locations. Then it is coated lightly with an epoxy that will preserve the color and soak into the cord to make a permanent, non slip grip. The best handles available anywhere. Light weight machine oil included.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$19.97 to $25.00
$29.97 to $40.00
$18.99 to $32.99
$29.99 to $64.99
$36.99 to $42.99
$249.99 to $250.00