Briley Beretta Optima Choke Tube for 12 Gauge Light 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,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 = 'BEOS12LF' 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.
Minimum gap geometry and high resolution RMS interior finishes gives less pellet deformation; consistently tighter patterns.
Choke constriction is laser marked, on color-coded band so there is no need to remove choke to verify size.
Long tube with hidden wrench slots extends beyond the length of the muzzle.
Knurled grasping band speeds installation and removal.
Helical rifled Diffusion spreader tubes provide a pattern that is more open than cylinder.
12 Gauge Spectrum
CLOSEOUT, BOXES MAY BE WORN
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review