Warne Skyline Precision Bipod
|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 = '7901M' AND (upper(f.web_text) = 'WARNE' or upper(f.orig_text) = 'WARNE' or upper(a.brand) = 'WARNE') 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|
The Warne® Skyline™ Precision Bipod is the most functional, ergonomic and strongest bipod on the market today. Designed to attach to your picatinny rail, the Skyline bipod allows the shooter to make quick, one-handed height adjustments, as well as smooth cant and panning ability for use on uneven terrain or less than ideal positions. The Skyline bipod is made from 6061 T6 & 7075 T6 aircraft-grade aluminum with steel components in high stress/hard use areas. Look for Warne’s complete line of Skyline Precision Shooting Accessories at your favorite retailer.
Patent Pending Design
Quickly attaches to any Picatinny Type Rail
One Hand adjustability
Rapid leg deployment from horizontal to 90°
3 Position Leg Rotation: 0°, 45°, 90°
Leg Extension Min Height 6.9” / Max Height 9.1”
22° Total Cant / 44° Total Pan
Weighs 16.5 oz
Designed and MADE IN USA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review