Wheeler AR Armorer's Professional Kit
|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 = '156555' 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 Wheeler Delta Series AR Armorer's Professional Kit contains all of the tools a gunsmith or armorer needs to complete a full rifle build, make repairs or perform maintenance on AR-15/M16 platform rifles. Each of these Delta Series tools is designed with application specific features to perform specific functions with precision and ease. Each tool is constructed of the highest quality materials to deliver the best performance at a great value. This all-inclusive 19 piece Armorer's Kit has some of the most innovative AR-15 tools on the market today, making it the most advanced kit out there. All of the tools fit inside the durable carry case for convenient storage and transport.
Professional Kit includes: AR Armorers Vise AR15 Combo Tool Torque Wrench Upper Vise Block Clamp w/ Gas Tube Alignment Tool Maintenance Mat with Exploded View AR-15 Pivot Pin and Roll Pin Installation Tool AR Front Sight Tool Delta Ring Tool Strap Wrench AR-15 Bore Guide AR -15 Adjustable Receiver Link Bore Brush, .22 Cal Bolt Carrier Brush Chamber Brush Magazine/Upper Receiver Brush Nylon Brush Handle Double-ended General Cleaning Brush Cleaning Pick Set Custom Fitted Carrying Case
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review