Merged questions between given dates

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

--Merged questions between given dates
SELECT 
  ph.CreationDate,
  ph.PostHistoryTypeId,
  p.Id AS [Post Link],
  concat('site://posts/',
          p.Id,
          '/revisions'
          ) [Revisions Link]
FROM PostHistory ph INNER JOIN Posts p
  ON ph.PostId=p.Id
  AND ph.PostHistoryTypeId IN (18,22,37,38)
  AND p.PostTypeId=1
WHERE ph.CreationDate>='##Date1##' and ph.CreationDate<='##Date2##'  
ORDER BY ph.CreationDate DESC

--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 sites:
loading Hold tight while we fetch your results