Most Viewed Questions Answered

1

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

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##
DECLARE @Top int = 10

select top 10 
    someQuestion.Id as [Post Link],
    someQuestion.Id as ID,
    someQuestion.AcceptedAnswerId as AID,
    someQuestion.ViewCount as Views,
    someQuestion.Score as QScore,
    someQuestion.CommentCount as QComm,
    someQuestion.AnswerCount as Answers,
    someQuestion.FavoriteCount as Favorites,
    yourAnswer.Score as MyScore,
    someQuestion.Tags

from Posts yourAnswer 
join Posts someQuestion
on yourAnswer.ParentID=someQuestion.Id 
where yourAnswer.OwnerUserId=@UserId
order by Views desc

Enter Parameters

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