Popular posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

select
  p.Id as [Post Link],
  p.Score,
  isnull(p.ViewCount, q.ViewCount) as ViewCount,
  p.LastEditorUserId as [User Link]

from
  Posts p

  left outer join Posts q on p.ParentId = q.Id

where
  -- Minimum score of post.
  p.Score >= ##MinScore##

  -- Minimum ViewCount of question.
  and isnull(p.ViewCount, q.ViewCount) >= ##MinViewCount##

  -- Questions only.
  -- and p.PostTypeId = 1

order by
  p.Score desc

;

Enter Parameters

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