Initiated most closures as dupe

1

Please login or register to vote for this query.

(click on this box to dismiss)

The query *is not exact* on at least two reasons: 1) dupe closures initiated by flags aren't counted, the first actual close voter is counted instead 2) it is not sure that the first close voter voted for the post as dupe (he was just the first of the close-voters, whose majority of the voters voted for dupe).

Physics

Q&A for active researchers, academics and students of physics

WITH Raw AS (
  SELECT
    CAST(JSON_VALUE(Text, '$.Voters[0].Id') AS INTEGER) AS DupeCloser
  FROM PostHistory
  WHERE PostHistoryTypeId = 10 AND Comment IN (1,101)
)
SELECT
  DupeCloser AS [User Link],
  DupeCloser AS UserId,
  COUNT(*) AS Count
FROM Raw
GROUP BY DupeCloser
ORDER BY Count DESC, UserId

Enter Parameters

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