Magpul BEV Block AR15
|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 = 'MAG536' 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 BEV Block (Barrel Extension Vise) is an all-in-one, compact vise block tool for AR15/M4 assembly operations of barrel nuts, flash hiders, etc.
Mounts securely in a vise and provides support for both billet and forged upper receivers. Engages barrel extension with solid steel lugs and full length support shank to prevent flexing. Steel hardness is optimized for durability yet won't damage barrel extension, and Magpul Polymer is used for all other engagement surfaces to protect aluminum receiver. O-ring post uses bolt carrier for additional stability and included Pin keeps upper in proper position.
The BEV can also be turned over and used as a mag well vise block to support the lower receiver during maintenance, etc.
Made in U.S.A.
Provides support for all AR15/M4 upper and lower receivers
Solidly engages barrel extension with steel lugs
Full-length steel support shank
Body made from the same high-quality polymer as other Magpul products
BEV™ Block – AR15/M4
Weight: 11.2 oz.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review