Топ 10 нечемних (юзер / к-сть отриманих карток за рік)
Код: Виділити все
+-------------+----------+
| username | count(*) |
+-------------+----------+
| BOXER | 23 |
| Thorn | 20 |
| topper | 16 |
| hrdrive | 15 |
| Apokalipsis | 15 |
| Vusiko | 13 |
| pikach00 | 12 |
| torba | 11 |
| AnGeL | 11 |
| RULES | 11 |
+-------------+----------+
Код: Виділити все
+--------------+----------+
| username | count(*) |
+--------------+----------+
| Жульєн | 356 |
| Babak | 237 |
| weber | 100 |
| NIK | 72 |
| Denja | 68 |
| Tsonic | 1 |
+--------------+----------+
Код: Виділити все
+-------------+----------+
| username | count(*) |
+-------------+----------+
| BOXER | 3229 |
| hrdrive | 2871 |
| AnGeL | 2603 |
| cat-yellow | 2567 |
| Vusiko | 2108 |
| gribkoff777 | 1707 |
| LEgEnDA | 1674 |
| vovka | 1625 |
| Thug | 1454 |
| mister_X | 1390 |
+-------------+----------+
Код: Виділити все
+-------------------------------+----------+
| username | count(*) |
+-------------------------------+----------+
| hrdrive | 24 |
| cat-yellow | 23 |
| Taras:) | 19 |
| BOXER | 18 |
| Ziro-cool | 18 |
| Йосип | 18 |
| weber | 17 |
| Дмитро Сторожук | 17 |
| Rosko | 17 |
| Pier | 16 |
+-------------------------------+----------+
Код: Виділити все
+-------------+----------+
| username | count(*) |
+-------------+----------+
| BOXER | 487 |
| Myself | 385 |
| cat-yellow | 296 |
| LEgEnDA | 289 |
| vovka | 237 |
| AnGeL | 236 |
| Kost | 199 |
| Fobos | 155 |
| axel | 144 |
| TIGER-NIGER | 144 |
+-------------+----------+
Код: Виділити все
+-------------+----------+
| username | count(*) |
+-------------+----------+
| hrdrive | 1510 |
| BOXER | 1485 |
| cat-yellow | 1180 |
| Thug | 958 |
| AnGeL | 917 |
| mister_X | 768 |
| weber | 761 |
| pikach00 | 721 |
| RULES | 684 |
| gribkoff777 | 641 |
+-------------+----------+