select posts.creationdate, count(posts.id) from posts inn...

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.creationdate, count(posts.id)
from posts inner join
posttags on posttags.postid = posts.id inner join
tags on posttags.tagid = tags.id
where tags.tagname IN ('apocalypse-world*',
'dungeon-world',
'monsterhearts',
'monster-of-the-week',
'saga-of-the-icelanders',
'the-sprawl',
'tremulus',
'blades-in-the-dark',
'kult')
group by creationdate
order by creationdate

Enter Parameters

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