Error: 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 ') 
                                                  order by field(p.product_id' at line 20<br />Error No: 1064<br />select p.product_id, 
                                                        pd.name, 
                                                        p.price, 
                                                        p.markup, 
                                                        p.discount, 
                                                        p.sh_type,
                                                        m.name m_name, 
                                                        m.markup m_markup, 
                                                        m.discount m_discount, 
                                                        p.tax_class_id, 
                                                        p.currency_id, 
                                                        i.filename
				                                  from product p 
                                                  left join product_description pd on (p.product_id = pd.product_id) 
                                                  left join product_to_category p2c on (p.product_id = p2c.product_id) 
                                                  left join image i on (p.image_id = i.image_id) 
                                                  left join manufacturer m on (p.manufacturer_id = m.manufacturer_id) 
                                                  left join currency c on (c.currency_id = p.currency_id) 
                                                  where pd.language_id = '1' 
                                                  AND p.product_id IN () 
                                                  order by field(p.product_id, )