GG&G 30MM to 1" Ring Reducer
|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 = 'GGG-1392' AND (upper(f.web_text) = 'GG AND G INC' or upper(f.orig_text) = 'GG AND G INC' or upper(a.brand) = 'GG AND G INC') 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|
Even though the trend has been towards rifle scopes with 30mm tubes, there are still many high quality rifle scopes with one inch tubes in the marketplace. We have recently been getting a significant number of calls for a non-marring, 30mm to 1 inch scope ring reducer to fit 5/8 inch wide sniper grade 30mm scope rings, like the ones offered by GG&G separately or as integral ring bases. To meet our customers requests, we decided to offer 1 inch reducers to our customers manufactured from solid Delrin. Nothing fancy, just a rugged, non-marring, quality machined 1 inch ring insert that not only fits tight to your 1 inch scope, but is priced competitively. As can be seen in the photos, the one inch insert has a recoil flange on one side that keeps the reducer in the correct position during installation and recoil. Each package includes 4 components; enough parts to to do two scope rings.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review