Page not found

Error in query:
SELECT n.`ID`, n.`Title`, n.`IsFavourite`, a.`EntityID`, SUM(a.`HitCount`) HitCount FROM `e2BlogActions` a, `e2BlogNotes` n WHERE a.`Stamp` > 1709046250 AND a.`EntityID` = n.`ID` GROUP BY a.`EntityID` ORDER BY `IsFavourite` DESC, HitCount DESC LIMIT 10
Unknown column 'a.HitCount' in 'field list'