ERROR 1054 occured.
Unknown column 'sp' in 'order clause'

SELECT id, player, name, nummer, team, teamname, position, 0 as games,0 as goals,0 as assist,0 as pm,0 as mins,0 as ga,0 as shots, season, 0 as gwg, 0 as gtg , 0 as ppg, 0 as shg, 0 as bullies, 0 as bullies_gew, 0 as plmi, type FROM stats WHERE team = 13 AND season = 2020 AND type = 'L' AND player not in ( SELECT player.id FROM gamestats join games on games.id = gamestats.game join player on player.id = gamestats.player where YEAR(games.date) = '2020' and games.type = 'L' and games.team = 13 group by player, YEAR(games.date), games.type, games.teamname) UNION ALL SELECT 0 as id, player.id as player, player.name as name, player.number as nummer, games.team as team, games.teamname as teamname, GetPositionByYearAndPlayer(player.id, YEAR(games.date), games.type, games.team) as position, count(*) as games, sum(gamestats.goals) as goals, sum(assist) as assist, sum(pm) as pm, sum(gamestats.mins) as mins, sum(gamestats.ga) as ga, sum(gamestats.shots) as shots, YEAR(games.date) as season, sum(gamestats.gwg) as gwg, sum(gamestats.gtg) as gtg, sum(gamestats.ppg) as ppg, sum(gamestats.shg) as shg, sum(gamestats.bullies) as bullies, sum(gamestats.bullies_gew) as bullies_gew, sum(plmi) as plmi, games.type FROM gamestats join games on games.id = gamestats.game join player on player.id = gamestats.player where YEAR(games.date) = '2020' and games.type = 'L' and games.team = 13 group by player, YEAR(games.date), games.type, games.teamname ORDER BY sp DESC, goals+assist DESC, goals DESC, games DESC, plmi, nummer DESC