Most popular StackOverflow tags in May 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select count(distinct PostId) as Rate, 
    'StackOverflow' as source,
    'java' as tag,
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and tagName in ( 'java', 'java-me', 'java-ee', 'javafx', 'javafx-2')
group by  dateadd(month, datediff(month, 0, Posts.CreationDate),0) 

union
select count(distinct PostId) as Rate, 
    'StackOverflow' as source,
    'python' as tag,
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and (tagName like 'python%' or tagname like 'django')
group by  dateadd(month, datediff(month, 0, Posts.CreationDate),0) 

union
select count(distinct PostId) as Rate, 
    'StackOverflow' as source,
    '.net' as tag,
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and (tagName like '.net' or tagname like 'C#' or tagname like 'VB%NET')
group by  dateadd(month, datediff(month, 0, Posts.CreationDate),0) 

union
select count(distinct PostId) as Rate, 
    'StackOverflow' as source,
    'php' as tag,
    dateadd(month, datediff(month, 0, Posts.CreationDate),0) 
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2010-01-01'
and (tagName like 'php%' or tagName like 'zend-framework' or tagName like 'codeigniter' )
group by  dateadd(month, datediff(month, 0, Posts.CreationDate),0)

Enter Parameters

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