0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

WITH PostsSelected AS(
    SELECT pt.PostId 
    FROM PostTags pt
    JOIN Tags t
    ON pt.TagId = t.Id
    WHERE t.TagName in ('css','html')
    GROUP BY PostId
    HAVING ( COUNT(DISTINCT pt.TagId) > 1 )
    )
SELECT p.* 
FROM Posts p
JOIN PostsSelected ps
ON p.Id = ps.PostId

fork query

edited dec 2

created dec 2 Aleksejs.Zareckis