Sig Sauer Romeo5 4 MOA Red Dot
|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 = 'SOR52001' AND (upper(f.web_text) = 'SIG SAUER' or upper(f.orig_text) = 'SIG SAUER' or upper(a.brand) = 'SIG SAUER') 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|
Sig is proud to provide our men and women in the armed forces with a light-weight, enclosed red-dot sight that is as tough as it is micro. The ROMEO5 features our MOTAC™ (Motion Activated Illumination) which increases battery life by shutting down the system when not in use and instantly activates the system when it senses the slightest vibration or movement. Your sight will be up when you go into action. The ROMEO5 will mount on any platform and the solid aluminum design will give peak performance and years of service. Military units trust the ROMEO5 when it counts, so why wouldn’t you?
- The ROMEO5 combines a leading edge optical design with an extremely robust, lightweight aluminum housing for years of worry-free service at a competitive price point
- The 2 MOA Red-Dot provides 10 illumination settings (8 daylight plus 2 NV) for visibility in all light conditions
- Features our MOTAC™ (Motion Activated Illumination) powers up when it senses motion and powers down when it does not. Provides for optimum operational safety and enhanced battery life
- The readily available CR2032 battery is side-loading, allowing for quick battery replacement without having to remove the sight from the firearm
- An integrated M1913 Picatinny interface provides industry-standard mounting options for a wide range of applications
- Dependable waterproof (IPX-7 rated for complete water immersion up to 1 meter) and fog-proof performance
- Includes a M1913 Picatinny low mount riser and a co-witness 1.41” riser mount
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$39.99 $23.97 to $37.99