Lamp

Lamp

Product Image Qty. Item Name Price+
TY-LA2004-ER Compatible RPTV Lamp for Panas 21

TY-LA2004-ER Compatible RPTV Lamp for Panas

Compatible RPTV Lamp for Panas
Price Unavailable



UX21513-ER Compatible Hitachi Lamp 160

UX21513-ER Compatible Hitachi Lamp

Compatible Replacement TV Lamp made with an OEM compatible UHR bulb for Hitachi models 42V515, 42V525, 42V710, 42V715, 50C10, 50V500G, 50V525E,...
Price Unavailable



UX25951 OEM Equivalent Hitachi Lamp 28

UX25951 OEM Equivalent Hitachi Lamp

Repalcement TV Lamp for Hitachi models 50VS69A, 55VS69, 55VS69A, 62VS69, 62VS69A. Fits with compatible part number: UX25951 Lamp Life -...
Price Unavailable



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

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 46

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 475

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 809

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 485

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 88

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 488

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




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') ]