List of all moderator election nominations, network-wide

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

WITH Raw AS (
  SELECT
    LAG(CreationDate) OVER (ORDER BY CreationDate) AS PrevCrDate,
    *
  FROM Posts
  WHERE PostTypeId = 6
)
SELECT
  SUM(
    CASE
      WHEN
        PrevCrDate IS NULL
        OR
        DATEDIFF(day, PrevCrDate, CreationDate) > 30
      THEN
        1
      ELSE 0
    END
  ) OVER (ORDER BY CreationDate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Id,
  *
FROM Raw
ORDER BY CreationDate

Enter Parameters

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