Evolution Outdoor 1680D 42`` Tactical Single Rifle Case
|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 = '51285-EV' AND (upper(f.web_text) = 'EVOLUTION OUTDOOR' or upper(f.orig_text) = 'EVOLUTION OUTDOOR' or upper(a.brand) = 'EVOLUTION OUTDOOR') 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|
Whether you're logging time in at the range or going on an outdoor adventure, it's time to gear up with the EVOLUTION TACTICAL line. The 42" TACTICAL RIFLE CASE is loaded with premium padding, functionality and superb durability. Made of durable 1680D fabric, not only does this tactical rifle case look fantastic but is truly heavy duty and will last for years. You'll love the functionality and features loaded into this premium rifle case. Equipped with heavy gauge foam padding, this TACTICAL RIFLE CASE offers maximum impact resistance to protect your firearm from damage. This premium tactical rifle case is designed with hook and loop tie down straps to secure your firearm. It also has a large hook and loop front panel for plenty of patches. This case is designed with great features which include 3 zippered pockets on front, paracord zipper pulls, MOLLE webbing on front, and an adjustable, removable shoulder strap. Dimensions are : 42" x 12.5" x 4.5" inches. With premium functionality and features, this will be your "go to" tactical gun case to transport and carry your firearm for your range days or outdoor adventures.
Made of durable 1680D fabric
Padded foam material for firearm protection
Hook and loop tie down straps to secure your firearm; Large hook and loop front panel for plenty of patches
3 zippered pockets on front, paracord zipper pulls; MOLLE webbing on front
Adjustable, removable shoulder strap
Size: 42" x 12.5" x 4.5" inches
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$7.99 to $29.99