Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
DECLARE @UserId int = ##UserId## select top 10 someQuestion.Id as [Post Link], someQuestion.Id as ID, someQuestion.Score as QScore, someQuestion.ViewCount as Views, someQuestion.AnswerCount as Answers, someQuestion.AcceptedAnswerId as AID, someQuestion.ParentId as PID, someQuestion.CommentCount as QComm, yourAnswer.Score as MyScore, yourAnswer.CommentCount as MyComm, someQuestion.Tags from Posts yourAnswer join Posts someQuestion on yourAnswer.ParentID=someQuestion.Id where yourAnswer.OwnerUserId=@UserId order by Views desc