D&D Next Playtest Queries

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select posts.id as [Post Link], max(lastActivityDate) as LastActivity
from posts join posttags on (posts.id = posttags.postid) 
join tags on (posttags.tagid = tags.id)
join posttypes on (posts.posttypeid = posttypes.id)
where tagName = 'dnd-next'
and lastActivityDate < '2014-07-31'
group by posts.id
having max(closedDate) is null
order by max(lastActivityDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results