select top(1000) SuggestedEdits.PostId as [Post Link], Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Server Fault

Q&A about the site for system and network administrators

select top(1000) 
  SuggestedEdits.PostId as [Post Link], 
  Posts.CreationDate as PostCreationDate, 
  Posts.ViewCount, 
  Posts.PostTypeId,
  Posts.OwnerUserId as Poster,
  SuggestedEdits.OwnerUserId as Editor, 
  Posters.Reputation as PosterRep,
  Editors.Reputation as EditorRep,
  Posts.ParentId as Parent, 
  SuggestedEdits.* 
from 
  SuggestedEdits, Posts, Users as Editors, Users as Posters 
where 
  SuggestedEdits.PostId = Posts.Id 
  and SuggestedEdits.OwnerUserId <> Posts.OwnerUserId
  and (SuggestedEdits.ApprovalDate IS NOT NULL or SuggestedEdits.RejectionDate IS NOT NULL)
  and Posts.PostTypeId = 1
  and Editors.Id = SuggestedEdits.OwnerUserId
  and Posters.Id = Posts.OwnerUserId
order by 
  SuggestedEdits.CreationDate DESC
--  Posts.ViewCount DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results