select 域名, count(域名)
from table
group by 域名
order by count(域名）desc
limit 10
