гг, археологи
я могу ошибаться, а разве так не работает?
select * from tablename order by name and order by count desc limit 10;
или
select * from tablename order by name && order by count desc limit 10;

__________________
God forgive me for I have sinned
It’s been six months since my last confession
There is nowhere that I can run to
My soul I place in your hands