select top 25 tagname , count(*) from posts as p inner...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Psychology and Neuroscience

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results