Posts edited after your comment

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.LastEditDate as [Edit Date], p.Id AS [Post Link], c.Text AS Comment FROM Posts p
INNER JOIN Comments c
ON c.PostId=p.Id
WHERE c.UserId=##UserId## AND c.CreationDate < p.LastEditDate 
ORDER BY p.LastEditDate DESC

Enter Parameters

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