Magpul PMAG G19 9MM 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 = 'MAG907-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® PMAG 10 GL9 - Glock G17 and G19 9x19 Parabellum are the highest performing and most reliable restricted capacity magazines on the market. They are designed to provide the same quality and performance of the proven Magpul PMAG series of Glock magazines while also providing a viable product solution to those in locations and situations where a 10-round capacity restriction is required or desired. Whether for competition use or otherwise, the PMAG 10 GL9 is the highest quality restricted capacity magazine option available.
Made in U.S.A.
MAG907 compatible with all compact and sub-compact 9mm Glock handguns
Utilizes the same double stack feed geometry as the standard capacity PMAG GL9 to ensure feeding and to avoid known reliability issues seen in many competitor products on the market
Compatible with Magpul GL-L Plates for competition use
Meets regulatory requirements in capacity restricted locations
Easy disassembly and reassembly for routine maintenance
Durable, lightweight and extremely stiff polymer construction
High visibility controlled-tilt follower
Long life stainless steel spring for corrosion resistance
Dot matrix panel for magazine marking and identification
Drops free when loaded or empty
*Note: May not be compatible with other platforms designed for use with Glock magazines due to a wide range of magwell designs and tolerances.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review