Lamp

Lamp

Product Image Qty.- Item Name Price
003-000884-0-ER Replacement Lamp Christie, Dig 8

003-000884-0-ER Replacement Lamp Christie, Dig

Replacement Lamp Christie, Dig
Price Unavailable



003-000884-01 Replacement Lamp Christie, Dig 6

003-000884-01 Replacement Lamp Christie, Dig

Replacement Lamp Christie, Dig
Price Unavailable



003-000884-01-E Replacement Lamp Christie, Dig 0

003-000884-01-E Replacement Lamp Christie, Dig

Replacement Lamp Christie, Dig
Price Unavailable



003-000884-01-H Replacement Lamp Christie hous 86

003-000884-01-H Replacement Lamp Christie hous

Replacement Lamp Christie hous
Price Unavailable



003-100856-ER Compatible FP Lamp 4

003-100856-ER Compatible FP Lamp

Compatible FP Lamp
Price Unavailable



003-100857-0-ER Compatible FP Lamp 4

003-100857-0-ER Compatible FP Lamp

Compatible FP Lamp
Price Unavailable



003-100857-02 Christie FP Lamp 0

003-100857-02 Christie FP Lamp

Christie FP Lamp
Price Unavailable



003-120181-0-ER Compatible Projector Lamp 5

003-120181-0-ER Compatible Projector Lamp

Compatible Projector Lamp This Lamp is for Projection Design EVO Projector models.
Price Unavailable



003-120181-01-E Compatible Projector Lamp 0

003-120181-01-E Compatible Projector Lamp

Compatible Projector Lamp
Price Unavailable



01-00228-ER Compatible FP Lamp Smart Board 10

01-00228-ER Compatible FP Lamp Smart Board

Compatible FP Lamp Smart Board
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 = '11757' and p.products_status = 1 and p.products_image p.products_image NOT IN('no_picture.gif','none.gif') ]