Answers which would be enlightened with one more upvote.
Q&A about the site for software quality control experts, automation engineers, and software testers
-- Unenlightened answers -- Answers which would be enlightened with one more upvote. select top 200 a.id "Post Link", a.creationdate, u.id "User Link", u.reputation from posts a inner join posts q on (a.parentid = q.id) inner join users u on (a.owneruserid = u.id) where a.posttypeid = 2 and a.score = 9 and a.id = q.acceptedanswerid --and a.communityowneddate is null and a.owneruserid != q.owneruserid and a.creationdate <= (select min(creationdate) from posts where parentid = a.parentid) order by u.reputation asc