Alangator 10/22 Trimag Clamp
Item# TRIMAG CLAMP-10/22
|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,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 = 'TRIMAG CLAMP-10/22' AND (upper(f.web_text) = 'ALANGATOR' or upper(f.orig_text) = 'ALANGATOR' or upper(a.brand) = 'ALANGATOR') 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|
Triple Your Round Count From 10 to 30!
Don't take any chances looking for an extra magazine. The TriMag locks 3 factory magazines WITHOUT ANY MODIFICATIONS to Ruger factory magazines. As an added benefit, different types of ammo can be loaded and ready for different types of small game.
The patented TriMag design does not require any glue or adhesive. Only requires a standard screwdriver or coin to assemble/disassemble in the field or home.
Weight: .44 oz.
Nylon 6/6 GF-30
6061 Aluminum Screw
*Magazine(s) NOT Included
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$20.97 to $39.99