with joined as (select PostTags.PostId, min(Tags.Count) a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

with joined as 
(select PostTags.PostId, min(Tags.Count) as minimum
from PostTags 
left join Tags on PostTags.TagId = Tags.Id
group by PostTags.PostId
having min(Tags.Count)>500000)

select count(distinct PostId)
from joined

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results