4

Please login or register to vote for this query.

(click on this box to dismiss)

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 developers and researchers interested in open data

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

view current version

edited feb 1 13

created feb 1 13 e