1

Please login or register to vote for this query.

(click on this box to dismiss)

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

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

;

fork query

edited jun 13 22

created jun 6 22 Mateen.Ulhaq