Delete candidates

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

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())

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results