West Coast Weaponworks WC-9 Complete 9MM Upper with 2 Magazines
|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 = 'WC-9-U' AND (upper(f.web_text) = 'WEST COAST WEAPONWORKS' or upper(f.orig_text) = 'WEST COAST WEAPONWORKS' or upper(a.brand) = 'WEST COAST WEAPONWORKS') 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|
This may be the perfect way to convert your AR15 style rifle to shoot 9MM ammo. Simply attach the upper to you standard AR15 lower, insert the Endo Magazine, and enjoy shooting.
The Mean Arms Endo Magazine comes fully assembled in a new Gen 3 5.56/.223 PMAG® housing and is restrictive state compliant as an unmodifiable, 10-round magazine (fixed base plate).
Two Mean Arms Endo Magazines are included in this kit!
15" MLOK Handguard
9MM Muzzle Brake
Works with standard AR15 lower
Works with standard AR15 buffer & spring
2 Endo Magazines included
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$20.97 to $35.99