SELECT q.Id, q.Title, q.body,q.Tags,q.CreationDate,q.Acc...


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT q.Id, q.Title,  q.body,q.Tags,q.CreationDate,q.AcceptedAnswerId, q.AnswerCount, a.Body as answer, a.CreationDate as answerDate
, case when a.posttypeid = 1 then 'Q' else 'A' end [Q/A]
from posts a
inner join posts q 
        on = coalesce(a.parentid, -- 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

Switch sites:
loading Hold tight while we fetch your results