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], A.Body
  FROM Posts Q, Posts A
  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 an answer containing the given text
  AND A.ParentId = Q.Id
  AND A.PostTypeId = 2
  AND lower(A.Body) LIKE concat('%<code>%', lower(##Snippet:string##), '%</code>%');

fork query

edited apr 23 21

created apr 23 21 Bubbler