6

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the most commonly used tags with empty/missing tag wikis (wiki or excerpt).

Q&A about the site for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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