Troy Industries VTAC Alpha Battle Rail
$175.99 to $199.99
|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 = 'STRX-AVK-11BT-01' AND (upper(f.web_text) = 'TROY INDUSTRIES' or upper(f.orig_text) = 'TROY INDUSTRIES' or upper(a.brand) = 'TROY INDUSTRIES') 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|
Introduced in 2012, The Troy/VTAC Alpha Rail is Troy's latest version of the extremely popular VTAC Extreme Rail. Designed specifically for Retired SGM Kyle Lamb of Viking Tactics, a world-renowned tactical shooter and instructor, the VTAC Alpha Rail is a one-piece, free floating modular rail for M4 & M16 systems.
Slotted cooling holes for enhanced heat dispersion and lighter weight.
Uninterrupted top MIL-STD Picatinny rail for the mounting of optics and backup iron sights.
Easy to install.
Includes two 2" and one 4.2"detachable rails and all mounting hardware
Machined from hardened aircraft aluminum with stainless steel components.
Finished in MIL-SPEC hardcoat anodizing.
Works with standard AR15/M16 barrel nut
No barrel nut included.
Note: Alpha rails do not work with the TRX Barrel Nut or TRX Barrel Wrench.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$13.97 to $22.99
$9.99 to $15.99