SELECT P.Id, P.Title, P.Tags, Count(P.Tags), T.Count, T.T...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT P.Id, P.Title, P.Tags, Count(P.Tags), T.Count, T.TagName

FROM Posts P 
LEFT JOIN PostTags PT ON P.Id = PT.PostId
LEFT JOIN Tags T ON PT.TagId = T.Id 

WHERE P.PostTypeId = 1 

GROUP BY P.Id, P.Title, P.Tags, T.Count, T.TagName

HAVING Count(T.TagName) > 5

Enter Parameters

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