select A.Score + sum(B.Score) , A.Title , A.Body, B.Body ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select A.Score + sum(B.Score) , A.Title , A.Body, B.Body from Posts A, Posts B 
where A.Id = B.ParentId 
and A.PostTypeId = 1 and B.PostTypeId = 2  
group by A.Id, A.Score , A.Title , A.Body, B.Body having A.Score + sum(B.Score) > 1
order by A.Score + sum(B.Score) desc

Enter Parameters

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