MTM Tactical Range Box
|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 = 'TRB-40' AND (upper(f.web_text) = 'MTM' or upper(f.orig_text) = 'MTM' or upper(a.brand) = 'MTM') 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|
All the features of the our shooting range box plus this one comes with AR 223 size magazine well fork. The Tactical range box makes cleaning and maintenancing your AR's a pleasure. All you do is slip your AR on this fork and you have a elevated platform to do your work. Works both right and left handed. The 223 fork is red(shown black in picture).
We set out to make a shooting range box that you could turn it into the ultimate cleaning kit and maintenance stand for your shooting needs. Sporting a cleaning kit top and cleaning-station base, the RBMC utilizes a two-piece design for compact transport and convenient use once you get there. The topl section offers loads of divided space for jags, brushes, solvents…etc, keeping items sorted and organized. The base or ‘cleaning station’ offers plenty of deep storage for supplies and ammo. A pair of adjustable gun standard forks featuring soft, over-molded rubber padding offers easy positioning of firearms with a firm, non-marring hold. This range box also includedes the 5.56mm NATO or 223 magazine well fork. The overall length of the Shooting Range Box provides excellent stability for nearly any size firearm, as well as room for hard to fit items like collapsible cleaning rods or tripod extensions.
Box only, gun and accessories not included.
Cancer and Reproductive Harm
Average of 4 customer reviews:
Write a Review