What are Your Mostly Viewed Answers?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- What are Your Mostly Viewed Answers?
-- Do not count zero-score answers unless accepted.

SELECT 
    q.ViewCount AS [View_Count],
    q.Title AS [Title],
    q.id as [Id]
FROM
    Posts q
  INNER JOIN
    Posts ans
  ON ans.ParentId = q.Id
  
WHERE
      ans.CommunityOwnedDate is null
  and ans.OwnerUserId = ##UserId##
  and (ans.Score > 0 OR q.AcceptedAnswerId = ans.Id)
ORDER BY 
  View_Count DESC

Enter Parameters

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