ERROR
Code: 1054
Query
SELECT tn.news_id,tn.news_subject,tn.news_cat,tn.news_news,tn.news_extended,tn.news_breaks,tn.news_name,tn.news_datestamp,tn.news_reads,tn.news_sticky,tn.news_allow_comments,tn.news_allow_ratings,tc.news_cat_name, tc.news_cat_image,tu.user_name,count(c.comment_id) as news_comments FROM {DB_PREFIX}news AS tn
				LEFT OUTER JOIN {DB_PREFIX}users AS tu ON tn.news_name=tu.user_id
				LEFT OUTER JOIN {DB_PREFIX}news_cats AS tc ON tn.news_cat=tc.news_cat_id
				LEFT OUTER JOIN {DB_PREFIX}comments AS c ON (c.comment_type='N' AND c.comment_item_id=tn.news_id) WHERE (tn.news_visibility='0' || tn.news_visibility='-2') AND tn.news_cat>0 AND (tn.news_start='0'||tn.news_start<=1513435813) AND (tn.news_end='0'||tn.news_end>=1513435813) AND tn.news_published='1' AND (tc.news_cat_locale='all' OR tc.news_cat_locale='German') GROUP BY tn.news_id ORDER BY tn.news_sticky DESC, tn.news_datestamp DESC LIMIT 0,2
Unknown column 'c.comment_id' in 'field list'