SELECT PostNotices.Id, Posts.PostTypeId, PostNotices.Owne...

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
PostNotices.Id, Posts.PostTypeId, PostNotices.OwnerUserId, PostNotices.DeletionUserId
FROM
Posts, PostNotices
WHERE 
PostNotices.PostId = Posts.Id
AND PostNotices.DeletionDate IS NOT NULL
AND DeletionUserId IN (13531, 102937,106224,16587,19679,59303,168175,707111,
256196,229044,100297,1252759,3093387,871050,1849664,476,541136,4099593,189134,
366904,3956566,584192,563532,2057919)
AND DeletionUserId != PostNotices.OwnerUserId

Enter Parameters

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