Wilson Combat 8 Round Elite Tactical Magazine
|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 = '500wilson-combat' AND (upper(f.web_text) = 'WILSON COMBAT' or upper(f.orig_text) = 'WILSON COMBAT' or upper(a.brand) = 'WILSON COMBAT') 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|
The ETM started with a blank sheet of paper and 30+ years of 1911 and 1911 magazine experience. It WILL set a new standard in 1911 magazines while redefining state-of-the-art.
Increases Reliability in ALL 1911 Pistols
Aircraft Grade Certified Stainless Steel Tube Resists Corrosion
The ETM has the Strongest Magazine Tube Yet Developed, Virtually Eliminating Feed Lip Cracking, Tube Spread and Cracking and General Fatigue
Refined Radius for Each Bend in the Tube to Take Advantage of the Strength in the Stainless Steel
Proprietary, Custom Designed Welding Process
Proprietary Multi-Step Tumbling and Finishing Process Provides Smooth Follower Operation and Insertion into the Weapon
Observation Slots Moved to the Rear of the Tube, Located Exactly Where They Need to be to Maintain the Structural Integrity
Innovative Follower Design With its Extended Skirt Ensures Stability in Operation and Minimizes Creep from the Tube when the Magazine is Empty
Fiber-Fill Nylon Self-Lubricating Follower Provides Smooth Round Feeding
Positive Slide-Lock After the Last Round has been Fired
Space-Age Stainless Steel Spring Wire is Phenomenal for Spring Life
The ETM Seats and Locks in the Weapon with the Slide Down
Removable Base Pad for Easy Maintenance and Versatility with Different Base Pad Options
The Quality Control Behind the ETM Promises a Lifetime of Smooth and Reliable Operation
No-Risk Service Policy - If It Breaks from Normal Use, We Replace It!
Wilson Combat®, with a firmly established reputation for outstanding quality, the highest reliability, and superb service both before and after the sale has built hundreds of thousands of 1911 single-stack magazines. We get a lot of feedback about magazines, and magazine performance - and we listen. Our magazines have undergone 3 design and/or material changes, each carefully evaluated and proven before they were released to the market. The result of our latest effort is a completely redesigned magazine with the features we've heard you ask for.
No reviews have been written for this product.
Be the first one! – Write a Review