0

Please login or register to vote for this query.

(click on this box to dismiss)

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 LIKE '%dnd-5e%'

fork query

edited may 21

created dec 12 16 anonymous