SQL timeout and dont know why

[daniel]

hi

first of all i am new to mysql and maybe that is my problem ...

i have an sql to show up a picture gallery on my website.

SELECT tabBilder.Bid ,
tabBilder.Name , tabBilder.RateUser , tabBilder.Groesse ,
tabBilder.Datum,tabBilder.CommentCount,tabBilder.T itel
,tabBilder.Rating ,
ROUND( tabBilder.Rating / ( tabBilder.RateUser * 5 ), 1) * 5 AS
AverageRating , tabBilder.UID ,tabUser.UserNick
FROM tabBilder
INNER JOIN tabUser ON tabBilder.UID = tabUser.UserID
Where tabBilder.Aktiv = 1 AND Privat = 0
Group by tabBilder.BID
Order by BID DESC LIMIT 0 , 14

everything works fine until i´ve tried to modify it with a 2nd join.
goal was to create one sql string to build up not only a gallery but
rather something like a hall of fame with SUM the ratings to get a new
order crit. after modification it looks like :

SELECT Sum(tabBilderratings.Rating) as TagesSumme, tabBilder.Bid ,
tabBilder.Name , tabBilder.RateUser , tabBilder.Groesse ,
tabBilder.Datum,tabBilder.CommentCount,tabBilder.T itel
,tabBilder.Rating ,
ROUND( tabBilder.Rating / ( tabBilder.RateUser * 5 ), 1) * 5 AS
AverageRating , tabBilder.UID ,tabUser.UserNick
FROM tabBilder
INNER JOIN tabUser ON tabBilder.UID = tabUser.UserID
LEFT JOIN tabBilderratings ON tabBilder.BID = tabBilderratings.BID
Where tabBilder.Aktiv = 1 AND Privat = 0
Group by tabBilder.BID
Order by TagesSumme DESC LIMIT 0 , 14

problem now, this sql string kills my webserver = script timeout ...
also direct on my isp mysql db with mysqlfront firing it nothing
happens. i get no error or 0 result ... mysqlfront seems to hang up.

any idea or suggestions would make me happy.

greetings