0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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 Q.Tags LIKE '%code-golf%' AND Q.Tags NOT LIKE '%tips%'
  AND Q.Tags NOT LIKE '%cops-and-robbers%' AND Q.Tags NOT LIKE '%polyglot%'
  AND Q.Tags NOT LIKE '%obfuscation%'
  -- custom tags
  AND Q.Tags LIKE '%math%'
  -- Question is recent enough
  AND year(Q.CreationDate) >= 2016
  -- Does not have an answer in any common dialects of K
  AND NOT EXISTS (
    SELECT *
    FROM Posts A
    WHERE A.ParentId = Q.Id
    AND A.PostTypeId = 2
    AND (
      A.Body LIKE '%K (ngn/k)%' OR
      A.Body LIKE '%JohnEarnest/ok%' OR
      A.Body LIKE '%kx.com/download/%'
    )
  )
  ORDER BY Q.ClosedDate ASC, Q.AnswerCount ASC, Q.Score DESC;

fork query

edited jun 9 21 Bubbler

created apr 24 19 Traws