DECLARE @UserId int = ##UserId## SELECT p.Id AS [Post L...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Enter Query Title
-- Enter Query Description

DECLARE @UserId int = ##UserId##

SELECT p.Id AS [Post Link]
    FROM Posts p
    WHERE p.OwnerUserId != @UserId
      AND p.LastEditorUserId = @UserId
      AND p.Id IN (SELECT DISTINCT h.PostId AS Id
                       FROM PostHistory h
                       WHERE p.Id = h.PostId
                         AND p.OwnerUserId != @UserId
                         AND h.UserId = @UserId)
    ORDER BY p.Id DESC

Enter Parameters

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