Magpul PMAG 7.62 Nato 10 Round
|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 = 'MAG290' 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 7.62x51 NATO (.308 Winchester) PMAG 10 LR/SR GEN M3 brings GEN M3 technology to the smallest possible magazine size. Ideal for hunting applications, depending on local hunting laws, and also for states where overall capacity is limited. Perfect for use with a bipod or when shooting off of a pack.
Optimized for use with SAAMI-spec 7.62x51/.308 Winchester ammunition
Commercial rifle compatibility includes the new Armalite AR-10A, Bushmaster .308 ORC, Colt LE901-16S, CORE Rifle Systems CORE30, DPMS LR308, JP Enterprises LRP-07, KAC SR25, LaRue OBR, Les Baer .308, LMT .308 MWS, LWRCI REPR, Mega Arms MATEN, POF P-308, Remington R-25, Ruger SR-762, S&W M&P10, SIG716, and others
NOTE: NOT compatible with Armalite AR-10B, Noveske N6, Springfield Armory M1A, Rock River Arms LAR8, FN SCAR 17S, PTR-91, HK417 or any other rifles that utilize M14, FN FAL, or HK 91/G3 patterned magazines
True 10-round capacity that does not require limiters, pins, rivets, etc.
Next-generation impact and crush resistant polymer construction
Constant-curve internal geometry for smooth feeding
Anti-tilt, self-lubricating follower for increased reliability
High-quality stainless steel spring for corrosion resistance
Flared floorplate aids magazine handling and disassembly yet is slim enough for use with many pouches
Multi-use Impact/Dust Cover minimizes debris intrusion and protects cartridges from potential damage during storage and transit
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review