Omlouvam se, ja zapomnel,ze mySQL tam potrebuje alias...

Kód:
select tabulka.id,sum(tabulka.pocet) celkem from tabulka group by tabulka.id order by celkem desc limit 3;