SQL запрос.

[execution]

Хочу сделать, чтобы не выводилось повторяющихся ид (TargetID) и сортировалось с конца по ид ячейки в таблице (ID)

Сделал так:

SELECT * FROM `PhoneMessageHistory` WHERE `PlayerID` = '%d' AND GROUP BY `TargetID` HAVING COUNT (*) = 1 ORDER BY `ID` DESC LIMIT 10

Почему-то вылазит ошибка:

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 'GROUP BY `TargetID` HAVING COUNT (*) = 1 ORDER BY `ID` DESC LIMIT 10' at line 1, SelectPhoneMessageHistory, SELECT * FROM `PhoneMessageHistory` WHERE `PlayerID` = '171' AND GROUP BY `TargetID` HAVING COUNT (*) = 1 ORDER BY `ID` DESC LIMIT 10, 1