Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
select a.id as [Post Link], users.displayname, a.score from posts a join users on a.owneruserid = users.id where (score between 7 and 9) and a.posttypeid = 2 and a.deletiondate is null and a.closeddate is null and a.communityowneddate is null and exists (select id from posts q where q.acceptedanswerid = a.id) and a.creationDate in (select min(creationDate) from posts otherAs where parentid = a.parentid) order by displayname, score desc