Magpul RLS Sling
|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 = 'mag1004-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|
Building on the heritage and proven performance of Magpul™s MS Sling series, the Magpul RLS (Rifleman Loop Sling) is a durable, lightweight, and affordable shooting aid and retention device. Combining the best features of Rhodesian and 1907 match-style slings, the RLS was created with Magpul™s famous proprietary nylon mesh webbing and high-strength polymer hardware.
In a retention role, the RLS serves dutifully as an unobtrusive weapon sling and retention device, securely keeping the rifle tucked behind the shoulder. When called upon, the RLS is rapidly employed with the adjustable forward loop gripping the riflemans support arm, locking in a steady shooting position and firmly planting the rifle butt against the shoulder.
The Magpul RLS was designed with mobility in mind. At a mere 4.4 oz, the optimized weight of the RLS doesnt add unnecessary ounces to the rifle and weighs less than many competing slings and straps. Like all Magpul slings, the RLS has been extensively tested to its limit to ensure reliability and performance in wet, dry, and sandy conditions, to include load and drop testing. Its been hiked with, biked with, swam, climbed, hunted and shot (a lot) with in a variety of field conditions.
The American-made Magpul RLS combines legendary Magpul innovation, quality, and design into a simple and effective shooting aid for less money than many slings that merely carry a rifle. Available in BLK or COY.
Made in the USA.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$5.97 to $8.99