C-More Systems Railway Red Dot, 2 MOA
|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) ) 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 = 'ATAC-2' AND (upper(f.web_text) = 'C-MORE SYSTEMS' or upper(f.orig_text) = 'C-MORE SYSTEMS' or upper(a.brand) = 'C-MORE SYSTEMS') 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 Railway sight quickly attaches to Weaver and Picatinny rail style scope mounts. This enables the Railway to be attached to virtually anything! Shotguns, rifles, handguns, revolvers, crossbows, paint ball guns; these are just a few of the applications the Railway has seen. The sight can be easily detached and installed on other weapons, making it the most versatile in the C-MORE line up.
Heads Up Display for Fastest Target Acquisition
Super Bright Red Dot with Adjustable Intensity and Interchangeable Dot Module
Infinite Adjustment for Windage and Elevation Featuring Positive Locking Screws
Aluminum Body, Click Intensity Switch (12 Positions = Off, 2 NV, 1 Low Light and 8 Day light)
Attaches to Weaver or Picatinny Rail Mounts
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$14.97 to $29.99
$34.99 $23.99 to $29.99