0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

select top(10) *
  from Posts pst
 where exists (select PostId
                 from PostTags ptg
                 join Tags tg on ptg.TagId = tg.Id
                where pst.Id = ptg.PostId
                  and tg.TagName = 'html'
                )
   and exists (select PostId
                 from PostTags ptg
                 join Tags tg on ptg.TagId = tg.Id
                where pst.Id = ptg.PostId
                  and tg.TagName = 'css'
                )

view current version

edited jun 15 21

created jun 15 21 anonymous