SELECT p.[Title] , p.[Id] , p.[Body] , p.[Tags] , p2.[Sco...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT p.[Title]
      , p.[Id]
      , p.[Body]
      , p.[Tags]
      , p2.[Score] AS AnswerScore
      , p2.[Body] AS AnswerBody
      , p2.[CreationDate] AS AnswerCreationDate
      , p2.[OwnerDisplayName] AS AnswerUserName
      , p2.[Id] AS AnswerId
FROM [Posts] p
  JOIN [Posts] p2 ON p.[AcceptedAnswerId] = p2.[Id]
WHERE p.[AcceptedAnswerId] IS NOT NULL
  AND p.[Tags] LIKE '%<python>%'
ORDER BY p.[Id]
OFFSET 0 ROWS FETCH NEXT 50000 ROWS ONLY;

Enter Parameters

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