select Tags.TagName, Tags.Count from Tags, Posts where Ta...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

-- Return Tag Name for the final results
select Tags.TagName, Tags.Count
from Tags, Posts
where Tags.Id in (
  -- Return Tag Ids associated with Posts
  select Distinct PostTags.TagId
  from PostTags
  inner join Posts
    on PostTags.PostId = Posts.Id
  -- Filtering
  where Year(Posts.CreationDate) = '2017' and Posts.Tags is not null
)

order by Tags.Count DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results