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

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