$result = DB_query_array_all("SELECT fullname,COUNT(*) as c FROM Score".
" LEFT JOIN User ON User.id=winner_id" .
" WHERE score IN ('fox','doko','karlchen')".
" GROUP BY game_id,fullname".
" ORDER BY c DESC LIMIT 3" );
array_unshift($result,array("Name","Points"));
$result = DB_query_array_all("SELECT fullname,COUNT(*) as c FROM Score".
" LEFT JOIN User ON User.id=winner_id" .
" WHERE score IN ('fox','doko','karlchen')".
" GROUP BY game_id,fullname".
" ORDER BY c DESC LIMIT 3" );
array_unshift($result,array("Name","Points"));