Strike Industries AR Stock Stop
|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 = 'SI-AR-STOCKSTOP' AND (upper(f.web_text) = 'STRIKE INDUSTRIES' or upper(f.orig_text) = 'STRIKE INDUSTRIES' or upper(a.brand) = 'STRIKE INDUSTRIES') 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|
Keep the look of your existing stock and buffer tube but be able to convert it to fixed! The Stock Stop is the most affordable, easiest, and quickest way to convert your collapsible stock into a fixed stock. The Stock Stop fills in all but one receiver extension hole. This ensures that the stock cannot be adjusted to another position. Compatible with any 6-position buffer tube the Stock Stop requires no modification to the buffer tube-- simply cut the piece to fit, and it drops right in. No need to drill and pin your existing stock. Made out of high strength and abrasion resistant TPU, the stop is ensured to stay in place, and out of sight.
Keeps the look of your collapsible stock and converts it to a fixed configuration instantly.
Designed to fit any mil-spec 6-position buffer tube as well as our 7 position Advanced Receiver Extensions.
Low profile and lightweight
High strength TPU material to withstand recoil and securely stay in place
No modification to the receiver extension necessary
Size:Length: 3.48 inches
Width: 0.3340 inches
Height: 0.4220 inches
Weight: 0.12 oz.
Materials:TPU-85A (thermoplastic polyurethane)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review