Pro-Shot 26" Short Rifle .26-.26 Cal Micro-Polished Cleaning Rod
|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(?,?,?) ) 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 = ? AND (upper(f.web_text) = ? or upper(f.orig_text) = ? or upper(a.brand) = ?) 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's Exclusive and Proprietary manufacturing process of micro polishing/burnishing cleaning rods along with center-less grinding and polishing, provide for a super smooth and mirror-like jeweled finish. These extras manufacturing steps provide a hardened dense jeweled mirror like finish, so they do not pick up and carry abrasive grit, dirt, & fouling.
Micro polished precision stainless steel cleaning Pro-Shot rods are strong and are used by accuracy minded and world record competition shooters worldwide.
Rugged precision threading for no wobble attachment of rod tip accessories. No adapter needed and our attachments do not get out of line with the rods, as when an adapter is used.
Proprietary Rod handle design (Pat. Pending) allows the rod to rotate in the handle, allowing the bore brush to spiral with the rifling and clean the grooves of the rifling completely.
- Micro-Polished finish / Centerless Ground & Polished Rod
- Proprietary Swivel Handle Rod Design (Pat. Pending)
- Brass Patch Holder
- Precision Threading
- Reusable Tube for safe storage
- Made in USA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review