Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_name` LIKE "Flashlights") AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Flashlights' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Flashlights' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Flashlights' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Flashlights"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Flashlights"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Flashlights"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Flashlights"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Flashlights' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Flashlights',`category_4` ='Flashlights') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Flashlights,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Flashlights', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Flashlights

Refine Search

  GO
 
Brand

Maglite(6)

Streamlight(5)

 
Warranty

Manufacturer's limited lifetime warranty.(5)

 
Special Features

C4 LED Technology - 3,500 Peak Beam Intensity(1)

3,500 Peak Beam Intensity-10,000-hour bulb life.(1)

120V AC/DC Charger - 11,000 Peak Beam Intensity(1)

Flashlight and Holster Combo Pack(1)

 
Manufacturer Part Number

65018(1)

68202(1)

68244(1)

68602(1)

75014(1)

M2A016(1)

M2A01H(1)

S2D016(1)

S3D016(1)

S4D016(1)

SP2201H(1)

 
Country of Origin

US(11)

 
Color(s)

Black(8)

Yellow(2)

Yellow/Black(1)

 
Voltage

6 V(3)

3 V(3)

3.6 V(1)

4.5 V(1)

 
Power Source(s)

4 AA (Included)(3)

2 AA (Included)(3)

3 AAAA (Included)(1)

3.6V NiCad (Included)(1)

2 D (Sold Separately)(1)

3 D (Sold Separately)(1)

4 D(1)

 
Battery Type

Alkaline(10)

NiCad(1)

 
Bulb Type

LED(5)

Krypton(3)

Incandescent(2)

Xenon(1)

 
Flashlights Type

Standard(6)

Penlight(4)

LED(1)

 
Batteries Included

Yes(6)

No(2)

 
Projection Distance

24 m(1)

690 ft(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved