Pro-Shot 6.5MM Rifle Brush
|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 = '6.5R' AND (upper(f.web_text) = 'PRO SHOT' or upper(f.orig_text) = 'PRO SHOT' or upper(a.brand) = 'PRO SHOT') 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|
Pro-Shot manufactures superior bore brushes for shooters to withstand frequent use. Construction consists of a high-quality brass core and coupling with extra thick bronze bristles.
Over the year these brushes have been used to set world records across the world. With exceptional bore cleaning ability, they are also a safe for your bore. All Pro-Shot Benchrest Bore Cleaning Brushes are specifically sized for each caliber/mm, with each brush being over-sized for extended life and maximum cleaning power!
- Pro-Shot Bore Brush - Precision Engineered Design, Fit, & Function
- Superior Stiff Bristles with extra thick fill
- Precision Rifle #8-32 Threads
- Made in USA
- Brush Thread Information: All Pro-Shot Brushes are Mfg. with American Standard Threading
- .17 and .20 Cal. - #5-40 thread
- Rifle and Pistol - #8-32 thread
- Shotgun - #5/16-27 thread
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review