Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Count the number of posts in the [twitter] topic on StackOverflow over a time period

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

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