I want to find the top K viewed questions with its related answerers and askers, but when I run the following query:
select question.Id as QuestionId, question.Score as QScore, question.ViewCount as QViewCount, question.OwnerUserId as Asker, question.Title, question.Tags, question.AnswerCount as QAnswerCount, answer.Id as AnswerId, answer.ParentId, answer.OwnerUserId as Answerer from Posts as question inner join Posts as answer on question.Id = answer.parentId where question.Id in ( select top 2000 Id from Posts where PostTypeId=1 order by ViewCount desc )
It turned out to be
"Something unexpected went wrong while running your query. Don't worry, blame is already being assigned".
I don't know why this happened. I need help.