Odin Works Extended Magazine Release XMR
|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 = 'ACC-XMR-BLK' AND (upper(f.web_text) = 'ODIN WORKS' or upper(f.orig_text) = 'ODIN WORKS' or upper(a.brand) = 'ODIN WORKS') 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|
A flagship product for ODIN Works, the XMR (eXtended Magazine Release) is one accessory every AR needs. Machined from billet 6061 aluminum and designed to work with KNS pins. The XMR is 4x larger than a mil spec button making it easily accessible by all shapes and sizes of hands and fingers. Works with both AR15 and AR10 lower receivers. Easy install that takes minutes
Compatible with KNS Pins. Not recommended for use with BAD lever.
Four times larger than factory magazine buttons.
Large surface area for quick magazine reloads.
Easy to reach.
Release magazine without changing grip or position.
Contoured for positive depression and reduced slip.
Weight: 0.15oz (including button, paddle, and screws).
All parts included.
Easy drop in installation.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review