A Database Error Occurred

Error Number: 1064

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 'order by points desc,goals_difference desc' at line 4

select t.*,st.state,st.name_eng,won*3+draw as points, goals_for-goals_againts as goals_difference,st.sprite from standings t inner join teams st on st.team_id = t.team_id where t.group_id= order by points desc,goals_difference desc