Lantac 5.56 Dragon Muzzle Brake
|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 = 'DGN556B' AND (upper(f.web_text) = 'LANTAC' or upper(f.orig_text) = 'LANTAC' or upper(a.brand) = 'LANTAC') 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|
LANTAC Dragon™ Muzzle Brake DGN556B™ for AR15, M16 & M4 Rifles.
Manufactured to the highest quality standards and featuring a patent pending design, the LANTAC DGN556B™ Muzzle Brake offers improved recoil management and muzzle rise over competitors products.
Its unique Short Energy Pulse system reduces length of recoil so that repeating shot energy cannot overlap and knock the shooter off target.
High rate of fire is possible with massively reduced recoil and muzzle climb, meaning that all shots fall on target.
Caliber: 5.56X45mm / .223
Material: Hardened Milspec Steel
Dimensions: L: 2.570', DIA Body: 0.866'
Thread: 1/2-28 UNEF R/H
Includes crush washer
Serial Numbered for Quality Control
Made in the USA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review