0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

select top 50000 p.id, p.body, p.score, p.viewcount, a.id, a.body, a.score, a.viewcount
from posts p
inner join (select * from posts where posttypeid = 2) as a
  on a.id = p.acceptedanswerid

where

p.id in (
  select postid
  from posttags
  where tagid = 243
)

and p.posttypeid = 1

order by p.id

fork query

edited mar 31

created mar 31 Shrayas