1

Please login or register to vote for this query.

(click on this box to dismiss)

Determines your posts' quality by dividing the score by the number of views. Higher 'Niceness Rating' indicates a better-received post. Only posts with positive score displayed.

Q&A for Ubuntu users and developers

declare @userid int = ##UserId##

select 
  Id as [Post Link], 
  ViewCount, 
  Score, 
  (100000*Score/ViewCount) as NicenessRating
from (
  (
    select posts.Id, posts.ViewCount, posts.Score
    from posts
    where 
      OwnerUserId=@userid
      and
      PostTypeId=1
  ) union (
    select Answers.Id, posts.ViewCount, Answers.Score
    from posts
    right join (
      select Id, ParentId, Score
      from posts
      where 
        OwnerUserId = @userid
        and 
        PostTypeId =2
    ) Answers
    on posts.Id=Answers.ParentId
  )
) Posts
where Score>0
order by NicenessRating DESC

fork query

edited sep 7

created sep 7 FZs