[Vince]

This looks inefficient and it probably is. What do these "player*Days" fields even store? I don't understand the purpose of those loops either since there isn't any additional check taking place. If you want to exclude players that are not in a group/clan you should use

PHP код:

WHERE playerGroup IS NOT NULL 


And then there is of course the completely unnecessary usage of mysql_format because nothing is being formatted.