To emulate multiple column IN when a subselect is used on databases that don't natively support it, you have to run the subselect as a standalone query, and take the results of it to compose the necessary predicate.
