Zev Tech Combat Sight Set, .215 FO
|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,4) ) 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 = 'SIGHT.SET-215-FO-COM3-B' AND (upper(f.web_text) = 'ZEV TECH' or upper(f.orig_text) = 'ZEV TECH' or upper(a.brand) = 'ZEV TECH') 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|
Zev Technologies fiber optic sight sets are an inexpensive improvement that a Glock owner can make to their firearm. The top three complaints from Glock owners are the trigger, grip, and sights.
• Fiber optic sight sets have the highest resolution and greatest ease of acquisition.
• Higher visibility will allow you to keep your sights on target.
• The right Zev Technologies sight set will improve your shots on target dramatically over a factory Glock sight set.
• Notch width of .140 & Notch Dept of .145 will allow you enough room to keep your eyes on target during transitions.
• Zev Technologies parts always incorporate design, feel, and performance.
• Zev Technologies fiber optic sight sets are machined and assembled from Quality Billet materials and built to last.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review