Briley Remington Extended Choke Tube for 20 Gauge Improved Cylinder
|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 = 'REMX20IC' AND (upper(f.web_text) = 'BRILEY' or upper(f.orig_text) = 'BRILEY' or upper(a.brand) = 'BRILEY') 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|
To be the best shooter you can be, you need the best. Whether you're a world-class competitor or just not discovering the enjoyment of shooting, you need remember only one name. BRILEY.
Briley has become a legend in competition and recreational shooting - in solving problems, producing leading edge ideas and products, and always putting the needs of their customers first.
Briley has tested this choke to out-perform all factory chokes so that the choke needed to get the job done is available to the serious shooter.
This choke extends outside the barrel, and has the constriction laser marked outside for easy identification. Remington Extended Choke.
20 Gauge Extended
CLOSEOUT, BOXES MAY BE WORN
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$29.99 to $30.99