OPs of After-Closure Answers


Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

SELECT                                                            -- Select all answers posted after parent
  COUNT(*) AS [Total],                                            -- question closure, but before 4 hour mark
  CONCAT('site://u/', u.Id, '|', u.DisplayName) AS [Answer OP],   -- (since that's the cutoff, also excudes merged posts)
  u.Reputation AS [User Rep.],                                    -- Then group by user to get sums
  u.CreationDate AS [User Joined],
  u.Id AS [OP ID]
FROM Posts a
JOIN Posts q ON q.Id = a.ParentId
JOIN Users u ON u.Id = a.OwnerUserId
WHERE a.CreationDate > q.ClosedDate AND DATEDIFF(hour, q.ClosedDate, a.CreationDate) < 4
GROUP BY u.Id, u.DisplayName, u.Reputation, u.CreationDate
ORDER BY COUNT(*) DESC, u.DisplayName

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results