1
2
3
4
SELECT user.id, user.name, COUNT(*) AS uploaded_files FROM file, user
WHERE user.id = file.author
GROUP BY file.author
ORDER BY uploaded_files DESC
Quote
id name uploaded_files
15103 CY 159
36338 Fiz 67
54960 BaDgEr 58
21737 Alistaire 55
13296 useigor 51
14788 BlazingStan 49
10793 Gholan 47
15496 Majatek 45
15910 FaqAp 44
144178 Deucalion 42
23034 Hunter162 42
15086 OlaFPhp 42
16024 united 40
40637 reactant 39
122 Kiffer-Opa 37
30550 Kurumi 37
16026 Factions 36
5954 Mawd 34
15507 The Spy 34
35054 SDgod 32
6786 Vectarrio 31
53360 MikuAuahDark 31
7749 EngiN33R 31
116710 BATTLEKOT 30
20738 Guitorres - trz 30
27235 Axel340 30
12397 Ice-cream16 29
36255 Snark 29
53068 Picias 29
14782 GunShoot 28