ОТВЕТ:
SELECT * FROM user LEFT JOIN likes ON user.user_id = likes.two_user_id LEFT JOIN dislikes ON user.user_id = dislikes.two_user_id WHERE user.user_id NOT IN (334387978) AND user.sex IN (0) AND user.user_id NOT IN (SELECT likes.two_user_id FROM likes WHERE likes.one_user_id IN (334387978)) AND user.user_id NOT IN (SELECT dislikes.two_user_id FROM dislikes WHERE dislikes.one_user_id IN (334387978))