Briley Mobil-Choke Extended Choke Tube for Benelli, Beretta, and Franchi 20 Gauge Full
|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 = 'BERX12FU' 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.
Long tube extends beyond the length of the muzzle, features highly polished interior for less pellet deformation; reduced fliers and tighter patterns.
Knurled grasping band speeds installation and removal.
Choke constrictions is marked on band so there is no need to remove choke to verify size.
20 Gauge Extended
Beretta, Benelli, and Franchi using the Mobil-Choke System
CLOSEOUT, BOXES MAY BE WORN
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$24.99 to $29.99