Почему может не работать выборка?

Есть примерная структура бд:

SELECT
    players.id AS player_id,
    teams_players.team_id AS team_id,
    users.name AS user_name,
    players.game_id AS game_id
FROM
    `users`
LEFT JOIN `players` ON `users`.`id` = `players`.`user_id`
LEFT JOIN `teams_players` ON `players`.`id` = `teams_players`.`player_id`
LEFT JOIN `teams` ON `teams_players`.`team_id` = `teams`.`id`
WHERE
    (
        `users`.`id` IN(
        SELECT
            IF(
                `sender_id` = 42,
                `receiver_id`,
                `sender_id`
            )
        FROM
            `friends`
        WHERE
            `status` = 1
        )
    ) AND(`players`.`game_id` = '3')

Выбираю друзей определенного пользователя со статусом 1, у которых игрок из игры 3. Получаю такой результат:

Теперь хочу вывести игроков у которых команда не равна 2(или её вообще нет)

SELECT
    players.id AS player_id,
    teams_players.team_id AS team_id,
    users.name AS user_name,
    players.game_id AS game_id
FROM
    `users`
LEFT JOIN `players` ON `users`.`id` = `players`.`user_id`
LEFT JOIN `teams_players` ON `players`.`id` = `teams_players`.`player_id`
LEFT JOIN `teams` ON `teams_players`.`team_id` = `teams`.`id`
WHERE
    (
        `users`.`id` IN(
        SELECT
            IF(
                `sender_id` = 42,
                `receiver_id`,
                `sender_id`
            )
        FROM
            `friends`
        WHERE
            `status` = 1
    )
    ) AND(`players`.`game_id` = '3') AND(teams.id <> 2)

Возвращает ноль строк. Что я делаю не так?