Help for this page

Select Code to Download

Select or download this

select match_id,screen_name winner_name from battle,player where battl
+e.winner=player.player_id;
+----------+----------------------+
...
+----------+----------------------+

Select or download this

mysql> select match_id,screen_name loser_name from battle,player where
+ battle.loser=player.player_id;
+----------+---------------------------------+
...
+----------+---------------------------------+