Qualifying for Archaeologist badge progress


Please login or register to vote for this query.

(click on this box to dismiss)

exclude posts created by user

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

SELECT DISTINCT p.Id AS [Post ID], p.Id AS [Post Link], ph.CreationDate AS [Revision Date] 
FROM Posts p INNER JOIN PostHistory ph ON p.Id = ph.PostId
WHERE p.OwnerUserId != ##UserID##
  and (
  ph.PostHistoryTypeId IN (4,5) AND
  ph.UserID = ##UserID## AND
  DATEADD(MONTH, -6, ph.CreationDate) > ALL (
    SELECT pph.CreationDate FROM PostHistory pph WHERE (
      ph.PostID = pph.PostID AND
      ph.CreationDate > pph.CreationDate
ORDER BY ph.CreationDate DESC

Enter Parameters

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