6

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

select
 p.OwnerUserId as [User Link],
 p.Id as [Post Link],
 p.Score
from Posts p
inner join Posts q on q.Id = p.ParentID
where p.PostTypeId = 2 and p.Score > 5
and q.Score > 3 and q.AnswerCount = 1
and q.AcceptedAnswerId = p.Id

fork query

created jul 31 10 Simon Brown