0

Please login or register to vote for this query.

(click on this box to dismiss)

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 distinct PostId, Posts.Body, Posts.Title, Posts.Tags
from joined
left join Posts on Posts.Id = joined.PostId
where Posts.Id = 63213191

fork query

edited aug 4

created aug 4 anonymous