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

-- Answer posts
select Id as [Post Link], Body, Score, parentId
from Posts
where parentId != 0 
and CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 month old
--and LastEditDate < DATEADD(week, -1, GETDATE()) -- at least 1 month untouched
and LEN(Body) > 450 -- more than 450 chars used (TODO: striptags)

view current version

edited feb 15 12

created feb 15 12 giraff