by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

SELECT q.*,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