Select old unedited posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT 
  p.id as [Post Link],  p.tags, p.score, p.viewCount, p.answerCount
FROM
     Posts p
LEFT JOIN
     Users u ON p.OwnerUserId = u.Id
WHERE
     p.ViewCount > 50
     AND
     p.LastEditorUserId IS NULL
     AND
     p.lastActivityDate < '2020.01.01'
     and p.tags = '%dnd-5e%'

Enter Parameters

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