products_new.php error

[cw3849]

After I log on and I try to use the link to view new products I am receiving the following error:

 

New Products

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 'select p.products_id, pd.products_name, p.products_image, p.pro

select count(select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = \'1\' left join specials s on p.products_id = s.products_id where p.products_status = \'1\' order by p.products_date_added DESC, pd.products_name) as total

 

[TEP STOP]

 

Has anyone else had this problem? what did you do to fix it? :blink:

I dont get in here much so if you could write me I would appreciate it.

Thanks in advance

aspeciality AT hotmail DOT com