Carlson's Beretta Optima HP 12 Ga Cremator Non-Ported Waterfowl Choke Tubes
Out Of Stock
|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 = '11663' AND (upper(f.web_text) = 'CARLSON`S' or upper(f.orig_text) = 'CARLSON`S' or upper(a.brand) = 'CARLSON`S') 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|
Carlson’s Cremator® Choke Tubes features brand new Triple Shot Technology (TST) and is offered in close mid and long range constrictions. TST is a series of three graduated rings in the taper section of the choke tube that allows a more gradual transition from the shotgun bore to the final constriction. This design offers reduced pellet deformation, less flyers and more dense patterns. These benefits make the Cremator® Series extremely effective on all types of waterfowl throughout the entire season.
The Optima HP Cremator® series has no size or speed restrictions with steel shot in the Close or Mid Range constrictions. The Long Range is limited to no steel shot larger than #2. You also get all the benefits of an extended choke tube, including a 25% longer parallel section for tighter and more dense patterns, wrench-less installation, quick removal and helps with muzzle protection.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$24.97 to $39.99
$24.99 to $29.99