/* select Tags.TagName, Tags.Count from Tags, Posts where...

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 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
*/

-- 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

Enter Parameters

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