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)

Chinese Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

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