Профиль пользователя Ангелина (korobochka82)

query:
select distinct tag, count(tag) as tag_count from link_tags t INNER JOIN tags using (tagid) where t.userid='509777' and t.status='ALL' group by tag order by count(tag) desc limit 10;