0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select id, title, body  
from posts 
where id in (select distinct postid  --top 1000 * 
                  from posttags
                  where tagid  in (select id
                                    from tags 
                                    where tagname in ('vitest', 'react-testing-library', 'typescript', 'testing', 'unit-test') ))
--
/*
select distinct postid  --top 100 * 
from posttags
where tagid  in (select id
                  from tags 
                  where tagname in ('html','css') )


select distinct postid  --top 100 * 
from posttags pt
left join tags t on t.id = pt.tagid and t.tagname in ('html','css') 


select top 1000 *
from tags 
where tagname in ('html','css') 
*/

fork query

edited oct 28 anonymous

created jul 22 jon.doe45153