Takes into account your previous posts/interactions with tags to determine whether you might be able to write a wiki for it.
Q&A for passionate videogamers on all platforms
SELECT DISTINCT t.TagName ,( case when t.WikiPostId is null and t.excerptPostId is null then 'No Wiki/NoExcerpt' when t.WikiPostId is null then 'No Wiki' when t.excerptPostId is null then 'No Excerpt' else '???' end ) as [What is missing] FROM posts p -- all posts ... INNER JOIN posttags pt -- with their all tags ... ON pt.postid = coalesce(p.parentid, p.id) -- for answers, use the question INNER JOIN tags t -- find a single tag ON t.id = pt.tagid WHERE p.owneruserid = ##userid## -- post belongs to a user and (t.excerptPostId is null -- where the excerpt foreignkey is null or t.WikiPostId is null) -- or the wiki foreignkey is null