Magpul MBUS Pro Front Sight
|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,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 = 'MAG275' 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 MBUS Pro (Magpul® Back-Up Sight) is a corrosion resistant all-steel back-up sighting solution that delivers maximum functionality and strength with minimum bulk at a price that's even smaller than its size. The dual aperture, windage adjustable Rear and no-tool, elevation adjustable Front excel in all 1913 Picatinny rail mounting applications, including rail-height gas blocks. Positive detents keep the MBUS PRO Front and Rear at standard AR sight height when deployed, and so low when they are stowed that you'll never notice them until they're needed. Narrow width Front is compatible with most IR aiming laser and light installations for the professional user. Made in U.S.A.
All steel construction
Case hardened and finished with Melonite QPQ™ for extreme resistance to wear and corrosion
Mounts on any MIL-STD-1913 Picatinny/STANAG 4694 rail including receiver-height gas blocks
Elevation adjustment knob – no tools required
Positive detents in both the up and down positions as well as on the elevation knob
Standard AR sight height when deployed
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review