Merging af sql queries?

Har endelig fikset problemet selv.

SELECT News.ID, News.Headline, News.Text, News.Date, IFNULL(Comment.CommentUser,'NAN'), IFNULL(Comment.Date,'2000-01-01 00:00:00'), COALESCE(Count.Cnt,0) FROM News LEFT OUTER JOIN (SELECT NewsID, CommentUser, Date FROM newscomments GROUP BY NewsID) AS Comment ON Comment.NewsID=News.ID LEFT OUTER JOIN (SELECT NewsID, COUNT(*) AS Cnt FROM newscomments GROUP BY NewsID) AS Count ON Comment.NewsID=News.ID ORDER BY News.Date DESC