Pro-Shot .270-.38 Cal 2" Round Patches 500 Count
|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 = '2-500' 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|
American grown Cotton & American Design come together to form the best cleaning patch in the world! Experience the advantage with Pro-Shot's Superior Weave Technology (SWT), Pro-Shot's High thread count with tightly woven material along with Pro-Shot's double napped finish on both sides. Pro-Shot's (SWT) Superior Weave Technology creates a cleaning patches that have become known worldwide for their unparalleled cleaning ability. Dozens of world records have been shattered with shooters using Pro-Shot's cleaning patches! Pro-Shot Cleaning Patches are the foremost in cleaning technology and quality, often imitated, never duplicated!!
The fact is well-known that nothing surpasses 100% COTTON FLANNEL FABRIC for purposes of absorbing foreign matter and residue, and in turn carry it through the BORE with the LEAST amount of abrasive contact to the barrel’s rifling. Pro-Shot's cleaning patches provide Maximum Cleaning Power and Barrel Protection! Clean Faster, Easier, and Protect your barrel with Pro-Shot 100% Cotton Flannel (finished both sides) Cleaning Patches!
- American Grown finest quality cotton, milled in America to Pro-Shot Specifications
- Consistent thickness, shape, and white in color
- Designed to handle all solvent types, even harsh chemicals
- SWT- Superior Weave Technology- Exclusive thread count with a weave designed to catch/trap more fouling
- Finished on both sides for extreme absorbency
- Packaged in reusable zipper top bags
- Made in USA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$2.49 to $2.89
$10.99 to $17.99