Questions eligible for APL bounty by Bubbler

0

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

SELECT Q.Id AS [Post Link], Q.Score, Q.AnswerCount
  FROM Posts Q
  WHERE
  -- Post is question
  Q.PostTypeId = 1
  -- Written by Bubbler
  AND Q.OwnerUserId = 78410
  -- Question is a code-golf challenge and not any of:
  -- restricted-source, atomic-code-golf, polyglot
  AND Q.Tags LIKE '%code-golf%' AND Q.Tags NOT LIKE '%restricted%'
  AND Q.Tags NOT LIKE '%atomic%' AND Q.Tags NOT LIKE '%polyglot%'
  -- Question at least 2 months old (condition removed)
  -- AND Q.CreationDate < DATEADD(month, -2, GETDATE())
  -- 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%'
  )
  ORDER BY Q.Score DESC

Enter Parameters

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