Lyman Butch's Bore Shine 4oz
|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 = '2937' AND (upper(f.web_text) = 'LYMAN' or upper(f.orig_text) = 'LYMAN' or upper(a.brand) = 'LYMAN') 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 Original - Benchrest clean for any firearm
Designed by well known bench rest competitor Butch Fisher, this non-abrasive chemical solvent is specifically designed to remove all forms of bore fouling including copper with an absolute minimum of effort and no damage. It will quickly remove carbon build-up, even in difficult to clean areas like the chamber throat. It also removes lead, wax and even plastic shotgun wad build up.
A significant improvement over conventional solvents, Butch's can also control the copper fouling by pushing a few patches soaked with Butch's prior to shooting. Butch's is safe to use on normal and stainless barrels. It is a true "All in One" Cleaner. Try it and you will never use anything else! Now available in three sizes.
No reviews have been written for this product.
Be the first one! – Write a Review
$10.99 to $17.99