Most-Viewed Posts Using


Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

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