SELECT Id AS [Post Link], AcceptedAnswerId, CreationDate,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT 
  Id AS [Post Link], 
  AcceptedAnswerId, 
  CreationDate, 
  Score, 
  ViewCount, 
  AnswerCount, 
  LastActivityDate
FROM 
  POSTS AS q
  
WHERE 
  CLOSEDDATE IS NOT NULL
  AND DeletionDate IS NULL
  AND SCORE <= -3
  AND AnswerCount > 0
ORDER BY LastActivityDate DESC

Enter Parameters

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