Get Questions by Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

select p.Id, p.tags, p.body, p.id as [Post Link]
     , case when p.posttypeid = 1 then 'Q' else 'A' end [Q/A]
from posts p
inner join posts q 
        on q.id = coalesce(p.parentid, p.id) -- only questions have tags
where q.tags like '%<##tag?cloud##>%'
and p.posttypeid in (1,2)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results