View Count

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

DECLARE @UserId int = 5066625

select /* top 100*/ someQuestion.Id as [Post Link],
someQuestion.ViewCount,
someQuestion.CommentCount as comms,
someQuestion.LastActivityDate as lastView,
someQuestion.AnswerCount,
someQuestion.FavoriteCount as favs,
yourAnswer.Score as YourScore,
someQuestion.Tags
from Posts yourAnswer 
join Posts someQuestion
on yourAnswer.ParentID=someQuestion.Id 
where yourAnswer.OwnerUserId=@UserId AND yourAnswer.Score > 0
order by ViewCount desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results