0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

SELECT TOP 500
  q.Id as [Post Link],
  q.OwnerUserId as [User Link],
  a.Score as AnswerScore,
  q.Score as QuestionScore,
  q.AnswerCount+q.CommentCount as TotalAnswersAndComments
FROM 
  Posts q
INNER JOIN
  Posts a ON a.ParentId = q.Id
WHERE   
  a.OwnerUserID = q.OwnerUserId AND
  q.Score >= 0 AND
  a.Score > 0 AND
  a.CommunityOwnedDate is null AND 
  q.ClosedDate is null
  /*DATEDIFF(Day, q.CreationDate, a.CreationDate) < 2  */
  ORDER BY RAND()

fork query

created sep 30 20 anonymous