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],
  A.Id AS [Post Link],
  Q.Score,
  Q.AnswerCount,
  Q.Tags,
  A.Body
FROM Posts Q INNER JOIN Posts A ON Q.Id = A.ParentId
WHERE
  -- Parent 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 '%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 '%self-referential%'
  AND Q.Tags NOT LIKE '%random%' AND Q.Tags NOT LIKE '%error%'
  -- custom tags
  AND Q.Tags NOT LIKE '%string%' AND Q.Tags NOT LIKE '%kolmo%'
  AND Q.Tags NOT LIKE '%text%' AND Q.Tags NOT LIKE '%date%'
  AND Q.Tags NOT LIKE '%ascii%' AND Q.Tags NOT LIKE '%unicode%'
  AND Q.Tags NOT LIKE '%language%' AND Q.Tags NOT LIKE '%word%'
  AND Q.Tags NOT LIKE '%interpreter%'
  AND Q.Tags NOT LIKE '<code-golf>' -- the *only* tag is code golf
  -- Question is not closed
  AND Q.ClosedDate IS NULL
  -- Child post is an answer in Jelly
  AND A.PostTypeId = 2
  AND lower(A.Body) LIKE '%dennismitchell/jelly%'
ORDER BY Q.AnswerCount DESC, Q.Score DESC

fork query

edited sep 28 21

created sep 27 21 Bubbler