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 experienced flyers, pilots, and builders of drones and model aircraft
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