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 2

select t.*,st.ext,st.sprite from cup2010_final_standings t inner join cup2010_states st on st.state_id = t.state_id where t.zone_id=5 and t.round_id=1 and t.group_id= order by POINTS desc,GOALS_DIFFERENCE desc