Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for participants in team and individual sport activities

--select top 10 * from posts answer
--inner join posts question
--on answer.parentid = question.id and question.parentid is not null 
--and answer.posttypeid = 2
--and ps.AcceptedAnswerId is not null
--where posttypeid = 2 

select top 10 parentid  from posts where id in (
SELECT a.parentid  FROM posts a
inner join posts question 
on a.parentid = question.id
where a.posttypeid = 2 and a.parentid is not null 
) and AcceptedAnswerId is not null

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results