Magpul MS3 Sling Gen2
|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,4) ) 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 = 'MAG514-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|
Driven by the operational experience of Magpul DynamicsSM instructors, the MS3 Multi-Mission Sling System was designed to give a versatile weapon-retention solution for a multitude of tactical environments and missions. As a standalone product, the rapidly-convertible MS3 allows an operator to leverage the maneuverability of one-point attachment for direct action, or two-point attachment for stability. Single-hand adjustments and quick-release, positive-locking hardware provide flexibility and durability in a truly adaptable sling system.
Used in conjunction with the Magpul ASAP® plate (sold separately), the MS3 enables seamless transitions into an array of shooting positions without getting bound or fouled. The MS3 concept allows switching from Weapon Shoulder to Reaction Shoulder for shooting around corners, under vehicles, or to minimize exposure. The MS3 can also increase operator survivability by keeping the weapon in the fight in case of injury to the operator's shoulder, arm, or hand.
The MS3 GEN 2 incorporates a new low profile quick-adjust Slider which minimizes bulk and allows for secure, yet effortless, sling adjustment. Webbing length has also been increased for a comfortable fit with all body types and armor configurations. New colors are available in Ranger Green and Gray along with the original Black and Coyote.
Made in U.S.A. and 100% Berry Amendment compliant
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review