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

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select p.Id as [Post Link], p.Body, p.Score, p.parentId, q.Body
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)

Enter Parameters

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