Zev Tech Pro Plus Universal Magwell
|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 = 'MW.K-STD-PRO-PLUS' 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 PRO Plus Mag-well is universal for the 1st-4th Generation Glock® . Its Aluminum 1 piece design is finished in a black matte, smooth Anodized finish and the packaging includes the mag-well, screw and wrench.
The mag-well is slightly more flared at the base to be wider than the stock opening, which is ideal for quickly inserting the magazine in the pistol during reloading, helping build proper muscle memory for improved consistency and reload time.
This ZEV Technologies PRO Plus Mag-well is a great addition for any shooter looking for an edge without the bulk flared competition style mag-well. The addition of a mag-well will help keep the users hands in place while shooting.
Designed to fit both Gen 3 and 4 Glock® frames which features a solid 1-piece design. Gen4 back straps may need to be modified if used.
Compatible Glock® models (17, 17L, 22, 24, 31, 34, 35 and 37)
NOTE: 10 Round magazines WILL NOT work with this model of mag-well. If 10 round capacity magazines are primarily used, this product is not recommended.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review