Data Export for the research project of http://twitter.com/se_statistics
Q&A about the site for professionals and students of engineering
select top 30 p.Id as antwort_id, q.Id as frage_id, p.Id as [Post Link], p.Body, p.Score, q.Body as Question, q.AnswerCount, p.CreationDate from Posts as p join Posts as q on (select top 1 Id from posts where parentId = q.Id) = p.Id -- only answers and p.CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 months old and p.LastEditDate < DATEADD(month, -3, GETDATE()) -- at least 3 months untouched and LEN(p.Body) > 550 -- more than 450 chars used (TODO: striptags) 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) and p.Score >= 3