Trijicon HD Night Sights - Glock Standard Frames
|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 = 'GL101O' AND (upper(f.web_text) = 'TRIJICON' or upper(f.orig_text) = 'TRIJICON' or upper(a.brand) = 'TRIJICON') 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|
Fits Glock Model: 17, 17L, 19, 22, 23, 24, 25, 26, 27, 28, 31, 32, 33, 34, 35, 37, 38, 39, and 45. (Does not fit Glock MOS)
The HD Night Sights were specifically created to address the needs of tactical shooters. The three dot green tritium night sight set’s front sight features a taller blade and an aiming point ringed in photoluminescent paint while the rear sight is outlined in black and features a wider U-shaped notch. This unique configuration increases visibility and quickens front sight acquisition—even in transitional lighting. Additionally, the front surface of the rear sight is steeply hooked to assist in emergency one-handed slide operation.
ENHANCED FRONT-SIGHT ACQUISITION IN BRIGHT, TRANSITIONAL AND NO-LIGHT SITUATIONS
Glow-in-the-dark, photoluminescent-painted front outline combines with a “U” notch rear and black-painted rear outlines to quickly draw your eye to the front post in all lighting conditions.
ONE-HANDED SLIDE MANIPULATION
Steeply hooked front surface to assist in an emergency, one-handed slide manipulation.
INSTANTLY VISIBLE SIGHT PICTURE IN NO-LIGHT AND LOW-LIGHT SITUATIONS
Tritium phosphor-filled glass lamp illuminates sights for high visibility in all lighting conditions.
ENHANCED PROTECTION FROM HEAVY RECOIL AND HARSH CLEANING SOLVENTS
Tritium gas lamps are contained within protective aluminum cylinders and have additional silicone rubber cushioning.
EVENLY DISTRIBUTED LIGHT FROM TRITIUM LAMPS
Each Trijicon® tritium lamp is capped with a sapphire jewel that helps evenly distribute the light and also acts as an additional layer of protection from puncture and cleaning solvents.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review