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