Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Count the number of "new" posts in a tagged topic on StackOverflow over a time period

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

Select
  count(*) as [Count]
From
  PostHistory as TagChange
Where
  PostHistoryTypeId in (3)  -- initial tags
  and Text like '%<' + ##TagName:string## + '>%'
  and CreationDate < ##DateBefore:string?9999-12-31##
  and CreationDate > ##DateAfter:string?9999-12-31##
  and not exists(
    Select 1 From PostHistory as NewChange
    Where NewChange.PostId = TagChange.PostId
      and PostHistoryTypeId in (3)
      and NewChange.CreationDate > TagChange.CreationDate
      and NewChange.CreationDate < ##DateBefore:string?9999-12-31##
  )

Enter Parameters

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