0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows most recent 100 suggested edits from all users that were rejected by the reviewers.

プログラマーとプログラミングに熱心な人々のための質問と回答

-- Most recent rejected edits
-- Shows most recent 100 suggested edits from all users that were rejected by the reviewers.
-- Works for all StackExchange sites

select top 100 'site://suggested-edits/'+CONVERT(VARCHAR,id)+'|Suggested Edit #'+CONVERT(VARCHAR,id) [Suggested Edit Link], 
        PostId as [Post Link], Comment, CreationDate, RejectionDate
 from SuggestedEdits 
 where RejectionDate is not null
 order by RejectionDate desc

fork query

edited jul 22 12 JackieChiles

created aug 31 11 Idolon