Tags with no wiki excerpt or tag wiki

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

/* 
Tags missing wiki excerpt and tag wiki.
This message is shown:
"The dropdown tag has no usage guidance, can you help us create it?"
*/
select 
TagsWOWikiExcerpt.Id as TagId, TagsWOWikiExcerpt.Tagname,
TagsWOWikiExcerpt.Count,
TagsWOWikiExcerpt.ExcerptBody, Posts.Body as WikiBody,
TagsWOWikiExcerpt.PosttypeId, 
TagsWOWikiExcerpt.CreationDate, TagsWOWikiExcerpt.DeletionDate, 
TagsWOWikiExcerpt.LastEditDate, TagsWOWikiExcerpt.LastActivityDate
from 
(
select Tags.*,
Posts.Body as ExcerptBody, Posts.PosttypeId, 
Posts.CreationDate, Posts.DeletionDate, Posts.LastEditDate, 
Posts.LastActivityDate
from Tags join Posts on Tags.ExcerptPostId=Posts.Id
where len(Posts.Body)=0
) TagsWOWikiExcerpt
join Posts on TagsWOWikiExcerpt.WikiPostId=Posts.Id
where len(Posts.Body)=0
order by TagsWOWikiExcerpt.Count DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results