Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
DECLARE @UserIdParam AS INT = ##UserIdParam:int?6309## SELECT P.LastEditDate, P.Id AS [Post Link] FROM Posts P JOIN Posts Q ON Q.Id = P.ParentId JOIN PostHistory H ON H.PostId = P.Id WHERE P.LastEditorUserId = @UserIdParam AND P.PostTypeId = 2 -- answers AND P.LastEditDate > '11-30-2022' AND H.PostHistoryTypeId IN (5) -- 2: initial body, 5: edit body, 8: rollback body ORDER BY P.LastEditDate DESC; ;