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 pd.products_id, pd.products_name, p.products_date_available from products' at line 1
select count(select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != \'\' and pd.language_id = \'1\' order by p.products_date_available DESC) as total
