0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

select p.Id [Post Link]
from Posts p
where p.PostTypeId = 2
and not p.Id in
  (select v.PostId
  from Votes v
  where v.PostId = p.Id and (v.VoteTypeId = 2 or v.VoteTypeId = 3))
and p.ParentId in (select p1.Id from Posts p1 where p1.AnswerCount = 1)
and p.Id = '147912'

fork query

edited dec 17 17

created dec 17 17 anonymous