Popular posts by tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

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##

  -- Filter by tag.
  and isnull(p.Tags, q.Tags) like '%' + ##Tag:string## + '%'

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

order by
  p.Score desc

;

Enter Parameters

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