Data Export for the research project of http://twitter.com/se_statistics
Q&A for scientists using computers to solve scientific problems
select top 100 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 = "" -- not closed, not community wiki