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;