Monthwise streaks in a tag


Please login or register to vote for this query.

(click on this box to dismiss)

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

select Z.[Month] [Month], count(Z.ouid) PostCount, Z.ouid as [User Link] 
select CAST(
      cast(DATEPART(YYYY, Y.CreationDate) as varchar) + '-' + cast(DATEPART(MM, Y.CreationDate) as varchar) + '-01'
      as datetime) [Month], ouid
  from (
   select p1.creationdate  CreationDate ,p1.owneruserid  ouid from posts p1
      inner join posts p2  on 
      where p1.posttypeid=2 and (p2.tags like '%##TagName?string-theory##%')  group by p1.owneruserid, p1.creationdate
  ) Y group by ouid, CreationDate
) Z group by Z.ouid,Z.[Month] order by PostCount desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results