by tag

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 q.Title, q.Id, q.Score, q.ViewCount, a.Body
, case when a.posttypeid = 1 then 'Q' else 'A' end [Q/A]
from posts a
inner join posts q 
        on q.id = coalesce(a.parentid, a.id) -- only questions have tags
where q.tags like '%<##tag?c###>%'
and q.CreationDate > 2019-06-01
and a.posttypeid in (1,2)

Enter Parameters

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