query question, get top python answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select top(15) p.id,p2.id as "answer_id",p.AcceptedAnswerId as "accepted_id",
p.answercount,p.commentcount,p.tags,p.title,
p.CreationDate as "question_created",p2.CreationDate as "answer_created",
p.score as "question_score",p2.score as "answer_score",
p.body as "question_body",p2.body as "answer_body" from posts as p
join posts as p2 on p2.parentid = p.id
where p2.id in (
    select top(3) id
    from posts
    where posttypeid = 2 and parentid = p.id
    order by score desc
  )
  and p.title like '%language%process%'
  and p.tags like '%python%'
  order by p.id asc, p2.score desc;

Enter Parameters

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