Most popular questions one has answered to.

1

Please login or register to vote for this query.

(click on this box to dismiss)

This is to know what are the most popular questions you have answered to. It also computes the percentage of people who has viewed the question that have upvoted your answer.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

declare @UserId int = ##UserId##;


select 
  answer.ParentID as [Post Link],
  answer.Score as Score,
  question.Score as "Question score",
  question.ViewCount as "Question views",
  SUBSTRING(
    CONVERT(
      varchar(10), 
      convert(int,100000.0 * answer.Score / question.ViewCount)/1000.0
      ),
    0, 6) + '%' as Perct,
  question.FavoriteCount as "Favorite count",
  (case
    when answer.Id = question.AcceptedAnswerId Then 1
    else 0
    end) as Accepted
from
  Posts as answer
inner
  join 
    Posts as question
  on
    question.Id = answer.ParentID
where
  answer.ownerUserId = @UserId
Order by
  question.ViewCount DESC

Enter Parameters

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