0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

select id, title, body  
from posts 
where id in (select distinct postid
                  from posttags
                  where tagid  in (select id
                                    from tags 
                                    where tagname in ( 'vitest')))
--
/*
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