Close reviews of posts tagged as homework

0

Please login or register to vote for this query.

(click on this box to dismiss)

Theoretical Computer Science

Q&A for theoretical computer scientists and researchers in related fields

SELECT TOP 1000
  Posts.Id AS [Post Link],
  'https://physics.stackexchange.com/review/close/'+CAST(ReviewTasks.Id AS varchar)+'|Link' AS 'Review Link',
  Posts.ClosedDate,
  ReviewTasks.CreationDate,
  Posts.Tags
FROM ReviewTasks
JOIN Posts ON Posts.Id = ReviewTasks.PostId
WHERE ReviewTaskTypeId = 2 -- close votes
  AND Posts.Tags LIKE '%<homework-and-exercises>%'
ORDER BY ReviewTasks.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results