SELECT top 10 p.Id, count(1) FROM Posts p, PostTags pt, T...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT top 10 p.Id, count(1)
FROM Posts p,
     PostTags pt,
     Tags t
WHERE p.Id = pt.PostId
AND pt.TagId = t.Id
AND t.TagName IN ('html','css')
group by p.Id
having count(1) > 1

Enter Parameters

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