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.
q.ViewCount AS [View_Count],
q.Title AS [Title],
q.id as [Id]
ON ans.ParentId = q.Id
ans.CommunityOwnedDate is null
and ans.OwnerUserId = ##UserId##
and (ans.Score > 0 OR q.AcceptedAnswerId = ans.Id)