Firefield Rapidstrike 1-6x24 Rifle Scope Kit
|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 = 'FF13070K' 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|
Your do-it-all rifle needs a do-it-all optic. With the RapidStrike 1-6x24mm AR-15 riflescope kit, you get speed, accuracy and distance - something you just can’t get out of a red dot sight. The 1-6x magnification provides fast and accurate point and shoot capabilities without target or reticle distortion, 2-6x is perfect magnification for medium-ranges when hog hunting or for 3-Gun competition. The illuminated green or red, second focal plane, Circle Dot reticle is simple, so field of view isn’t comprised. Bullet drop compensation is calibrated for 5.56mm 55-grain ammo.
There is no need to worry about waiting for the right mount because the RapidStrike riflescope kit comes with everything you need to head right to the range. Included is a cantilever mount to provide the correct cheekweld for AR-15s, throw lever for rapid magnification changes, a honeycomb filter to reduce glare and pop-up, resettable locking turrets that return to zero. Multi-coated, anti-reflective glass, along with its IP67 waterproof rating, keeps images crisp and clear in bright daylight, as well as low-light.
Kit includes cantilever mount, throw lever, and honeycomb lens filter
6x magnification optical system
Pop-up locking turrets
Second focal plane
Red or greeen illuminated reticle
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review