Number of merged questions per month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

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

SELECT
  eomonth(ph.CreationDate),
  COUNT(DISTINCT p.Id)
FROM PostHistory ph INNER JOIN Posts p
  ON ph.PostId=p.Id
  AND ph.PostHistoryTypeId IN (18,22,37,38)
  AND p.PostTypeId=1
GROUP BY eomonth(ph.CreationDate)
ORDER BY eomonth(ph.CreationDate)

--18 = Question Merged - question merged with deleted question
--22 = Question Unmerged - answers/votes restored to previously merged question
--37 = Post merge source
--38 = Post merge destination

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results