Wheeler AR Armorer's Vise
|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 = '156224' AND (upper(f.web_text) = 'WHEELER' or upper(f.orig_text) = 'WHEELER' or upper(a.brand) = 'WHEELER') 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 AR-15 platform has become the mainstay of today's Modern Sporting Rifle market. The popularity and modularity of this platform has created the need for specific tools that allow users to build, maintain and reconfigure AR's. The Delta Series Armorer's Vise provides users an ideal foundation for all AR tasks. The integrated mag well insert securely engages the lower receiver and adjusts in angle accommodate any task. The innovative front support is angle adjustable, allowing the barrel portion of the upper or a fore end portion to be secured in its tapered profile. Both front and rear supports have multiple positions in the base and are reversible for maximum customization. The base is constructed of rigid steel with non-slip rubber feet. Feet can be removed for permanent bench-top mounting as well. Depressions formed into the base keep spare parts or tools contained. Additional features in the mag well insert include a hammer stop and a bolt service station that secures the bolt face for disassembly/assembly. The vice works great for assembled guns in closed of break open state but also is ideal for holding a lower receiver only, for assemble and maintenance. Whether you are building an AR from the ground up or just looking for the ideal cleaning vise the AR Armorer's Vise is simply the best choice available. Patent Pending.
Highly adjustable to secure any AR in any configuration
Rigid construction delivers a solid work platform
Ideal for cleaning, maintenance and gunsmithing
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$2.89 to $3.99