JanitorTags: posts that contain two specified tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

2 user-inputtable tags, with defaults; post must have a score > 1; post must not be closed

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

select Id as [Post Link],Score,ViewCount,CreationDate,LastEditDate,LastActivityDate,AnswerCount,FavoriteCount 
-- select Id as [Post Link],*
from Posts p 
where p.Id in (
  select pt1.PostId from PostTags pt1
  join PostTags pt2 on
  pt2.PostId = pt1.PostId
  where pt1.TagId = (select Id from Tags where TagName = ##Tag1:string?centos##)
    and pt2.TagId = (select Id from Tags where TagName = ##Tag2:string?rhel##)
  )
  and p.Score > 1
  and p.ClosedDate IS NULL
  order by CreationDate DESC

Enter Parameters

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