0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

SELECT Posts.Id AS [Post Link]
FROM Posts
JOIN PostTypes
ON Posts.PostTypeId = PostTypes.Id
WHERE PostTypes.Name = 'Question'
AND Posts.Score < 5
AND Posts.ViewCount < 200
AND Posts.ClosedDate IS NOT NULL
AND Posts.LastEditDate < DATEADD(year,-1,GETDATE())

fork query

edited jul 20 12

created jul 20 12 C. Ross