sqlite> SELECT name as 'Player', COUNT(*) as 'Team Rank1s', sum(case when server = 'Novice' then 1 else 0 end) AS Novice, sum(case when server = 'Moderate' then 1 else 0 end) AS Moderate, sum(case when server = 'Brutal' then 1 else 0 end) AS Brutal, sum(case when server = 'Insane' then 1 else 0 end) AS Insane, sum(case when server = 'DDmaX' then 1 else 0 end) AS DDmaX, sum(case when server = 'Oldschool' then 1 else 0 end) AS Oldschool, sum(case when server = 'Fun' then 1 else 0 end) AS Fun FROM (SELECT DISTINCT a.map, b.server, a.name, a.time FROM teamrace as a JOIN maps as b ON a.map = b.map WHERE time = (SELECT min(time) FROM teamrace WHERE a.map = map)) GROUP BY name ORDER BY COUNT(*) DESC LIMIT 50; Player Team Rank1s Novice Moderate Brutal Insane DDmaX Oldschool Fun ------------ ----------- ------ -------- ------ ------ ----- --------- --- Spooky 389 32 43 48 19 96 151 0 coradax 223 26 44 54 21 66 12 0 ano :3 177 1 3 14 2 11 146 0 Brokecdx- 170 70 45 15 2 37 1 0 rockuS 150 70 37 12 1 30 0 0 Cireme 131 27 26 39 2 36 0 0 Colo-Colo 104 0 47 4 2 49 2 0 VéNa 98 22 12 17 8 29 10 0 rezee 83 2 18 20 13 30 0 0 Cor 60 0 28 20 1 9 2 0 Cyclic~ 59 0 14 41 0 4 0 0 Grk0ne 57 0 12 42 1 2 0 0 [D]coradax 54 0 6 27 3 18 0 0 Aoe 40 0 1 10 4 17 8 0 Ventti~ 38 10 18 4 0 5 0 0 ☯Mڶɴ3☯ 35 0 18 3 1 13 0 0 Shawn. 34 0 0 31 1 2 0 0 Noctua 33 0 15 10 0 8 0 0 Cougar~ 33 1 10 18 0 2 1 0 Verside 29 9 14 3 0 3 0 0 reo 27 0 0 25 2 0 0 0 PlantKnight 27 0 3 13 0 7 3 0 AvapiX 24 0 4 1 0 17 2 0 Yota. 22 0 3 16 0 2 0 0 ScReeNy 21 0 3 8 0 9 0 1 Lexin 21 2 8 3 0 8 0 0 Inner peace 21 1 8 8 2 1 0 0 ad 20 0 3 1 0 16 0 0 iParano 19 0 2 9 3 1 4 0 Blurry 19 0 4 5 0 9 1 0 Pryzed 18 0 8 9 0 1 0 0 NovaShock 17 0 3 1 0 13 0 0 Freezestyler 17 0 7 4 0 6 0 0 paradise 16 7 2 3 1 3 0 0 Ryu 16 0 3 2 0 11 0 0 Liesus 16 0 0 16 0 0 0 0 Cactus 16 6 2 1 0 7 0 0 nothing 15 2 4 3 1 5 0 0 Fluday 15 0 3 5 0 6 1 0 Mizkibo 14 0 9 2 1 1 1 0 Cloudly 14 0 0 2 0 7 5 0 .pet 13 2 6 0 0 5 0 0 Fimp 12 0 2 2 0 7 0 1 ֆaʋaɢɛ 11 0 2 9 0 0 0 0 qed 11 0 0 1 0 8 2 0 lola 11 0 3 2 0 6 0 0 [D] Cougar~ 11 0 1 9 0 0 0 0 Graves 11 0 1 9 0 1 0 0 Chyste 11 0 2 9 0 0 0 0 TDPL 10 0 1 3 0 6 0 0