GG&G Short Vertical Grip
|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-1543' 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|
A vertical grip for the AR-15 and M-16 has become a valued tactical accessory in military, law enforcement and civilian arenas. It provides the operator with several important advantages, from diminishing muzzle climb during burst-fire sequences to simply offering a more comfortable shooting stance. The Short Vertical Grip like the GG&G SFG-1 has become a very popular alternative to our popular Standard Length Vertical Grip.
Low profile ergonomic design without sacrificing functionality.
Perfect for keeping CQB style weapons as compact as possible.
Designed for use with mil-spec-1913 rails.
Ideal for M4 carbines and breeching shotguns.
Excellent for use as a " reference point " or for the " thumb-break " style of shooting.
Provides for a comfortable, secure grasp for outstanding recoil control and ultra fast pointability.
No tools required for installation or adjustment in the field.
Manufactured from solid black Acetal cold polymer for durability and low heat absorption.
Alignment window to aid in installation.
Lightweight at only 2.8oz.
3 3/16 inches long.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review