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
  CASE
    WHEN
      PrevCrDate IS NULL
      OR
      DATEDIFF(day, PrevCrDate, CreationDate) BETWEEN 0 AND 30
    THEN
      CreationDate
    ELSE NULL
  END AS Tmp,
  *
FROM Raw
ORDER BY CreationDate

Enter Parameters

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