GG&G Quick Detach Heavy Duty Swivel
|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 = 'GGG-1271HD' 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|
With the QD Sling Thing For Dovetails, you can quickly unsling your AR-15, M-16, or M4 rifle by using a dovetail sling mount with quick detach capabilities. As the use of tactical forearms such as the full line of GG&G Tactical Forearms have become more prevalent by special operations personnel and law enforcement SWAT teams, the need to easily mount a sling to the dovetail rails of the tactical forearm has become necessary. It was for this reason that GG&G developed a Sling Thing specifically for dovetail applications.
The side mount sling swivel provides the flexibility to mount the front sling attachment anywhere on the rails of the tactical forearm that meet your mission requirement. This dovetail mounting capability means you can choose between a side mount sling swivel or top mounted swivel to maximize your tactical sling. As with all of our "Sling Things", this side sling mount provides a lightweight, durable, easy-to-install and inexpensive method for front sling attachment. As an added feature, it includes the limited swsivel rotation feature that helps to keep your sling from twisting. The sling mount is manufactured from tough 7075 billet aluminum alloy and is Type III black hard-coat anodized matte black per mil-spec.
The Sling Thing For Dovetails includes the Heavy Duty Enhanced 1 1/4" QD Sling Swivel. The HD QD Enhanced Sling Swivel has a larger quick detach button than a standard sling swivel for an easier and quicker transition. The button has concentric tactile grooves machined into the surface for more preceise finger or thumb placement. The wire diameter is thicker to provide a more robust sling attachment surface. The HD QD sling swivel is bead blasted and manganeese phosphated in a non-reflective matte black mil-spec finish. When coupled with the GG&G QD Rear Sling Thing, the sling can be quickly removed from the weapon.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$5.97 to $8.99