Nikon P-Tactical 2MOA Superdot 1x22mm, Black
|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 = '16510' AND (upper(f.web_text) = 'NIKON' or upper(f.orig_text) = 'NIKON' or upper(a.brand) = 'NIKON') 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|
Free UPS ground shipping!
The P-TACTICAL SUPERDOT provides incredible image clarity, a crisp 2 MOA dot and the compact, lightweight specifications needed for fast point-and-shoot action. Nikon’s proprietary TRUCOLOR lens-and-coating technology provides a lifelike view with both-eyes-open sighting. The P-TACTICAL SUPERDOT offers 10 illumination brightness levels and retains the last setting upon the next power-up. Nikon solidly integrates the P-TACTICAL SUPERDOT’s internal components within a shockproof, waterproof, aircraft-grade aluminum housing for a lifetime of reliable performance. Powered by a single CR2032 battery.
Multiple layers of anti-reflective coating on all air-to-glass surfaces maximize light transmission, brightness and contrast, with 10 levels of brightness for virtually any light condition. The P-TACTICAL SUPERDOT is also night vision compatible, with the first two brightness settings that are compatible with night vision gear. Comes with the TRUCOLOR proprietary coating that minimizes the bluish tint common to reflex and dot sights.
Includes spacers to provide 1/3 co-witness or full co-witness. Raised protrusion functions as flat driver for adjustments.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review