Pro-Shot .22Cal 12' Pistol 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(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 = '1PS-12-22/U' 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|
(Cleaning Rod) 12" Pistol .22 Cal. & Up
12" Working Length- Not counting handle.
Packaged in a plastic tube and includes a brass patch holder.
1 Piece Stainless Steel Micro Polished Pro-Shot Cleaning Rods have a mirrorlike jeweled finish that is more dense and hardened due to an added new step in our rod manufacturing process. Our exclusive manufacturing process of burnishing/micro polishing besides centerless grind and polish our rods for an even denser mirrorlike jeweled finish.
The hardened dense jeweled mirror like finish of our rods does not pick up and carry abrasive grit or dirt through the bore. This makes the Pro-Shot micro polished rod the best type of gun cleaning rod to use.
*Micro polished precision stainless steel cleaning Pro-Shot rods are strong and are used by accuracy minded shooters worldwide.
*Rugged precision threading for no wobble attachment of rod tip accessories. No adaptor needed and our attachments do not get out of line with the rods, as when an adaptor 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. *One piece rods come in a clear plastic tube, reusable for safe rod storage.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review