Popular tags without a title or excerpt

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

-- base query snatched from https://data.stackexchange.com/stackoverflow/query/1407831/average-user-reputation-for-all-popular-tags
SELECT TagName, count(t.id) as CNT -- , t.ExcerptPostId, t.WikiPostId
FROM posts as p 
inner join PostTags as pt on pt.PostId=p.Id
inner join Tags as t on t.Id=pt.TagId
where t.ExcerptPostId is NULL or t.WikiPostId is NULL
group by TagName
order by CNT desc

Enter Parameters

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