1.) najvyssie total loginy

mysql> select username, concat(to_days(date_sub(total_login, interval 1 hour))-to_days(from_unixtime(0)), '-', date_format(date_sub(total_login, interval 1 hour), '%H-%i ')) as b from topzaw_20011112_125001 order by total_login desc limit 20;

2.) premenovanych za dany mesiac (dolezite je robit tieto dotazy len na mesiace
iduce hned po sebe aby sme zarucene odchytili kazdeho premenovaneho pouzivatela;
keby sme jeden mesiac preskocili, mohli by sme nejake premenovanie vynechat
z dovodu premenovania na nove meno v prvom mesiaci a premenovania na povodne
stare v dalsom mesiaci)

mysql> select t2.username as new_name, t1.username as old_name from topzaw_20011031_235000 as t1, topzaw_20011112_125001 as t2 where t1.id = t2.id and t1.username not like t2.username;

3.) TTL plus 

mysql> select t2.username, t2.total_login - t1.total_login as diff from topzaw_20010930_235000 as t1, topzaw_20011031_235000 as t2 where t1.id = t2.id and (t2.total_login - t1.total_login > 0) order by diff desc;

4.) TTL minus

mysql> select t2.username, t2.total_login - t1.total_login as diff from topzaw_20010930_235000 as t1, topzaw_20011031_235000 as t2 where t1.id = t2.id and (t2.total_login - t1.total_login < 0) order by diff asc;

5.) Level plus

mysql> select t2.username, t2.level new_level, t1.level old_level, t2.level - t1.level as diff from topzaw_20010930_235000 as t1, topzaw_20011031_235000 as t2 where t1.id = t2.id and (t2.level - t1.level > 0) order by diff desc, new_level desc;

6.) Level minus

mysql> select t2.username, t2.level new_level, t1.level old_level, t2.level - t1.level as diff from topzaw_20010930_235000 as t1, topzaw_20011031_235000 as t2 where t1.id = t2.id and (t2.level - t1.level < 0) order by diff asc, old_level desc;

7.) Pocet pouzivatelov jednotlivych levelov + zoznam pouzivatelov

mysql> select level, count(*) from topzaw_20011031_235000 group by level;

mysql> select * from topzaw_20011031_235000 where level = 9;