Bare Bulb


Product Image Qty.+ Item Name Price
003-000884-01-B Replacement Bulb Christie 0

003-000884-01-B Replacement Bulb Christie

Replacement Bulb Christie
Price Unavailable



003-000884-01-X Replacement Bulb Christie OEM 0

003-000884-01-X Replacement Bulb Christie OEM

Replacement Bulb Christie OEM
Price Unavailable



003-100856-01-B Bare Bulb 0

003-100856-01-B Bare Bulb

Bare Bulb
Price Unavailable



003-120181-01-B Bare Bulb 0

003-120181-01-B Bare Bulb

Bare Bulb
Price Unavailable



01-00228-B PROJECTOR Bulb 0

01-00228-B PROJECTOR Bulb

PROJECTOR Bulb
Price Unavailable



01-00247-B Bare Bulb 0

01-00247-B Bare Bulb

Bare Bulb
Price Unavailable



01-00247-X Bare Bulb 0

01-00247-X Bare Bulb

Bare Bulb
Price Unavailable



105-495-B Bare Bulb 0

105-495-B Bare Bulb

Bare Bulb
Price Unavailable



20-01032-20-X Bare bulb - OEM 0

20-01032-20-X Bare bulb - OEM

Bare bulb - OEM
Price Unavailable



20-01175-20-B Compatible Bare Bulb 0

20-01175-20-B Compatible Bare Bulb

Compatible Bare Bulb
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 = '11812' and p.products_status = 1 and p.products_image p.products_image NOT IN('no_picture.gif','none.gif') ]