sqlite> SELECT name as 'Player', COUNT(*) as '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 = 'Dummy' then 1 else 0 end) AS Dummy, 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 = 'Solo' then 1 else 0 end) AS Solo, sum(case when server = 'Race' then 1 else 0 end) AS Race, sum(case when server = 'Fun' then 1 else 0 end) AS Fun FROM (SELECT DISTINCT a.map, b.server, a.name, a.time FROM race as a JOIN maps as b ON a.map = b.map WHERE time = (SELECT min(time) FROM race WHERE a.map = map)) GROUP BY name ORDER BY COUNT(*) DESC LIMIT 50; Player Rank1s Novice Moderate Brutal Insane Dummy DDmaX Oldschool Solo Race Fun -------------- ------ ------ -------- ------ ------ ----- ----- --------- ---- ---- --- Spooky 329 7 29 46 18 3 73 128 25 0 0 Inner peace 225 1 8 8 2 44 9 0 146 5 2 coradax 176 5 34 51 19 7 44 9 3 2 2 ano :3 173 0 2 14 2 0 11 129 10 4 1 Cireme 120 7 21 38 2 5 36 0 6 3 2 Brokecdx- 116 37 31 14 2 1 28 1 0 0 2 Colo-Colo 114 9 49 4 1 0 45 5 0 0 1 rockuS 99 37 25 11 1 0 25 0 0 0 0 Cyclic~ 64 0 14 40 0 5 4 1 0 0 0 VéNa 58 3 8 14 6 0 19 7 0 0 1 Grk0ne 57 0 12 41 2 0 1 0 0 0 1 rezee 56 0 12 17 12 0 13 0 0 0 2 Cor 51 0 22 16 1 2 8 1 1 0 0 [D]coradax 48 0 5 25 3 0 15 0 0 0 0 Fudgyking 45 0 0 0 0 0 0 0 2 43 0 Cougar~ 40 1 7 18 0 10 2 0 0 0 2 Aoe 39 0 1 10 3 1 16 8 0 0 0 nether 35 0 1 0 0 0 0 0 17 17 0 Shawn. 34 0 0 31 1 0 2 0 0 0 0 ☯Mڶɴ3☯ 33 0 18 3 0 0 12 0 0 0 0 Noctua 33 0 14 10 0 1 8 0 0 0 0 Yota. 32 0 2 16 0 12 2 0 0 0 0 reo 27 0 0 25 2 0 0 0 0 0 0 *~Rôny~* 27 0 1 3 0 0 1 0 22 0 0 Pryzed 26 0 7 9 0 9 1 0 0 0 0 PlantKnight 26 0 2 12 0 3 6 3 0 0 0 Chrona 26 0 2 6 1 2 0 0 14 1 0 Ventti~ 24 4 13 3 0 0 4 0 0 0 0 AvapiX 24 1 3 1 0 0 16 2 1 0 0 Verside 20 3 9 2 0 0 3 0 0 0 3 ScReeNy 20 0 2 8 0 0 9 0 0 0 1 Loonex 20 4 6 0 0 0 7 1 0 0 2 ad 19 0 2 1 0 0 15 0 0 0 1 Lexin 19 0 8 3 0 0 8 0 0 0 0 iParano 18 0 2 8 2 1 0 4 1 0 0 NovaShock 18 0 3 1 0 0 13 0 0 0 1 Freezestyler 18 0 7 4 0 0 6 0 0 0 1 Liesus 17 0 0 16 0 1 0 0 0 0 0 Blurry 17 0 4 4 0 0 8 1 0 0 0 Ryu 16 0 3 2 0 0 10 0 0 0 1 Soapy Sandwich 15 3 1 1 0 1 7 1 0 0 1 Push 15 0 0 0 0 0 0 0 2 13 0 pv 14 3 3 0 0 0 3 0 3 0 2 Ra!n 14 0 0 0 0 0 0 0 13 1 0 Mizkibo 14 0 8 2 2 0 1 1 0 0 0 Knuski 14 0 0 2 0 3 0 0 7 2 0 Fluday 14 0 4 4 0 0 5 1 0 0 0 Cloudly 14 0 0 2 0 0 7 5 0 0 0 nothing 13 0 4 3 1 0 5 0 0 0 0 Starkiller 13 4 2 0 0 0 5 0 2 0 0