Top edit suggesters

1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the number of accepted edit suggestions for each user, and plots the result.

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

-- 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 to main site
loading Hold tight while we fetch your results