Профиль пользователя Игорь (Zhikin115)

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