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

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