How many questions were re-tagged in the last 3 months?

1

Please login or register to vote for this query.

(click on this box to dismiss)

I hope you realize that every tag-based report or query on any SE site, is based largely on what often-self-proclaimed-clueless-OPs decide to randomly tag their question.... ;)

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

select distinct postid as id
into #tagsedited from posthistory
where PostHistoryTypeId=6 
 and creationdate >=dateadd(MM,0-##MonthsBack:int?3##,getdate())

select 
  q.id as qID, 
  e.id as eID
into #q from posts q left outer join #tagsedited e on q.id=e.id
where
  q.creationdate >=dateadd(MM,0-##MonthsBack:int?3##,getdate())
  and q.posttypeid=1
  
select
  count(1) as [# Questions],
  sum(case when eID is not null then 1 else 0 end) as [# Re-tagged],
  format(1.0*sum(case when eID is not null then 1 else 0 end)/count(1),'0%') as [% Re-tagged]
from #q

--MonthsBack:Months before today to include in query

Enter Parameters

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