select distinct t.term_id,t.name from snt_terms t
inner join snt_term_taxonomy tt on t.term_id = tt.term_id
inner join snt_term_relationships tr1 on tr1.term_taxonomy_id=t.term_id
inner join snt_term_relationships tr2 on tr2.object_id= tr1.object_id
inner join snt_term_relationships tr3 on tr3.object_id= tr1.object_id
where taxonomy = 'collection' AND (tr3.term_taxonomy_id IN('53,326,374,1904')) AND tr2.term_taxonomy_id=222

SELECT DISTINCT t.term_id, t.name
FROM snt_terms t
INNER JOIN snt_term_taxonomy tt ON t.term_id = tt.term_id
INNER JOIN snt_term_relationships tr1 ON tr1.term_taxonomy_id = t.term_id
INNER JOIN snt_term_relationships tr2 ON tr2.object_id = tr1.object_id
INNER JOIN snt_term_relationships tr3 ON tr3.object_id = tr1.object_id
WHERE taxonomy = 'collection'
AND (tr3.term_taxonomy_id=23 OR tr3.term_taxonomy_id =326 OR tr3.term_taxonomy_id=374 OR tr3.term_taxonomy_id=1904)
AND tr2.term_taxonomy_id =222