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


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.... ;)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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

select as qID, as eID
into #q from posts q left outer join #tagsedited e on
  q.creationdate >=dateadd(MM,0-##MonthsBack:int?3##,getdate())
  and q.posttypeid=1
  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

Switch sites:
loading Hold tight while we fetch your results