Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
SELECT Q.Id AS [Post Link], Q.Score, Q.AnswerCount FROM Posts Q WHERE -- Post is question Q.PostTypeId = 1 -- Question is a code-golf challenge and not any of: -- tips, restricted-any, source-layout, quine, polyglot, cops-and-robbers -- ascii-art, kolmogorov-complexity, internet, network, compile-time, regex -- graphical-output, image, king-of-the-hill, atomic-code-golf AND Q.Tags LIKE '%code-golf%' AND Q.Tags NOT LIKE '%tips%' AND Q.Tags NOT LIKE '%restricted%' AND Q.Tags NOT LIKE '%source-layout%' AND Q.Tags NOT LIKE '%quine%' AND Q.Tags NOT LIKE '%polyglot%' AND Q.Tags NOT LIKE '%cops%' AND Q.Tags NOT LIKE '%ascii-art%' AND Q.Tags NOT LIKE '%internet%' AND Q.Tags NOT LIKE '%network%' AND Q.Tags NOT LIKE '%hardware%' AND Q.Tags NOT LIKE '%compile%' AND Q.Tags NOT LIKE '%graphical%' AND Q.Tags NOT LIKE '%image%' AND Q.Tags NOT LIKE '%king-of%' AND Q.Tags NOT LIKE '%atomic%' -- Question was asked between 2017 and 2019 AND year(Q.CreationDate) <= 2019 AND year(Q.CreationDate) >= 2016 AND Q.ClosedDate IS NULL -- Positive score AND Q.Score >= 0 -- Not too hard, at least an answer -- AND 1 <= Q.AnswerCount -- Not too easy, at most 20 answers AND Q.AnswerCount <= 40 -- No answers in any variant of APL, excluding Perl/Ruby -apl answers AND NOT EXISTS ( SELECT * FROM Posts A WHERE A.ParentId = Q.Id AND A.PostTypeId = 2 AND (A.Body LIKE '%Jelly%' OR A.Body LIKE '%APL%') AND A.Body NOT LIKE '%-APL%' ) ORDER BY Q.AnswerCount ASC, Q.Score ASC