Pizza time

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT pa.Id AS [Post Link]
  FROM Posts AS q
  INNER JOIN Posts AS aa
    ON q.AcceptedAnswerId = aa.Id
  INNER JOIN Votes AS v
    ON v.PostId = aa.Id
   AND v.VoteTypeID = 1
  INNER JOIN Posts AS pa
    ON pa.ParentId = q.Id
   AND pa.CreationDate > v.CreationDate -- posted after an answer has been accepted
   AND pa.Id != aa.Id
   AND pa.CreationDate >= '2018-12-12' -- Winter Bash start
   AND pa.Score = 2 -- one vote away from being awarded the Pizza hat

Enter Parameters

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