Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select top 25 tagname , count(*) from posts as p inner join posttags as pt on pt.postid = p.id inner join tags as t on t.id = pt.tagid where owneruserid = 8707 group by tagname order by 2 desc