Sightmark Universal Laser Boresight
|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 = 'SM39024' AND (upper(f.web_text) = 'SIGHTMARK' or upper(f.orig_text) = 'SIGHTMARK' or upper(a.brand) = 'SIGHTMARK') 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|
Tested and recommended by the National Tactical Officers Association and the North American Hunting Club, the Triple Duty™ Universal Red Laser Boresight is designed for sighting in .17-.50 caliber rifles, shotguns and pistols. A key feature to this device is it doesn't have any additional attachment pieces to be lost. Engineered with a self-centering arbor, the unit attaches into the end of the barrel as opposed to the inside, preventing metal from protruding into the firearm barrel. Simply place the base of the bore sight onto the end of the barrel, and it will attach magnetically. Includes a carrying case, three (3) AG3 batteries, and instructions.
- Precision Accuracy
- Reliable And Durable
- Fastest Gun Zeroing And Sighting System
- Reduce Wasted Cartridges And Shells
- Compact And Lightweight
- Easy To Pack And Travel
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