Pro-Shot Brass 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 = '17R' 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 Benchrest Bore Brush
Brass Core and Bronze Bristles (Benchrest Type) Designed for competition shooters to withstand frequent use. Construction consists of a high quality brass core and coupling with bronze bristles. Pro-Shot’s Benchrest Quality Brush has been used for many years with several world records to its credit. This bore brush is exceptional for bore cleaning with superior cleaning ability and it will not harm the bore. All Pro-Shot Benchrest Bore Cleaning Brushes have a specific size for each caliber with each brush being oversized for extended life. American Standard #8-32 thread.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review