Leupold VX-3i LRP 6.5-20x50MM
|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 = '172344' AND (upper(f.web_text) = 'LEUPOLD' or upper(f.orig_text) = 'LEUPOLD' or upper(a.brand) = 'LEUPOLD') 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|
When long range hunters, shooters, or precision rifle competitors need extreme accuracy, the VX-3i LRP (Long Range Precision) delivers. The Twilight Max light management system lets you hunt longer, or pick out distant targets from the shadows with unsurpassed clarity and resolution. Choose first or second focal plane reticles in MOA or MIL, with matching adjustment increments to match your specific shooting style. The all new elevation adjustment features a unique travel indicator marked in 5 mil or 5 moa increments, and is easy to read from the prone or difficult shooting positions. An adjustable zero stop prevents over rotation. The windage dial features a protective cover that can be replaced with the included thread protector if you prefer running an exposed dial. A redesigned power selector with included throw lever makes magnification changes quick and easy. The VX-3i LRP defines Versatility.
1/10th MIL Click Adjustment
100% Waterproof and Fog Proof
6061-T6 Aircraft Quality Aluminum
Blackened Lens Edges
Front Focal Plane (FFP)
Twilight Max Light Management System
Twin Bias Spring Erector System
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review