Anonymous

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