Questions with no Thunno 2 answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

-- Forked from https://data.stackexchange.com/codegolf/query/1668391/questions-eligible-for-apl-bounty-by-adam

SELECT Q.Id AS [Post Link], Q.Score, Q.AnswerCount, Q.ClosedDate
  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 '%kolmogorov%' 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%' AND Q.Tags NOT LIKE '%king-of%'
  AND Q.Tags NOT LIKE '%atomic%'
  -- Positive score
  AND Q.Score >= 1
  AND Q.ClosedDate IS NULL
  -- No answers in any variant of Thunno 2
  AND NOT EXISTS (
    SELECT *
    FROM Posts A
    WHERE A.ParentId = Q.Id
    AND A.PostTypeId = 2
    AND A.Body LIKE '%Thunno 2%'
  )
  -- Answers in Vyxal/Jelly/05AB1E/Pyth to port
  AND EXISTS (
    SELECT *
    FROM Posts A
    WHERE A.ParentId = Q.Id
    AND A.PostTypeId = 2
    AND (A.Body LIKE '%Vyxal%' OR A.Body LIKE '%/jelly%' OR A.Body LIKE '%05AB1E%'
      OR A.Body LIKE '%Pyth,%' OR A.Body LIKE '%Pyth<%'
    )
  )
  ORDER BY Q.ClosedDate ASC, Q.AnswerCount DESC, Q.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results