0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 24

created jan 24 anonymous