0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select posts.id as [Post Link], max(lastActivityDate)
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'
group by posts.id

view current version

edited apr 28 14

created apr 28 14 Brian Ballsun-Stanton