EXPLAIN SELECT 
p1.first_name p1_first_name, p1.last_name p1_last_name, 
p2.first_name p2_first_name, p2.last_name p2_last_name, 
winner_id, score, match_id FROM tennisdraws.TDM_Match m JOIN tennisdraws.TDM_Player as p1 ON m.player_1_id = p1.player_id 
JOIN tennisdraws.TDM_Player as p2 ON m.player_2_id = p2.player_id 
WHERE m.event_id='1' AND match_id<'1000'
ORDER BY m.match_id ASC

"1","SIMPLE","p1","ALL",\N,\N,\N,\N,"165","Using temporary; Using filesort"
"1","SIMPLE","p2","ALL",\N,\N,\N,\N,"165",""
"1","SIMPLE","m","ALL","match_id",\N,\N,\N,"340","Using where"

SELECT 
p1.first_name p1_first_name, p1.last_name p1_last_name, 
p2.first_name p2_first_name, p2.last_name p2_last_name, 
winner_id, score, match_id FROM tennisdraws.TDM_Match m JOIN tennisdraws.TDM_Player as p1 ON m.player_1_id = p1.player_id 
JOIN tennisdraws.TDM_Player as p2 ON m.player_2_id = p2.player_id 
WHERE m.event_id='1' AND match_id<'1000'
ORDER BY m.match_id ASC