Q&A for professional and enthusiast programmers
select top(9) p.id as [Post Link], p2.score, p2.body from posts as p
join posts as p2 on p2.parentid = p.id
where p2.id in (
select top(3) id
where posttypeid = 2 and parentid = p.id
order by score desc
and p.title like '%test%function%'
and p.answercount > 10
and p.tags like '%python%'
order by p.id asc, p2.score desc;