0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select
    count(Posts.Id) tag_count,
    Tags.TagName,
    Tags.Id
from
    Tags
    join PostTags on Tags.Id = PostTags.PostId
    join Posts on PostTags.TagId = Posts.Id
where
    year(Posts.CreationDate) = 2018
    and Posts.ParentId is null
    and Posts.DeletionDate is null
    and Tags.Id = 16
group by
    Tags.TagName,
    Tags.Id
order by
    tag_count desc

fork query

edited jan 16 19 anonymous

created jan 15 19 Zvonimir Ilić