Q&A for people looking to improve their interpersonal communication skills
SELECT DISTINCT p.Id INTO #QuestionIds FROM Posts p INNER JOIN PostTags pt ON p.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName IN ( 'science-based', 'biology', 'planets', 'physics', 'evolution', 'space', 'xenobiology', 'space-travel', 'spaceships', 'geography', 'climate', 'gravity', 'fauna', 'moons', 'atmosphere', 'orbital-mechanics', 'space-colonization', 'astronomy', 'flora', 'geology', 'chemistry', 'earth', 'weather', 'energy', 'engineering', 'space-constructs', 'artificial-intelligence', 'stars', 'psychology', 'anatomy', 'biochemistry', 'underwater' ) AND p.Tags NOT LIKE '%magic%' AND p.Tags NOT LIKE '%warfare%' AND p.Tags NOT LIKE '%weapons%' AND p.Tags NOT LIKE '%medieval%' AND p.Tags NOT LIKE '%government%' AND p.Tags NOT LIKE '%religion%' AND p.Tags NOT LIKE '%worldbuilding-process%' AND p.Tags NOT LIKE '%military%' AND p.Tags NOT LIKE '%law%' AND p.Tags NOT LIKE '%combat%' AND p.Tags NOT LIKE '%military-defense%' AND p.Tags NOT LIKE '%worldbuilding-resources%' AND p.Tags NOT LIKE '%gods%' AND p.Tags NOT LIKE '%medieval-europe%' AND p.Tags NOT LIKE '%crime%' AND p.Tags NOT LIKE '%hard-science%' AND p.ClosedDate IS NULL AND p.PostTypeId = 1; SELECT Id, PostTypeId, ParentId, AnswerCount FROM Posts WHERE (PostTypeId = 1 AND Id IN (SELECT Id FROM #QuestionIds)) OR (PostTypeId = 2 AND ParentId IN (SELECT Id FROM #QuestionIds)) FOR JSON AUTO;