0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

SELECT t.TagName, p.Title, p.Body 
FROM Posts p, PostTypes pty, PostTags pta, Tags t
WHERE p.PostTypeId = pty.Id
AND p.Id = pta.PostId
AND pta.TagId = t.Id
AND (p.Id >= 70677791 AND p.Id < 70727791)
AND pty.Id = 1
AND pta.TagId IN (SELECT TagId
FROM
(SELECT TagId, COUNT(*) AS number 
FROM PostTags
GROUP BY TagId) AS temp
WHERE number >= 100)

fork query

edited jan 19 22

created jan 19 22 anonymous