1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the number of edits a specific user has made.

Q&A for anime and manga fans

-- Number of Edits
-- Shows the number of edits a specific user has made.

DECLARE @UserId int = ##UserId##

SELECT
(
  SELECT COUNT(*) FROM posts WHERE
    LastEditorUserId = @UserId AND
    OwnerUserId != @UserId AND
    PostTypeId = 1
) AS 'Question Edits',
(
  SELECT COUNT(*) FROM posts WHERE
    LastEditorUserId = @UserId AND
    OwnerUserId != @UserId AND
    PostTypeId = 2
) AS 'Answer Edits',
(
  SELECT COUNT(*) FROM posts WHERE
    LastEditorUserId = @UserId AND
    OwnerUserId != @UserId
) AS 'Total Edits'

fork query

created sep 4 11 Muntoo