What incomplete tag wikis might you be able to complete

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select t2.TagName, count(p2.PostId)
  from PostTags p1
  join Tags t1
    on p1.TagId = t1.Id
  join PostTags p2
    on p1.PostId = p2.PostId
  join Tags t2
    on p2.TagId = t2.Id
 where t1.TagName = '##tagname##'
   and t1.WikiPostId is not null
   and ( t2.ExcerptPostId is null
         or t2.WikiPostId is null
         )
 group by t2.TagName
 order by count(p2.PostId) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached