A subselect used on the right-hand side of an = must probably return one row (one column, even). A subselect used on the right-hand side of an IN can probably return multiple rows (though presumably ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results