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 ( 'react-testing-library'))) -- /* 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') */