Zev Tech Pro Flat Face Trigger Drop-In Kit, 1st-3rd Gen, 9mm, Blk/Red
|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 = 'FFT-PRO-DRP-3G9-B-R' 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 created the market for GLOCK trigger upgrades. Over the years, their triggers have won more world championships and are in the hands of more professionals than all other after-market triggers, combined.
At the core of Zev's PRO Flat Face trigger is ZEV's new proprietary trigger bar and professional connector. These products deliver the crispest, cleanest trigger pull available. Finally, Zev's new trigger pad features a revolutionary riveted assembly process that makes it the longest lasting and most reliable replacement trigger on the market.
• Drop-in installation.
• Ergonomically correct trigger pad.
• Available for most GLOCK models.
• Mil-Spec hard-anodized aluminum construction.
• All ZEV triggers include our NEW PRO connector.
• ZEV PRO Flat Face Riveted Trigger.
• ZEV Trigger Bar.
• ZEV PRO Connector.
• ZEV Firing Pin Safety.
• ZEV Firing Pin Safety Spring.
• ZEV PRO Striker Spring.
• ZEV Trigger Spring Ejector Housing.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review