Leupold BX-2 Alpine 10x42mm Shadow Gray
|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 = '176971' 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|
Some consider a good set of 10x42 binoculars the sweet spot. Enough magnification for clear identification but still compact enough to take everywhere.
Whether it’s your first set of binoculars or your 50th, your glass needs to give you a bright image, feel comfortable in your hands, and be able to take a beating. The BX-2 Alpine binoculars check all these boxes and more. With our Twilight Max Light Management System, this set of binoculars will out-perform everything in its class when it comes to seeing more in less light. And backed by our full lifetime guarantee, you’ll be wondering why you didn’t have to pay more.
•Lightweight but tough as nails, a rugged magnesium housing protects the optic during fast-paced action
•A built-in 1/4-20 rotateable tripod adapter port makes it easy to mount to a tripod
Twist Up Eyecups
•Features twist-up eyecups and generous eye relief for comfortable extended viewing.
Twilight Max Light Management System
•Adds up to 20 extra minutes of shooting light
•Eliminates 85% more glare-producing stray light than competitors
•Premium edge-to-edge lens clarity
Central Focus Dial
•Large, tactile focus dial is easy to find and use, even with gloved hands, which gives you the precision focus you need to pick antlers out of the trees or hide out of the brush.
•The diopter focus paddle allows you to precisely focus your binoculars, compensating for differences between your eyes.
Waterproof & Fogproof
•Absolute waterproof and fogproof integrity means it's ready to perform in the field, in all conditions.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$34.99 $23.99 to $29.99