0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

select p.id ,p.tags ,p.id as [Post Link]
     , case when p.posttypeid = 1 then 'Question' else 'Answer' end [Q/A]
from posts p
inner join posts q 
        on q.id = coalesce(p.parentid, p.id) -- only questions have tags
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
cross join string_split(##tags:string?mozilla##, ',') tv
where t.tagname = tv.value
and p.posttypeid in (1,2) and p.id = 1678868

fork query

edited dec 31 20

created dec 31 20 anonymous