Most-Viewed Posts Using


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

  case when p.PostTypeId = 1 then p.ViewCount else q.ViewCount end as [Views],
  p.CreationDate as [Created On],
  case when p.PostTypeId = 1 then 'Question' else 'Answer' end as [Post Type],
  p.Id as [Post Link],
  p.OwnerUserId as [User Link]
from Posts p
left outer join Posts q on q.Id = p.parentId
  p.Body like ''
order by [Views] desc

Enter Parameters

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