Posts with its questions


Please login or register to vote for this query.

(click on this box to dismiss)

Data Export for the research project of

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

select top 300 p.Id as antwort_id, p.Id as [Post Link], p.Body, q.Body as Question, p.Score,
p.CreationDate, q.ClosedDate, p.CommunityOwnedDate
from Posts as p, Posts as q
where p.parentId = q.Id -- only answers
and p.CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 month old
and p.LastEditDate < DATEADD(week, -1, GETDATE()) -- at least 1 month untouched
and LEN(p.Body) > 450 -- more than 450 chars used (TODO: striptags)
and q.ClosedDate IS NULL and p.CommunityOwnedDate IS NULL -- not closed, not community wiki

Enter Parameters

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