0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Tridion developers and administrators

-- Most popular StackOverflow tags in May 2010

select 
       rate.TagName as Tag,
       rate.CreationDate,
       rate.Rate as Questions

from

(select count(PostId) as Rate, TagName,cast(CreationDate as date) as CreationDate
from
Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate < '2022-06-01'
and Posts.CreationDate > '2022-05-01'
group by TagName,cast(CreationDate as date)) as rate

INNER JOIN

(select count(PostId) as Num, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
group by TagName
having count(PostId) > 100)
as num ON rate.TagName = num.TagName
order by rate.rate desc
;

fork query

edited may 20 anonymous

created jun 16 10 lukasz.lew