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_description, IFNULL(p.products_image, 'table_n' at line 1

select count(*) as total SELECT p.products_id, pd.products_description, IFNULL(p.products_image, 'table_nocar_image.gif') AS products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name FROM products p INNER JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = 4 LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status = 1 ORDER BY p.products_last_modified DESC, p.products_price DESC, pd.products_name

[TEP STOP]