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(39)

Apollo(1)

 
Brightness

800 lm(5)

1,100 lm(4)

1,800 lm(3)

950 lm(3)

760 lm(3)

650 lm(2)

1,600 lm(2)

3,405 lm(1)

1,520 lm(1)

610 lm(1)

1,000 lm(1)

1,140 lm(1)

850 lm(1)

1,490 lm(1)

1,200 lm(1)

1,060 lm(1)

1,160 lm(1)

415 lm(1)

350 lm(1)

440 lm(1)

550 lm(1)

470 lm(1)

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

 
Size

A19(4)

5.13" x 2.5"(2)

5.12" x 2.52"(2)

2.6" x 5.4"(1)

5.75" x 1.87"(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)

6.3" x 3.07"(1)

 
Application

General Purpose(21)

Working Spaces(3)

Utility(3)

Active Spaces(3)

Track & Recessed; Indoor(2)

Projectors(1)

Appliances(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"(6)

2.38"(4)

3.35"(3)

2.5"(2)

2.52"(2)

2.6"(1)

1.87"(1)

3.25"(1)

1.13"(1)

0.38"(1)

1.38"(1)

3.07"(1)

 
Model Name/Number

T8(9)

A19(8)

11585(1)

93129439(1)

93129298(1)

93127996(1)

93127795(1)

93116005(1)

93109188(1)

93109035(1)

93109032(1)

93105686(1)

A21(1)

A15(1)

48266(1)

48198(1)

46650(1)

S11(1)

T3(1)

T9(1)

30691(1)

BR30(1)

C7(1)

93130566(1)

 
Bulb/Tube Type

A19(18)

T8(9)

BR30(3)

A21(2)

PAR38(2)

A15(1)

C7(1)

T9(1)

T3(1)

S11(1)

 
Country of Origin

CN(35)

US(3)

HU(2)

 
Height

4.13"(4)

1.18"(3)

1.57"(3)

1.22"(3)

6.91"(2)

6.89"(2)

5.75"(1)

5.91"(1)

 
Length

2.38"(4)

50.38"(3)

24.41"(3)

18.5"(3)

5.13"(2)

5.12"(2)

5.4"(1)

5.37"(1)

8"(1)

1.32"(1)

2.31"(1)

6.3"(1)

 
Voltage

120 V(37)

82 V(1)

130 V(1)

12 V(1)

 
Color Temperature

2700 K(10)

2850 K(5)

5000 K(3)

3000 K(2)

2800 K(1)

 
Power

8 W(8)

15 W(7)

11 W(4)

12 W(4)

9 W(3)

40 W(2)

10 W(2)

8.5 W(1)

14 W(1)

5 W(1)

360 W(1)

200 W(1)

35 W(1)

22 W(1)

65 W(1)

4 W(1)

6 W; 12 W; 17 W(1)

 
Bulb Shape

Globe(22)

Linear Tube(9)

Flood-Spot Reflector(5)

Circular Tube(1)

Bi-Pin Tube(1)

 
Appearance

Soft White(13)

Daylight(8)

Reveal(5)

Cool White(4)

Bright White(4)

Clear(3)

Warm White(1)

 
Rated Life

15,000 h(12)

10,000 h(11)

36,000 h(9)

2,000 h(3)

750 Hours(1)

1,500 h(1)

12,000 h(1)

500 h(1)

 
Energy Saver

Yes(32)

No(5)

 
Equivalent to Incandescent

60 W(6)

75 W(6)

100 W(5)

40 W(4)

20 W(3)

15 W(3)

65 W(2)

90 W(2)

50 W; 100 W; 150 W(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander