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','out_of_stock','spl_call_for_price') 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

GE(37)

Apollo(1)

 
Brightness

800 lm(5)

760 lm(3)

1,100 lm(3)

1,800 lm(3)

650 lm(2)

950 lm(2)

1,600 lm(2)

1,490 lm(1)

615 lm; 1,540 lm; 2,155 lm(1)

610 lm(1)

1,000 lm(1)

1,140 lm(1)

850 lm(1)

3,405 lm(1)

1,520 lm(1)

1,060 lm(1)

1,160 lm(1)

470 lm(1)

1,200 lm(1)

350 lm(1)

440 lm(1)

550 lm(1)

890 lm(1)

 
Size

A19(5)

5.13" x 2.5"(2)

5.12" x 2.52"(2)

2.6" x 5.4"(1)

5.37" x 3.25"(1)

8" dia x 1.13"(1)

1.32" x 0.38"(1)

2.31" x 1.38"(1)

 
Application

General Purpose(21)

Utility(3)

Active Spaces(3)

Track & Recessed; Indoor(2)

Working Spaces(2)

Projectors(1)

Night Light(1)

Floodlight; Indoor(1)

Circline(1)

Flood Light; Outdoor(1)

Garage Door(1)

Outdoor Floodlight(1)

 
For Use With

General-Purpose Light Fixtures(4)

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)

E12 Sockets(1)

 
Diameter

1.22"(5)

2.38"(4)

3.35"(3)

2.52"(3)

2.5"(2)

2.6"(1)

3.25"(1)

1.13"(1)

0.38"(1)

1.38"(1)

 
Model Name/Number

A19(8)

T8(8)

93105686(1)

93129439(1)

93129298(1)

93127996(1)

93127795(1)

93116005(1)

93109188(1)

93109035(1)

93109032(1)

11585(1)

C7(1)

48266(1)

48198(1)

46650(1)

S11(1)

T3(1)

T9(1)

30691(1)

BR30(1)

93130566(1)

 
Bulb/Tube Type

A19(19)

T8(8)

BR30(3)

PAR38(2)

A21(1)

C7(1)

T9(1)

T3(1)

S11(1)

 
Country of Origin

CN(34)

US(2)

HU(2)

 
Height

4.13"(4)

1.18"(3)

1.57"(3)

1.22"(2)

6.91"(2)

6.89"(2)

5.12"(1)

 
Length

2.38"(4)

50.38"(3)

24.41"(3)

18.5"(2)

5.13"(2)

5.12"(2)

5.4"(1)

5.37"(1)

8"(1)

1.32"(1)

2.31"(1)

 
Voltage

120 V(35)

82 V(1)

130 V(1)

12 V(1)

 
Color Temperature

2700 K(9)

2850 K(5)

5000 K(3)

3000 K(2)

2800 K(1)

4000 K(1)

 
Power

8 W(8)

15 W(7)

11 W(3)

9 W(3)

12 W(3)

10 W(2)

6 W; 12 W; 17 W(1)

8.5 W(1)

14 W(1)

5 W(1)

360 W(1)

200 W(1)

40 W(1)

35 W(1)

22 W(1)

65 W(1)

4 W(1)

10.5 W(1)

 
Bulb Shape

Globe(21)

Linear Tube(8)

Flood-Spot Reflector(5)

Circular Tube(1)

Bi-Pin Tube(1)

 
Appearance

Soft White(13)

Daylight(8)

Reveal(5)

Cool White(4)

Bright White(3)

Clear(2)

Warm White(1)

 
Rated Life

10,000 h(11)

15,000 h(11)

36,000 h(8)

2,000 h(3)

750 Hours(1)

12,000 h(1)

500 h(1)

3,285 h(1)

 
Energy Saver

Yes(31)

No(5)

 
Equivalent to Incandescent

60 W(6)

75 W(5)

100 W(5)

40 W(4)

20 W(3)

65 W(2)

15 W(2)

90 W(2)

50 W; 100 W; 150 W(1)

75 Watt(1)

 
 
 
 

© 2025-2026 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander