select match_id,screen_name winner_name from battle,player where battle.winner=player.player_id;
+----------+----------------------+
| match_id | winner_name          |
+----------+----------------------+
|        1 | Red Mustang   ~PoOp~ |
|        2 | Red Mustang   ~PoOp~ |
+----------+----------------------+



##</code><code>##

mysql> select match_id,screen_name loser_name from battle,player where battle.loser=player.player_id;
+----------+---------------------------------+
| match_id | loser_name                      |
+----------+---------------------------------+
|        1 | Princepawn        gru           |
|        2 | tim                         gru |
+----------+---------------------------------+