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 p.Id as antwort_id, q.Id as frage_id, p.Body, p.Score,
--, p.Id as [Post Link]
from Posts as p join Posts as q on p.Id =
(select top 1 Id from posts where parentId = q.Id 
and CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 months old
and LastEditDate < DATEADD(month, -3, GETDATE()) -- at least 3 months untouched
and LEN(Body) > 450 -- more than 450 chars used (TODO: striptags)
and Score >= 0 -- Score >= 3
ORDER BY NEWID())  -- only answers
and q.ClosedDate IS NULL and p.CommunityOwnedDate IS NULL -- not closed, not community wiki
and q.AnswerCount <= 10 -- not more than 30 answers (pagination)

Enter Parameters

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