GG&G 45 Degree Offset Rail
|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-1526' 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|
Allows for small micro red-dot optics, including the Trijicon RMR if equipped with the rail adapter, to be mounted at a 45 degree offset for close range engagements.
Ambidextrous by design for right and left hand shooters.
The Offset Accessory Rail can also be installed on tactical forearms to mount flashlights and lasers.
Mounts to a MIL-STD 1913 dovetail rail.
It is manufactured with 5 cross-slot mounting locations to accommodate most micro red-dot optics.
Manufactured to MIL-STD-1913 specifications and will accept accessories with a Weaver or MIL-STD 1913 interface.
The 45 Degree Offset Accessory Rail is manufactured with an enclosed recessed sidebar with a full one inch of dovetail engagement for secure mounting.
Counter sunk locking cross bolt helps eliminate the possibility of snags.
The geometry of this low profile offset mount allows for Zero Cheek-weld shift while transitioning between primary and secondary offset optics.
The 45 Degree Offset Accessory Rail is 2.5 inches long but only uses one inch of top rail for mounting.
Lightweight at only 1.45 oz.
Manufactured from billet 6061 T-6 aluminum.Type III hard coat anodized in a non-reflective combat finish to meet mil-spec.
Fully deburred for the shooters safety.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review