Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

Select
  count(*) as [Count]
From
  PostHistory as TagChange
Where
  PostHistoryTypeId in (3,6,9)  -- initial/edit/rollback 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,6,9)
      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