Otis 3 Gun Ripcord Trio
|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 = 'FG-RC-3G1' AND (upper(f.web_text) = 'OTIS' or upper(f.orig_text) = 'OTIS' or upper(a.brand) = 'OTIS') 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|
The 3 Gun Ripcord® Trio is an essential one-pass bore cleaner for 3 Gun Competitive Shooters. Shoot fast in competition, clean fast between stages with the Ripcord®. This set includes three Ripcords for cleaning .223 cal rifles, 9mm pistols and 12 gauge shotguns as well as a t-handle. The rubber core of the Ripcord® maintains pressure against the barrel allowing for a 360 degree clean. Formed around an Otis Memory-Flex® cable, the Ripcord features an easy-feed design. The rigid Nomex® fibers loosen and capture fouling particles. It also is heat resistant up to 700 degrees meaning you can clean between stages while the barrel is still hot. Ultra-portable, pack them in your range bag for the insurance you need to keep your guns running clean during competition.
- Essential one-pass bore cleaner for 3 Gun competitive shooters
- Includes 3 Ripcord® one-pass bore cleaners to quickly and easily clean .223 cal rifles, 9mm pistols and 12 ga shotguns
- Also includes T-Handle to make pulling the Ripcord® even easier
- Designed for cleaning between stages, in the field, or at the range
- Rubber core of the Ripcord® maintains pressure against the barrel allowing for a 360 degree clean
- Features an easy-feed design for a true, quick clean
- Rigid Nomex® fibers loosen and capture fouling particles
- Clean between stages while the barrel is still hot due to 700 degree heat resistance
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review