Answers with references to Wikipedia by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns all answers by chosen user that have "en.wikipedia.org/wiki" in them somewhere.

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @UserId int = ##UserId##

SELECT
  A.Id as [Post Link],
  A.CreationDate as [Answer Date]
FROM
  Posts A
WHERE
  A.OwnerUserId = @UserId
  AND A.PostTypeId = 2 --answers
  AND (A.Body LIKE '%en.wikipedia.org/wiki%')
ORDER BY
  [Answer Date] DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results