GG&G Eotech Lens Cover
|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 = 'GGG-1275' AND (upper(f.web_text) = 'GG AND G INC' or upper(f.orig_text) = 'GG AND G INC' or upper(a.brand) = 'GG AND G INC') 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|
There is little doubt that the EOTech Holosight is one of the best red dot sights available today. However, our customers have told us that they think it is missing an important element-LENS COVERS. We think they are right, so we developed a set that is easy to install and operate.
The GG&G EOTech Lens Covers fit between the EOTech hood and the body of the EOTech housing. They are spring operated so that once pressure is applied to release them from the closed position, they spring open. The rear cover lays across the top, so as not to interfere with the field of view. The front cover opens and serves as a sun shield. However, if heavy brush etc. is encountered, the front lens will fold back so that it is not damaged. Because of the contours of the EOTech housing, these rifle scope lens covers are not 100% waterproof, but they do prevent most dust, debris, rain and snow from accumulating on the lenses. These unique lens covers for scopes can be easily operated with either hand to provide flexibility of operation. The design and methodology is so unique that we were awarded a patent.
As with all GG&G products, the lens covers for the EOTech are made in the USA.
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