0

Please login or register to vote for this query.

(click on this box to dismiss)

Also finds tags that have a blank excerpt. Excludes tag synonyms.

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

SELECT concat('| [tag:', concat(TagName, concat('] | ', concat([Count], ' | ')))) AS [Easy Table Formatting]
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 [Count] DESC, TagName

view current version

edited sep 7 21 Timmy Jim

created aug 10 13 Brythan