Wilson Combat 8 Round 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) ) 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 = '47dwilson-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|
Our legendary magazines are so inherently reliable they'll make virtually ANY 1911 pistol function EVERYTIME, including YOURS!
Increases Reliability in ALL 1911 Pistols
Aircraft Grade Certified Stainless Steel Tube Resists Corrosion
.027" Tube Walls - Thickest In The Industry
Tubes are Heat Treated for Maximum Durability and Service Life
Fiber-Fill Nylon Self-Lubricating Follower Provides Smooth Round Feeding
Maximum Tensile Strength Heavy-Duty Spring for Long Service Life, Enhanced Feeding and Positive Slide Stop Operation
Removable .350" Plastic Base Pad for Easy Maintenance and Versatility with Different Base Pad Options
No Other Magazine on the Market Can Compare for Proven Inherent Reliability, Durability and the Ability to Remain Loaded for Long Periods of Time Without Damage
No-Risk Service Policy - If It Breaks from Normal Use, We Replace It!
Wilson Combat® has been supplying serious shooters and professionals with the worlds' most reliable and durable .45 auto magazines for the past 30 years. They are used by the worlds' most Elite U.S. Army SPEC OPS unit, FBI SWAT, Thunder Ranch and professionals worldwide. NO other .45 magazine on the market can compare for proven inherent reliability, durability and the ability to remain fully loaded for long periods of time without damage. Our magazine springs are specially fabricated from the highest tensile strength heavy duty spring wire for long service life enhanced feeding and positive slide stop operations. Our magazine bodies are manufactured from .027" (the thickest in the industry) aircraft grade certified 17-7 PH stainless steel and heat treated for maximum durability and service life. Our dimensional tolerances are held so close that you will never encounter a Wilson magazine that doesn't drop free from your pistol or that your rounds are tight inside the tube as long as your pistol and ammo are close to proper specifications.
No reviews have been written for this product.
Be the first one! – Write a Review
$16.99 to $19.99