MonsterMan AR15 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 = 'MMG-AR' AND (upper(f.web_text) = 'MONSTERMAN GRIPS' or upper(f.orig_text) = 'MONSTERMAN GRIPS' or upper(a.brand) = 'MONSTERMAN GRIPS') 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 MMG-AR "Featureless Grip" has been selling in California for over 10 years! It is the go to grip for turning your AR-15 rifle into a "Featureless" California Legal AR. With CA DOJ testimony that the MMG is not a "Pistol Grip" in the eyes of the law, people feel comfortable using the MMG-AR to keep their rifles legal.
The made in the U.S.A. MMG was created by a Californian who wanted an AR style rifle that did not have a "Mag Lock" on it, keeping the rifles ability to have a detachable magazine.
The MMG-AR is a patented grip designed to replace the pistol grip on a off list AR-15 type rifle allowing users to keep their magazines detachable in California. Users must also remove all other banned features on semi-auto rifles with detachable magazines. Made from glass fiber filled nylon, the grip is very strong to meet the most demanding needs.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review