Nikko Stirling Mountmaster 3-9x40mm W/Rings
|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 = 'NMC3940WC' AND (upper(f.web_text) = 'NIKKO STIRLING' or upper(f.orig_text) = 'NIKKO STIRLING' or upper(a.brand) = 'NIKKO STIRLING') 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|
Built to function as the ideal scope, the Nikko Stirling Mountmaster 3-9x40mm Riflescope is perfect for scenarios in which a top quality riflescope is the key to achieving success. These Riflescopes from the optical experts at Nikko Stirling are made using the tough and heavy duty materials that you have come to expect out of this remarkable company. For a stretch of time, Nikko Stirling has grown in the enterprise of fabricating top end rifle scopes, and the Nikko Stirling Mountmaster 3-9x40mm Riflescope is the evidence of their dedication to supplying you with the best equipment for your sighting requirements.
- 1 inch Weaver Rings
- Adjustable Objective from 10yds up to Infinity
- Fast Eye Focus
- Waterproof, Fogproof, Shockproof
- 3/8 Tip Off Rings
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$31.99 $17.97 to $27.99