SELECT q.Id, q.Title, q.Score, q.AnswerCount, a.Body , c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT q.Id, q.Title,  q.Score, q.AnswerCount, 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)
Order by q.Id

Enter Parameters

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