Answers to investigate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find answers that are either accepted or top-voted and that have at least one comment with at least one of the following words: "security", "vulnerability", "race".

Stack Overflow

Q&A for professional and enthusiast programmers

select
  a.Id as [Post Link],
  c.text as [Reason]
from
    Posts q
  inner join
    Posts a
  on (a.ParentId = q.Id)
  inner join
    Comments c
  on (c.PostId = a.Id)
where
a.id > 20000000
and
a.id <= 30000000
and
((a.Id = q.AcceptedAnswerId) or (a.Score = (
            SELECT TOP 1 Score
                FROM Posts otherA
                WHERE
                    otherA.ParentId = q.Id
                ORDER BY Score DESC))
)
and a.score > 10 -- limit to answers that have been more likely to receive some scrutiny
and c.UserId != a.OwnerUserId -- while possible that an answerer would have noticed an issue with his answer, adding this removed a lot of noise
and ((Upper(c.text) LIKE Upper('%race%'))
or (Upper(c.text) LIKE Upper('%security%'))
or (Upper(c.text) LIKE Upper('%vulnerability%')))
-- couldn't find a string that would have been indicative of a Y2k-like issue
;

Enter Parameters

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