Search topics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding Meta

Q&A about the site for writers/artists using science, geography and culture to construct imaginary worlds and settings

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 ('on-demand', 'group', 'access')
  and datediff(day, getdate(), p.CreationDate) < 180
order by ViewCount desc

Enter Parameters

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