Something

SELECT news.id, title, text, news.time, userUName AS poster, COUNT(news_comments.id) AS commentcount 
FROM news, users, news_comments 
WHERE news_comments.news_id = news.id AND users.id = news.user_id 
GROUP BY news.id, title, text, news.time, poster 
ORDER BY time 
DESC LIMIT 15