An Error Was Encountered

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 'AA = 2006 and AND (NOME_SC='i1') Group By C_CLASSE_M order by SEMESTRE' at line 3

SELECT * FROM guida_aggrega WHERE K_CORSO_LA='1133' and AC='2' AA = 2006 and AND (NOME_SC='i1') Group By C_CLASSE_M order by SEMESTRE