Lamp

Lamp

Product Image Qty. Item Name Price+
A-1085-447-A-ER Compatible Sony Lamp 0

A-1085-447-A-ER Compatible Sony Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models ]KDF55WF655, KDF55XS955, KDF60WF655, KDF60XS955, KDFE55A20, KDFE60A20,...
Price Unavailable



A-1606-034-B-ER Compatible Sony Lamp 4

A-1606-034-B-ER Compatible Sony Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models KF-42WE610, KF-50WE610, KF-60WE610, KDF-60XBR950, KDF-70XBR950, KDF-50WE655...
Price Unavailable



BP96-00826A-ER Compatible Samsung Lamp 2

BP96-00826A-ER Compatible Samsung Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Samsung TV models: HLP4663W, HLP4667W, HLP5067W, HLP5663W, HLP5667W, HLP6163W, HLP6167W,...
Price Unavailable



BP96-01073A-ER Compatible Samsung Lamp 9

BP96-01073A-ER Compatible Samsung Lamp

Compatible Replacement TV Lamp for Samsung models : HLR4264W, HLR4266W, HLR4266WX/XAA, HLR1331WX/XAC HLR4HLR4667W, HLR5056WX/XAA, HLR5064W,...
Price Unavailable



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

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



F-9308-760-0-ER Compatible Sony Lamp 6

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

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models KDSR50XBR1, KDSR60XBR1, KDS60R2000. This lamp comes with complete outer...
Price Unavailable



TS-CL110UAA-ER Compatible JVC Lamp 14

TS-CL110UAA-ER Compatible JVC Lamp

Replacementy TV Lamp made with high quality UHR bulb for JVC models HD-52G456, HD-52G587, HD-52G657, HD-52G786, HD-52G787, HD-52G886, HD-52G887,...
Price Unavailable



TY-LA1000-ER Compatible Panasonic Lamp 10

TY-LA1000-ER Compatible Panasonic Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Panasonic models PT43LC14, PT43LCX64, PT44LCX65, PT50LC13, PT50LC14, PT50LCX63,...
Price Unavailable



TY-LA1500-ER Compatible Panasonic Lamp 3

TY-LA1500-ER Compatible Panasonic Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for models PT40LC12, PT40LC13, PT45LC12. This lamp comes with complete outer housing unit...
Price Unavailable



UX21516-ER Compatible Hitachi Lamp 2

UX21516-ER Compatible Hitachi Lamp

Compatible Repalcement TV Lamp made with an OEM compatible UHR bulb for Hitachi models 50VF820, 50VG825, 50VS810A, 55VF820, 55VG825, 60VF820,...
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') ]