Your Edit Reviews

2

Please login or register to vote for this query.

(click on this box to dismiss)

Shows you how many times you approved and the edit got approved, you rejected but the edit got approved, you approved but the edit got rejected, and you rejected and the edit got rejected.

Stack Overflow

Q&A for programmers

SELECT
    COUNT(*) AS [Count],
    CASE WHEN VoteTypeId = 3 THEN 'Rejected' WHEN VoteTypeId = 2 THEN 'Approved' ELSE 'Edited/other' END AS 'You...',
    CASE WHEN ApprovalDate IS NULL THEN 'Rejected' ELSE 'Approved' END AS 'They...'
FROM
    SuggestedEditVotes
    INNER JOIN SuggestedEdits ON SuggestedEdits.Id = SuggestedEditVotes.SuggestedEditId
WHERE
    SuggestedEditVotes.UserId = ##UserId##
GROUP BY
    VoteTypeId,
    CASE WHEN ApprovalDate IS NULL THEN 'Rejected' ELSE 'Approved' END

Enter Parameters

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