Questions answered in Brain-Flak, yet to answer in [this lang]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

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%'
  -- Has a Brain-Flak answer
  AND EXISTS (
    SELECT *
    FROM Posts A
    WHERE A.ParentId = Q.Id
    AND A.PostTypeId = 2
    AND A.Body LIKE '%Brain-Flak%'
  )
  -- No answers in [insert your language here]
  AND NOT EXISTS (
    SELECT *
    FROM Posts A
    WHERE A.ParentId = Q.Id
    AND A.PostTypeId = 2
    AND A.Body LIKE concat('%', ##Language:string##, '%')
  )
  ORDER BY Q.ClosedDate ASC, Q.AnswerCount DESC, Q.Score DESC

Enter Parameters

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