Lamp

Lamp

Product Image Qty.- Item Name Price
BP96-01653A OEM Equivalent Samsung Lamp 0

BP96-01653A OEM Equivalent Samsung Lamp

Replacement TV Lamp for Samsung models HL50A650C1F, HL56A650C1F, HLT5675S, HL61A650C1F, HLS4676S, HLS4676SX, HLT4675S, HLT5075S, HLT5075SX, HLT5675S,...
Price Unavailable



BP96-01653A-ER Compatible Samsung Lamp 1

BP96-01653A-ER Compatible Samsung Lamp

Compatible Replacement TV Lamp for Samsung HL50A650C1F, HL56A650C1F, HLT5675S, HL61A650C1F, HLS4676S, HLS4676SX, HLT4675S, HLT5075S, HLT5075SX,...
Price Unavailable



BP96-01795A OEM Equivalent Samsung Lamp 10

BP96-01795A OEM Equivalent Samsung Lamp

Replacement TV Lamp for Samsung models HLT5076S, HLT5676S, HLT6176S.This lamp comes with complete outer housing unit module. Easy installation, no...
Price Unavailable



BP96-01795A-ER OEM Equivalent Samsung Lamp 3

BP96-01795A-ER OEM Equivalent Samsung Lamp

Compatible Replacement TV Lamp for Samsung HLT5076S, HLT5676S, HLT6176S. This lamp comes with complete outer housing unit module. Easy installation,...
Price Unavailable



DT00873 Lamp with Housing - Hitachi 1

DT00873 Lamp with Housing - Hitachi

Price Unavailable



E23100120W10-ER Replacement TV Lamp Bulb 53

E23100120W10-ER Replacement TV Lamp Bulb

Compatible Replacement TV Lamp Bulb. Part number: E23100120W10-ER Osram Part number: P-VIP 100-120/1.0 E23 Lamp Life - approximately 4,000 hours...
Price Unavailable



E23100120W13 Replacement Osram TV Lamp Bulb 89

E23100120W13 Replacement Osram TV Lamp Bulb

High Quality Osram Replacement TV Lamp Bulb. Part number: E23100120W13 Osram Part number: P-VIP 100-120/1.3 E23 Lamp Life - approximately 6,000...
Price Unavailable



E23132150W10 Replacement Osram TV Lamp Bulb 0

E23132150W10 Replacement Osram TV Lamp Bulb

High Quality Osram Replacement TV Lamp Bulb. Part number: E23132150W10 Osram Part number: P-VIP 132-150/1.0 E23 Lamp Life - approximately 6,000...
Price Unavailable



F-9308-750-0 OEM Equivalent Sony Lamp 0

F-9308-750-0 OEM Equivalent Sony Lamp

Replacement TV lamp made with high quality Osram bulb for Sony KKDF42E2000, KDF46E2000, KDF50E2000, KDF50E2010, KDF50EA11, KDF55E2000, KDFE42A10,...
Price Unavailable



F-9308-750-0-ER Compatible Sony Lamp 21

F-9308-750-0-ER Compatible Sony Lamp

Compatible Replacement TV Lamp for Sony KDF42E2000, KDF46E2000, KDF50E2000, KDF50E2010, KDF50EA11, KDF55E2000, KDFE42A10, KDFE42A11, KDFE42A11E,...
Price Unavailable




1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.products_image NOT IN('no_picture.gif','none.gif')' at line 9
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added, p.products_price from e_products p left join e_specials s on p.products_id = s.products_id, e_products_to_categories p2c, e_categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '11694' and p.products_status = 1 and p.products_image p.products_image NOT IN('no_picture.gif','none.gif') ]