My accepted edits

18

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all my suggested edits that were accepted by the reviewers.

Literature

Q&A for scholars and enthusiasts of literature

-- My accepted edits
-- Shows all my suggested edits that were accepted by the reviewers.
-- Works for all StackExchange sites

DECLARE @site VARCHAR (500), @name VARCHAR(500)
DECLARE @idx_exported INT, @idx_meta INT, @idx_se INT
SET @name = db_name()
SET @site = 'stackoverflow'
SET @idx_exported = PATINDEX('%.Exported', @name)
SET @idx_meta = PATINDEX('%.Meta.%', @name)
SET @idx_se = PATINDEX('StackExchange.%', @name)
IF @idx_se = 1 
 IF @idx_meta = 0 SET @site=SUBSTRING(@name, 15, @idx_exported - 15) + '.stackexchange'
 ELSE SET @site='meta.' + SUBSTRING(@name, 15, @idx_meta - 15) + '.stackexchange'
ELSE 
 IF @idx_meta = 0 SET @site=SUBSTRING(@name, 1, @idx_exported - 1)
 ELSE SET @site='meta.' + SUBSTRING(@name, 1, @idx_meta - 1)

SET @site = 'http://' + LOWER(@site) + '.com'

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

Enter Parameters

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