select p.* from Posts p where exists( select 1 from PostT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select p.*
from Posts p
where exists( select 1
              from PostTags pt
              join tags t on pt.TagId = t.Id and t.TagName = 'html'
              where pt.PostId = p.ID )
and exists( select 1
            from PostTags pt
            join tags t on pt.TagId = t.Id and t.TagName = 'css'
            where pt.PostId = p.ID );

Enter Parameters

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