1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT Tags.TagName AS Tag, Tags.[Count] AS Count
FROM Tags
LEFT JOIN Posts pe ON pe.Id = Tags.ExcerptPostId
LEFT JOIN TagSynonyms ON SourceTagName = Tags.TagName
WHERE COALESCE(LEN(pe.Body), 0) = 0 AND ApprovalDate IS NULL
ORDER BY Tags.[Count] DESC, Tags.TagName

fork query

created may 23 23 galacticninja