2

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

Q&A for Ubuntu users and developers

select top 100  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 inner join Posts as q on
(select top 1 parentId from posts where parentId = q.Id) = p.parentId -- 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
and p.Id IS NOT NULL

view current version

edited mar 24 12

created feb 15 12 giraff