Qual o erro aqui?

FROM partida status tb_21_06_2007 WHERE ID BETWEEN 1 AND 10 ORDER BY ID ASC

por favor nao consigo axar o erro nessa linha,alguem sabe?O ERRO:

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 'tb_21_06_2007 WHERE ID BETWEEN 1 AND 10 ORDER BY ID ASC' at line 20