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## -- Filter by tag. -- and isnull(p.Tags, q.Tags) like '%' + ##Tag:string## + '%' -- Questions only. -- and p.PostTypeId = 1 order by p.Score desc ;