Magpul MOE AK Hand Guard AK47/AK74
|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 = 'MAG619-BLK' AND (upper(f.web_text) = 'MAGPUL' or upper(f.orig_text) = 'MAGPUL' or upper(a.brand) = 'MAGPUL') 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 Magpul MOE AK Hand Guard is a replacement for standard AK pattern rifles without a front sling loop on the hand guard retainer. Featuring an extended gripping portion, integrated heat shield, M-LOK mounting capability, and replacement gas tube cover, the MOE AK Hand Guard is an upgrade to any AK pattern rifle.
Made in U.S.A.
Optimized design replaces original stamped receiver AK-47/AKM/AK-74 wooden or plastic hand guards
Easy to install utilizing existing front hand guard retaining cap WITHOUT sling loop*
Slots at the three, six, and nine o'clock positions for mounting direct-attach M-LOK accessories or M-LOK 1913 Picatinny rail sections
Reinforced, heat-resistant polymer construction
Integral, black oxide coated stainless steel heat shield
Front lip and long side extensions shields hand from hot barrel while providing increased gripping surface
Includes replacement polymer Top Cover
Compatible with UltiMAK Optics Mount top cover
Accepts factory cleaning rod
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review