Får inte riktigt SUM() att fungera korrekt..

SELECT Forumthreads.*,
  (SELECT Count(*) FROM Forumposts WHERE Threadid = Forumposts.Postthreadid) AS nummer,
  (SELECT SUM(nummer) FROM Forumthreads WHERE Threadforumid = 5 AND Threadcityid = 2) AS AntalPosts
FROM Forumthreads
GROUP BY Threadforumid

threadid, threadsubject, threadhits, threadsticky, threadforumid, threadlocked, threadcityid, nummer, AntalPosts

29,       'Tjena!',      109,        0,            5,             0,             2,            7,      63
34,       'Jooooorå',    17,         1,            5,             0,             2,            3,      27
35,       'Mjo',         21,         1,            5,             0,             2,            1,      9
36,       'aaa..',       46,         0,            5,             0,             2,            4,      36
37,       'ooo..',       21,         1,            5,             1,             2,            1,      9
38,       'assasda',     6,          0,            5,             0,             2,            2,      18
40,       'da',          1,          0,            5,             0,             2,            0,      0
42,       'kek..',       2,          0,            5,             0,             2,            0,      0
43,       'Hoppla',      4,          0,            5,             0,             2,            1,      9

"SELECT Forums.*, "&_
			"(SELECT Count(*) FROM Forumthreads WHERE Threadforumid = Forums.Forumid AND Threadcityid = 2) AS forumthreads, "&_
			
			"(SELECT Postdate FROM Forumposts "&_
				"INNER JOIN Forumthreads ON Forumposts.Postthreadid = Forumthreads.Threadid "&_
				"WHERE Threadforumid = Forums.Forumid AND Forumthreads.Threadcityid = 2 "&_
				"ORDER BY Postid DESC LIMIT 0,1) AS datum, "&_

			"(SELECT Postuserid FROM Forumposts "&_
				"INNER JOIN Forumthreads ON Forumposts.Postthreadid = Forumthreads.Threadid "&_
				"WHERE Threadforumid = Forums.Forumid AND Forumthreads.Threadcityid = 2 "&_
				"ORDER BY Postid DESC LIMIT 0,1) AS userid, "&_
			
			"(SELECT Count(*) FROM Forumposts "&_
				"INNER JOIN Forumthreads ON Forumposts.Postthreadid = Forumthreads.Threadid "&_
				"WHERE Forumthreads.Threadforumid = Forums.Forumid AND Forumthreads.Threadcityid = 2) AS forumposts "&_
			
			"FROM Forums "&_
			"ORDER BY Forumid ASC"