Least used tags since 2015-01-01

0

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications

Q&A for power users of web applications

SELECT TOP 100 t.TagName, t.Count, MIN(p.CreationDate)
FROM           TAGS t
JOIN           PostTags pt ON t.Id = pt.TagId
JOIN           Posts p ON p.Id = pt.PostId
WHERE          t.Count <= 3 AND p.CreationDate > ' 2015-01-01'
GROUP BY       t.TagName, t.Count
ORDER BY       MIN(p.CreationDate)

Enter Parameters

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