1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

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

fork query

edited mar 31

created mar 31 peterh - PLEASE DELETE THIS ACCOUNT