Men's Club Soccer Standings

Error in query: SELECT @rownum:=@rownum+1 'row', div_num, team_num, team_name, cap_name, cap_color, games_played, win, loss, draw, goals_for, goals_against, plus_minus, points, rank, team_group FROM standings, (SELECT @rownum:=0) r ORDER BY points DESC, plus_minus DESC, goals_for DESC, goals_against asc, team_group, div_num, team_num. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', team_group FROM standings, (SELECT @rownum:=0) r ORDER BY poin' at line 1