Questions Never Edited By Owner After Closing

0

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 COUNT(DISTINCT(p.Id))
FROM Posts p INNER JOIN PostHistory ph ON p.Id = ph.PostId
WHERE 
p.ClosedDate IS NOT NULL AND
p.OwnerUserId NOT IN ( SELECT UserId 
                       FROM PostHistory ph 
                       WHERE ph.PostId = p.Id 
                       AND ph.PostHistoryTypeId IN ( 4,5,6 ) )

Enter Parameters

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