Home/Shooting Sports/Optics/Bases & Rings/Leupold Deltapoint Pro Cross Slot Mount
- Leupold Deltapoint Pro Cross Slot Mount
- Leupold Deltapoint Pro Cross Slot Mount
- Leupold Deltapoint Pro Cross Slot Mount 120056
Leupold DeltaPoint Pro Cross Slot Mount 120056 $63.00 In Stock. Leupold DeltaPoint Pro Rear Iron Sight 120058 $79.99 In Stock. Leupold DeltaPoint Pro Cross Slot Riser. Leupold DeltaPoint Pro Dovetail Mount, Ruger American 9mm. Leupold BackCountry Cross-Slot Browning A-Bolt SA 1-pc Matte Scope Base 171344. Find out more about the Leupold DeltaPoint Pro Cross Slot Riser. Fly the Leupold colors and show everyone what’s at your core. Leupold Optics, Be Relentless.
Item# 120056 Encore boston harbor casino opening date.
$69.99
query | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
| |||||||||||||||||||||||||||||||||
CACHED | false | |||||||||||||||||||||||||||||||||
EXECUTIONTIME | 46 | |||||||||||||||||||||||||||||||||
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 = '120056' 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 | |||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Leupold Deltapoint Pro Cross Slot Mount
Leupold Deltapoint Pro Cross Slot Mount
This mount adapter can be used on any Picatinny, Weaver, or cantilever, rail or base that does not require a riser.
WARNING Cancer and Reproductive Harm www.P65Warnings.ca.gov |
No reviews have been written for this product.
Be the first one! – Write a Review
Be the first one! – Write a Review