Someone

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

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