GG&G Eotech XPS 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-1272' 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|
GG&G continues to be the only manufacturer of Lens Covers For The EOTech XPS Scopes. These patented lens covers fit between the EOTech XPS2-0 and 3-0 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 cover will fold back so that it is not damaged. Because of the contours of the EOTech housing, these covers are not 100% waterproof, but they do prevent most dust, debris, rain and snow from accumulating on the lenses. These unique lens covers 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.
Have Some Fun--especially you ZOMBIE KILLERS! We are now offering a ZOMBIE KILLER Lens Cover set along with "FRONT TOWARD ENEMY" or "INFIDEL" engraved on the front lens cover at no additional charge.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review