Popular tags without a title or excerpt


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for Tridion developers and administrators

-- 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

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