terrible_lie

mysql> select user,count(*) as posted from talkleft, user
where user.userid=talkleft.userid 
group by talkleft.userid 
order by posted desc 
limit 11;
+--------------+--------+
| user         | posted |
+--------------+--------+
| fatal_error  |  19045 |
| bezdeliiga   |   6003 |
| explosive    |   3654 |
| narayana     |   3180 |
| zhuz         |   3180 |
| krix         |   3116 |
| terrible_lie |   3031 |
| lupus        |   2511 |
| wenom        |   2447 |
| skalpelis    |   2328 |
| elina        |   2182 |
+--------------+--------+
11 rows in set (3.07 sec)

mysql> select user,count(*) as recvd 
from talk2,user 
where journalid=userid 
group by journalid 
order by recvd desc 
limit 11;
+--------------+-------+
| user         | recvd |
+--------------+-------+
| bezdeliiga   |  5511 |
| explosive    |  3666 |
| narayana     |  3409 |
| lupus        |  3214 |
| phoenix      |  2828 |
| terrible_lie |  2409 |
| skalpelis    |  2405 |
| honeybee     |  1937 |
| susure       |  1922 |
| wenom        |  1893 |
| antikrists   |  1829 |
+--------------+-------+
11 rows in set (0.32 sec)

emils

pastaavees kas mainiisies!