Errore select

SELECT testo, titolo FROM contenuto_plug WHERE id_tipo_plug = :id_tipo_plug AND id_contenuto = :id_contenuto AND id_lingua = :id_lingua ORDER BY identificativo DESC, ordine, id ASC ASC LIMIT 0, 1

Array ( [0] => 42000 [1] => 1064 [2] => 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 'ASC LIMIT 0, 1' at line 1 )