0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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