Bare Bulb


Product Image Qty. Item Name+ Price
AN-A20LP-B Bare bulb 0

AN-A20LP-B Bare bulb

Bare bulb
Price Unavailable



AN-B10LP-B FP Bare Bulb 0

AN-B10LP-B FP Bare Bulb

FP Bare Bulb
Price Unavailable



AN-C430LP-B Bare Bulb 4

AN-C430LP-B Bare Bulb

Bare Bulb
Price Unavailable



AN-C55LP-B Replacement Projector bar bulb 0

AN-C55LP-B Replacement Projector bar bulb

Replacement Projector bar bulb
Price Unavailable



AN-D350LP-B Bare Bulb 0

AN-D350LP-B Bare Bulb

Bare Bulb
Price Unavailable



AN-F212LP-B Bar bulb 0

AN-F212LP-B Bar bulb

Bar bulb
Price Unavailable



AN-F310LP-B COmpatible Bare Bulb 0

AN-F310LP-B COmpatible Bare Bulb

COmpatible Bare Bulb
Price Unavailable



AN-MB60LP-B Bare Bulb 0

AN-MB60LP-B Bare Bulb

Bare Bulb
Price Unavailable



AN-P25LP-B Bare Bulb 3

AN-P25LP-B Bare Bulb

Bare Bulb
Price Unavailable



AN-XR10L2-B Bare Bulb 0

AN-XR10L2-B Bare Bulb

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