Down-voted accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Accepted answers with negative scores and more than 1000 views

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

-- Down-voted accepted answers
-- Accepted answers with negative scores and more than 1000 views

--DECLARE @userid int = ##UserID##

SELECT 
  answer.Score as 'Votes',
  answer.id as [Post Link], 
  question.ViewCount as 'Views' 
FROM 
  Posts question JOIN Posts answer ON question.AcceptedAnswerId = answer.Id
WHERE
  answer.Score < 0 AND question.ViewCount > 100
ORDER BY answer.Score ASC, question.ViewCount DESC

Enter Parameters

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