Ever undeleted not-owned post single-handedly

1

Please login or register to vote for this query.

(click on this box to dismiss)

Only mods can do that.

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

SELECT DISTINCT PostHistory.UserId AS [User Link]
FROM PostHistory, Posts
WHERE
  PostHistory.PostId = Posts.Id
  AND
  PostHistory.UserId <> Posts.OwnerUserId
  AND
  Posts.OwnerUserId > 0
  AND
  PostHistory.UserId > 0
  AND
  PostHistory.PostHistoryTypeId = 13
  AND
  PostHistory.Text NOT LIKE '%},{%';

Enter Parameters

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