Posts with its questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Data Export for the research project of http://twitter.com/se_statistics

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select top 10 q.PostTypeId,q.Title,q.Tags,q.Score,q.AnswerCount,'answer:',a.PostTypeId,a.Tags,a.Body,a.Score,a.AnswerCount 
from posts as q
left join posts as a on a.ParentId = q.id
where q.PostTypeId = 1

select * from (
select top 10 q.PostTypeId,q.Title,q.Tags,q.Score,q.AnswerCount
from posts as q
left join(
select top 10 'answer:'s,q.PostTypeId,q.Tags,q.Body,q.Score,q.AnswerCount 
from posts as q
where q.PostTypeId = 2
and ParentId =1)as f on 1=1
where q.PostTypeId = 1
) as a

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results