Tag with no usage guidance, but it has a tag wiki, can you help us summarize it?

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 without a wiki excerpt but with a tag wiki.
*/
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