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)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

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 main site
loading Hold tight while we fetch your results