Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
SELECT P.Id AS [Post Link], P.Tags, P.Body FROM Posts P, PostTags Pt, Tags T WHERE P.Id = Pt.PostId AND T.Id = Pt.TagId AND T.TagName = '##tag1##' AND P.PostTypeId = 1 AND P.AnswerCount = 0 AND P.Body LIKE '%##text##%' AND P.ClosedDate IS NULL AND P.CommunityOwnedDate IS NULL AND P.Score > 0 AND (SELECT COUNT(P.Body) FROM Posts P WHERE P.Id = Pt.PostId) < 100 AND (SELECT COUNT(Pt.TagId) FROM PostTags Pt WHERE Pt.PostId = P.Id) = 1