SQL timeout and dont know why

SQL timeout and dont know why

am 10.05.2006 10:26:59 von 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.Titel
,tabBilder.Rating ,
ROUND( tabBilder.Rating / ( tabBilder.RateUser * 5 ), 1) * 5 AS
AverageRating , tabBilder.UID ,tabUser.UserNick
FROM tabBilder
INNER JOIN tabUser ON tabBilder.UID =3D tabUser.UserID
Where tabBilder.Aktiv =3D 1 AND Privat =3D 0
Group by tabBilder.BID
Order by BID DESC LIMIT 0 , 14

everything works fine until i=B4ve 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.Titel
,tabBilder.Rating ,
ROUND( tabBilder.Rating / ( tabBilder.RateUser * 5 ), 1) * 5 AS
AverageRating , tabBilder.UID ,tabUser.UserNick
FROM tabBilder
INNER JOIN tabUser ON tabBilder.UID =3D tabUser.UserID
LEFT JOIN tabBilderratings ON tabBilder.BID =3D tabBilderratings.BID
Where tabBilder.Aktiv =3D 1 AND Privat =3D 0
Group by tabBilder.BID
Order by TagesSumme DESC LIMIT 0 , 14

problem now, this sql string kills my webserver =3D 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