Search for topics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Homebrewing

Q&A for dedicated home brewers and serious enthusiasts

set nocount on 
select
  top 100
  p.ParentId,
  p.Title,
  p.ViewCount,
  t.TagName
from Posts p
  join PostTags pt on pt.PostId = p.Id
  join Tags t on t.Id = pt.TagId
where t.TagName in ('okta', 'access', 'user')
  and datediff(day, getdate(), p.CreationDate) < 180
order by ViewCount desc

Enter Parameters

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