Most recent tag wiki/excerpt suggestions with number of upvotes, user suggestions, etc PTId: Post Type Id 4: Excerpt 5: Wiki
Q&A for professional and enthusiast programmers
select top 250 s.Id as [Suggested Edit Link], t.TagName, p.PostTypeId as [PTId], s.CreationDate, (case when s.ApprovalDate is not null then s.ApprovalDate else s.RejectionDate end) as [A/R Date], u.Id as [User Link], u.Reputation, s.Comment from SuggestedEdits s inner join Posts p on s.PostId=p.Id inner join Users u on u.Id = s.OwnerUserId inner join Tags t on (t.ExcerptPostId = p.Id OR t.WikiPostId = p.Id) where (p.PostTypeId=4 OR p.PostTypeId=5) order by s.CreationDate desc