Firefield Battletek Weapon Light with Green 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 = 'FF25018' 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 BattleTek Flashlight with green laser (FF25018) is ideal for quick target acquisition and combat simulations while in low-light situations. BattleTek sights are compact and crafted out of a lightweight, durable glass filled nylon material and are IP55 rated water resistant, shockproof and able to stand up to a max caliber of .308. Also features a 150-lumen LED light with a strobe setting and a 5mw green laser, with a range of up to 50 yards of visibility during the day or 600 yards at night.
BattleTek sights are crafted out of lightweight and durable glass filled nylon plastic
Green laser allows for quick target and reaches up to 50 yards during the day and 600 yards at night
A 150-lumen LED flashlight identifies targets and temporarily disorients intruders
Featuring an ambidextrous digital switch to fit the needs of all users
Water resistant and shockproof
Light: 1.4 hours on continuous use, 1 hour on strobe
Laser: 2.5 hours continuous, 5 hours strobe
Laser and light: 50 minutes continuous
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$99.99 to $179.99