Firefield Impulse 1x30 Red Dot with Laser
|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 = 'FF26020' 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|
The Firefield Impulse 1x30 Red Dot Sight is a versatile optical weapon sight. Featuring an illuminated red reticle, the Impulse features six brightness settings that can adapt to any terrain and allow for optimal shooting in low light scenarios. This sight is designed for quick target acquisition, and the illuminated red dot quickly catches your eye making aiming easier and more efficient. The Impulse is powered by a single CR123A battery and also features an integrated red laser sight. The 3 MOA reticle provides precision accuracy, perfect for short and medium range combat situations. Compatible with AR-15’s and picatinny mounts, the Impulse handles recoil well and is completely shockproof for maximum durability. The Impulse is a must-have for any tactical shooter.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review