0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
  p.id as [Post Link],  p.tags, p.score, p.viewCount, p.answerCount, p.CreationDate
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%'
     and p.tags LIKE '%wizard%'
     and p.ClosedDate is NULL
     and p.answerCount = 4

fork query

edited may 26

created dec 12 16 anonymous