Most-Viewed Posts Using


Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

  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 meta site
loading Hold tight while we fetch your results