SELECT * FROM tags_basic as t
INNER JOIN tags ON tags.id = t.id
INNER JOIN tags_tags as chtag ON tags.id = chtag.abstracttag_source
WHERE chtag.abstracttag_target IN (10,11) ;