Closed, Off topic questions with specific tags

Select 
distinct 
p.Id 
from Posts p
inner join PostHistory ph on ph.PostId = p.Id
inner join PostHistoryTypes pht on ph.PostHistoryTypeId = pht.Id
inner join PostTags pt on p.ID = pt.PostId
inner join Tags t on pt.TagId = t.Id
and (t.TagName like 'c#' 
  or t.TagName like 'asp.net%' 
  or t.tagName like 'powershell' 
  or t.TagName like 'sql-server%'
  or t.TagName like 'excel%'
  or t.TagName like 'csv%')
where 
p.ClosedDate is not null
and pht.Name = 'Post Closed' 
and ph.Comment = '102' -- Off topic
and p.CreationDate > '01 Jan 2016'
order by p.id desc

results matching ""

    No results matching ""