Vortex Crossfire II 4-12x44MM
|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 = 'CF2-31015' AND (upper(f.web_text) = 'VORTEX OPTICS' or upper(f.orig_text) = 'VORTEX OPTICS' or upper(a.brand) = 'VORTEX OPTICS') 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|
With long eye relief, a fast-focus eyepiece, fully multi-coated lenses and resettable MOA turrets, there's no compromising on the Crossfire II. Clear, tough and bright, this riflescope hands other value-priced riflescopes their hat. The hard anodized single-piece aircraft-grade aluminum tube is nitrogen purged and o-ring sealed for waterproof/fogproof performance.
Fully Multi-Coated Increases light transmission with multiple anti-reflective coatings on all air-to-glass surfaces.
Second Focal Plane Reticle Scale of reticle maintains the same ideally-sized appearance. Listed reticle subtensions used for estimating range, holdover and wind drift correction are accurate at the highest magnification.
Tube Size 1-inch diameter.
Single-Piece Tube Maximizes alignment for improved accuracy and optimum visual performance, as well as ensures strength and waterproofness.
Aircraft-Grade Aluminum Constructed from a solid block of aircraft-grade aluminum for strength and rigidity.
Waterproof O-ring seals prevent moisture, dust and debris from penetrating the riflescope for reliable performance in all environments.
Fogproof Nitrogen gas purging prevents internal fogging over a wide range of temperatures.
Shockproof Rugged construction withstands recoil and impact.
Hard Anodized Finish Highly durable low-glare matte finish helps camouflage the shooter's position.
Capped Reset Turrets Allow re-indexing of the turret to zero after sighting in the riflescope. Caps provide external protection for turret.
Fast Focus Eyepiece Allows quick and easy reticle focusing.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review