Worldbuilding import

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

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 = 'hard-science'
  AND p.ClosedDate IS NULL
  AND p.PostTypeId = 1;

SELECT Id, PostTypeId
FROM Posts
WHERE Id IN (SELECT Id FROM #QuestionIds)
   OR ParentId IN (SELECT Id FROM #QuestionIds)
ORDER BY Id ASC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results