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

Q&A for musicians, students, and enthusiasts

-- 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

fork query

edited sep 25 20 Dom

created jun 18 10 amarghosh