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 n.news_id, n.status, n.show_date, DATE_FORMAT(n.d' at line 1

select count(news_id) as total SELECT n.news_id, n.status, n.show_date, DATE_FORMAT(n.date, '%d.%m.%Y, %H:%i') AS DATE, nd.title, nd.subtitle, nd.shorttext, nd.text, nd.image FROM news n, news_description nd WHERE n.news_id = nd.news_id AND nd.language_id = '2' ORDER BY n.news_id DESC

[XT SQL Error]