Most upvoted and most late posted first-answers

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

SELECT TOP 100
  A.Id AS [Post Link],
  Q.CreationDate AS QCreationDate,
  A.CreationDate AS ACreationDate,
  Q.Score AS QScore,
  A.Score AS AScore,
  CAST(DATEDIFF(s, Q.CreationDate, A.CreationDate) AS BIGINT) * A.Score
    AS Oops
FROM PostsWithDeleted Q, PostsWithDeleted A
WHERE
  A.ParentId = Q.Id
  AND
  A.CreationDate > Q.CreationDate
  AND
  A.Id IN (
    SELECT MIN(Id)
    FROM PostsWithDeleted
    WHERE ParentId IS NOT NULL
    GROUP BY ParentId
  )
ORDER BY
  Oops DESC, A.Id

Enter Parameters

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