Q&A for amateur radio enthusiasts
SELECT P.Id AS [Post Link] FROM Posts P, PostTags Pt, Tags T WHERE P.Id = Pt.PostId AND T.Id = Pt.TagId AND T.TagName like '%##tag1##%' AND P.Tags like '%##tag2##%' AND P.PostTypeId = 1 GROUP BY P.Id HAVING (SELECT Count(Pt.TagId) FROM PostTags Pt WHERE Pt.PostId = P.Id) = 2