Lists the most commonly used tags with empty/missing/short tag wikis (wiki or excerpt). Can also identify tag wikis that are over a specified length. Enter -1 for all parameters to match all tags. Tags that have been synonymized are excluded.
Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools
SELECT Count, ('site://questions/tagged/' + TagName + '|' + TagName) AS TagName, CASE WHEN ExcerptPostId IS NOT NULL THEN 'Yes' ELSE NULL END AS Excerpt, CASE WHEN WikiPostId IS NOT NULL THEN 'Yes' ELSE NULL END AS Wiki FROM Tags WHERE ExcerptPostId IS NULL OR WikiPostId IS NULL ORDER BY Count DESC