Questions eligible for APL bounty by Adam

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT Q.Id AS [Post Link], Q.Score
  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
  AND Q.Tags LIKE '%code-golf%' AND Q.Tags NOT LIKE '%tips%'
  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 '%regular%'
  AND Q.Tags NOT LIKE '%regex%' AND Q.Tags NOT LIKE '%graphical%'
  AND Q.Tags NOT LIKE '%image%'
  -- I like strings
  --AND Q.Tags NOT LIKE '%string%'
  -- Question was asked between 2016 and 2018
  AND year(Q.CreationDate) <= 2018 AND year(Q.CreationDate) >= 2016
  -- Positive score
  AND Q.Score >= 1
  -- Not too hard, at least an answer
  AND 1 <= Q.AnswerCount
  -- 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 '%APL%'
    AND A.Body NOT LIKE '%-APL%'
  )
  -- easier first, though that risks optimal Jelly answers
  ORDER BY Q.AnswerCount DESC, Q.Score DESC

Enter Parameters

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