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_id` IN ('30114')) AND `pinfo`.`status` IN ('active','discontinued') 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 '%LightBulbs' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LightBulbs' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LightBulbs' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LightBulbs"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LightBulbs"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LightBulbs"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LightBulbs"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LightBulbs' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LightBulbs',`category_4` ='LightBulbs') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LightBulbs,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LightBulbs', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Light Bulbs

Refine Search

  GO
 
Brand

Satco(4)

GE(2)

Apollo(1)

 
Brightness

1,550 lm(1)

1,600 lm(1)

 
Size

5.2" x 5.2"(1)

PAR38(1)

 
Packaged Quantity

1 Each(4)

 
Limited Warranty

2 Year(3)

 
Warranty

Manufacturer's limited one-year warranty.(1)

 
Application

Track and Recessed(1)

Floodlight; Indoor(1)

Projectors(1)

 
For Use With

Compatible with Apollo 3000, 3004, AI-1004, AI-1005, Horizon (15000), Horizon 2 (16000), Ventura (4000), Toplite; 3M 4407, 4410; Buhl 9014ED, 9014EDC; Dukane 28A622A, 28A632A, 28A611; Eiki 3850, 3860, 3870, 3890(1)

 
Diameter

4.25"(1)

 
Input Voltage

120 V AC(4)

 
Model Name/Number

PAR38(2)

 
Base

E26(3)

E26SK(1)

 
Bulb/Tube Type

PAR38(2)

 
Maximum Bulb Power

15 W(1)

85 W(1)

60 W(1)

 
Maximum Bulb Life

10000 Hour(3)

1500 Hour(1)

 
Color Rendering Index

82(3)

 
Manufacturer Part Number

S7291(1)

S7341(1)

S7241(1)

S2248(1)

62706(1)

92950(1)

A-EYB(1)

 
Country of Origin

China(4)

CN(2)

US(1)

 
Height

5.94"(1)

5.38"(1)

 
Length

5.2"(1)

4.25"(1)

 
Voltage

120 V(2)

82 V(1)

 
Color Temperature

4400.3°F (2426.8°C)(3)

4940.3°F (2726.8°C)(1)

2700 K(1)

2900 K(1)

 
Light Color

White(3)

 
Power

18 W(1)

90 W(1)

360 W(1)

 
Bulb Shape

Spiral(3)

Flood-Spot(2)

 
Appearance

Soft White(1)

Crisp White(1)

 
Rated Life

25,000 h(1)

1,100 h(1)

 
Energy Saver

Yes(2)

 
Equivalent to Incandescent

120 W(2)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved