0

Please login or register to vote for this query.

(click on this box to dismiss)

This query return a list of answers which are not yet accepted and scored Zero votes

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

SELECT 
  ROW_NUMBER() over(ORDER BY Answers.Id ASC) as [#],
  Answers.Id as [Post Link]
FROM

  Posts Qestions
INNER JOIN
  Posts Answers
ON
  Answers.ParentId = Qestions.Id
WHERE
  Answers.OwnerUserId = 12578202
  and Answers.Score=0
  and Qestions.AcceptedAnswerId is null
  and Qestions.Id not in (
    63156884, 63510041, 63413561, 60095510, 63913377, 63943120, 64131842,
    64034016, 63629935, 64109840, 58325857, 64602770, 64611388
    )
ORDER BY Answers.CreationDate ASC
;

fork query

edited nov 3 20

created aug 28 20 arakkal_abu