1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

SELECT
    voters.Id AS [User Link],
    COUNT(*)  AS [Number of Posts]
FROM
    PostHistory AS ph
        CROSS APPLY OPENJSON(ph.Text, '$.Voters') WITH (Id INTEGER '$.Id') voters
        CROSS APPLY OPENJSON(ph.Text, '$.OriginalQuestionIds') qid
WHERE
    ph.PostHistoryTypeId = 10 AND
    qid.value = ##DupeTargetId:int##
GROUP BY voters.Id
ORDER BY [Number of Posts] DESC

fork query

created aug 25 Henry.Ecker