*Some* of the cases where LastEditor is blank and not the same as OP

1

Please login or register to vote for this query.

(click on this box to dismiss)

This query probably misses the scenario where both the OP and the last editor are deleted, but are different deleted users. That hypothetical edge-case is not important to the *current* issue under discussion.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
        p.Id AS [Post Link]
        , LastEditDate
FROM
        Posts p
WHERE
        p.LastEditDate      IS NOT NULL
AND     p.LastEditorUserId  IS NULL
AND     p.OwnerUserId       IS NOT NULL
ORDER BY
        p.LastEditDate DESC

Enter Parameters

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