Trijicon Acog 4x32MM USMC with TA51 Mount
|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 = 'TA31RCO-M4CP' AND (upper(f.web_text) = 'TRIJICON' or upper(f.orig_text) = 'TRIJICON' or upper(a.brand) = 'TRIJICON') 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 TA31RCO is an Advanced Combat Optical Gun sight (ACOG) designed for the M16A4 Weapon system (20” barrel). It incorporates dual illumination technology using a combination of fiber optics and self- luminous tritium. This allows the aiming point to always be illuminated without the use of batteries. The Tritium illuminates the aiming point in total darkness, and the fiber optic self-adjusts reticle brightness during daylight according to ambient light conditions. This allows the operator to keep both eyes open while engaging targets and maintaining maximum situational awareness. Designed to the exact specifications of the United States Marine Corps, the unique reticle pattern provides quick target acquisition at close combat ranges while providing enhanced target identification and hit probability out to 800 meters utilizing the Bullet Drop Compensator.
• Thumbscrew Flattop Adapter (TA51)
• ACOG Thumb Screw (RCO) (TA53A)
• 4x32 RCO killFLASH®
• Adjuster Cap Lanyards
• 4x32 Scopecoat (TA96)
• LENSPEN® (TA56)
• Trijicon Logo Sticker (PR15)
• RCO Manual
• Warranty Card
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review