Q&A for anime and manga fans
select id, title, body from posts where id in (select distinct postid --top 100 * 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') */