SELECT
        first_level_approver_relations_approvers.approver_id,
        CASE
          WHEN employees.has_admin_as_first_level_approver = 't'
            THEN
              SELECT admins.id
              FROM company_users AS admins
              WHERE admins.admin = 't'
          ELSE
            NULL
        END,
        CASE
          WHEN employees.has_manager_as_first_level_approver = 't'
            THEN
              SELECT team_users.company_user_id
              FROM team_users
              WHERE team_users.manager = 't'
              AND team_users.read_only_manager = 'f'
              JOINS team ON team.id = team_users.team_id
              WHERE EXISTS (
                      SELECT 1 FROM team_users AS tu
                      WHERE tu.employee_id = employees.id
                    )
          ELSE
            NULL
        END,
        CASE
          WHEN employees.has_leader_as_first_level_approver = 't'
            THEN
              employees.leader_id
          ELSE
            NULL
        END
        FROM company_users AS employees
        JOIN first_level_approver_relations_approvers
          ON first_level_approver_relations_approvers.employee_id = employees.id