Q&A for professional and enthusiast programmers
-- How close are you to getting the Archaeologist badge? -- "Edited 100 posts that were inactive for 6 months" DECLARE @UserId int = ##UserId## SELECT distinct p.Id AS [Post Link], p.CreationDate, p.LastEditDate FROM Posts p --INNER JOIN Posts a on a.ParentId = p.Id WHERE p.LastEditDate > DATEADD(month, 6, p.CreationDate) and p.LastEditorUserId = @UserId and p.OwnerUserId <> @UserId ORDER BY p.LastEditDate desc