clnk@lupus ~ % tmux -V
tmux 2.1
clnk@lupus ~ % watch "mysql clnk_league -te 'select s.rank, s.score, s.trend, s.bonus_account bonus, c.tag, u.name from lg_scores s join lg_users u on u.id = user_id left join lg_clans c on
u.clan_id = c.id where user_is_deleted = 0 and league_id = 1 order by rank asc limit 10;'"
clnk@lupus ~ % watch "mysql clnk_league -te 'select from_unixtime(date_started), g.status, scenario_title, group_concat(name) from lg_games g left join lg_game_players p on id = game_id gro
clnk@lupus ~ % watch "mysql clnk_league -te 'select from_unixtime(date_started), g.status, scenario_title, group_concat(name) from lg_games g left join lg_game_players p on id = game_id gro
up by id order by id desc limit 25;'"
clnk@lupus ~ % watch "mysql clnk_league -te 'select from_unixtime(date_started), g.status, scenario_title, group_concat(name) from lg_games g left join lg_game_players p on id = game_id gro
up by id order by id desc limit 30;'"
watch 9.54s user 7.00s system 0% cpu 32:49.22 total
clnk@lupus ~ % watch "mysql clnk_league -te 'select from_unixtime(date_started), g.status, scenario_title, group_concat(name) from lg_games g left join lg_game_players p on id = game_id gro
up by id order by id desc limit 30;' | cut -c -189"
clnk@lupus ~ % ls src1 clnk@lupus ~ % watch "mysql clnk_league -te 'select from_unixtime(date_started), g.status, scenario_title, group_concat(name) from lg_games g left join lg_game_player
s p on id = game_id group by id order by id desc limit 35;' | cut -c -189"
watch 45385.77s user 35749.08s system 1% cpu 2162:51:33.50 total
clnk@lupus ~ %
from lg_scores s join lg_users u on u.id = user_id left join lg
_clans c on u.clan_id = c.id where user_is_deleted = 0 and leagu
e_id = 1 order by rank asc limit 10;'"
watch 31182.23s user 28211.92s system 0% cpu 2163:40:31.10 tot
al
clnk@lupus ~ %
clans c on u.clan_id = c.id where user_is_deleted = 0 and league
_id = 2 order by rank asc limit 10;'"
watch 31311.00s user 28363.73s system 0% cpu 2163:40:26.59 tot
al
clnk@lupus ~ %
gue -te 'select s.rank, s.score, s.trend, s.bonus_account b
onus, c.tag, u.name from lg_scores s join lg_users u on u.i
d = user_id left join lg_clans c on u.clan_id = c.id where
user_is_deleted = 0 and league_id = 4 order by rank asc lim
it 10;'"
watch 31200.72s user 28355.13s system 0% cpu 2163:40:21.4
0 total
clnk@lupus ~ %