Edits to your answers or their questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT a.Id AS [Post Link], a.LastEditDate, 'Your answer'
  FROM Posts AS a
  WHERE a.OwnerUserId = ##UserId:int##
    AND a.PostTypeId = 2 -- Answer
    AND a.LastEditDate != a.CreationDate
  
UNION ALL

SELECT q.Id AS [Post Link], q.LastEditDate, 'Question you''ve answered'
  FROM Posts AS a
  INNER JOIN Posts AS q
    ON a.ParentId = q.Id    
  WHERE a.OwnerUserId = ##UserId:int##
    AND q.LastEditDate != q.CreationDate

ORDER BY 2 DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results