-

SELECT CONCAT(first_name,' ',last_name) as player_name, CONCAT(LEFT(first_name,1),' ',last_name) as player_short_name, nickname, p.teamID, t.TName, t.TShortName, IFNULL(singles_played,0) AS singles_played, IFNULL(singles_won,0) as singles_won, IFNULL(singles_lost,0) AS singles_lost, IFNULL(singles_percentage,0) as singles_percentage, IFNULL(doubles_played,0) AS doubles_played, IFNULL(doubles_won,0) as doubles_won, IFNULL(doubles_lost,0) AS doubles_lost, IFNULL(doubles_percentage,0) as doubles_percentage FROM 2019sumsPlayerStats s LEFT JOIN 2019sumsPlayers p ON p.playerID=s.playerID LEFT JOIN 2019sumteams t ON p.teamID=t.TeamID WHERE t.GroupID>0 ORDER BY singles_percentage DESC, singles_played DESC, singles_won DESC, doubles_percentage DESC, doubles_played DESC, doubles_won DESC;

[STOP]