Data Explorer: Suggested Edits: Group by Review Types per User

Question

Using the Stack Exchange Data Explorer for Stack Overflow, I’m looking for aggregated counts of review tasks (suggested edits) per user, but I’ve lost track of the tables involved (ReviewTaskResults, SuggestedEditVotes, etc.). I can’t imagine the base query is that hard to compose.

How to get all completed approved/rejected/improved edit suggestion reviews a user has done?

Answer 1

I think this query is what you are after:

DECLARE @UserId int = ##UserId##

select top 10
       rtk.Id [Review Id]
,      sed.Id [Suggested Edit Link]
,      sed.PostId [Post Link]
,      rtt.Name [Review End Result]
,      vte.Name [Your Vote]
from   ReviewTaskResults rtr
join   ReviewTaskResultTypes rtt
on     rtr.ReviewTaskResultTypeId = rtt.Id
join   ReviewTasks rtk
on     rtr.ReviewTaskId = rtk.Id
join   SuggestedEdits sed
on     sed.Id = rtk.SuggestedEditId
join   SuggestedEditVotes sev
on     sev.SuggestedEditId = sed.Id
join   VoteTypes vte
on     sev.VoteTypeId = vte.Id
where  sev.UserId = @UserId

It gets all suggested edits votes of you and joins that with the end result of the review task and your vote on it.

I would suggest to try this query on a low-traffic site since it will blow up the database using SO.