SELECT
                `btp`.`player_id`
                ,`btp`.`team_id`
                ,`btp`.`deserter`
                ,`btp`.`ip_address`
                , COUNT(*) AS deaths
            FROM
                `battleground_teamplayers` `btp`
            LEFT JOIN
                `custom_pvp_deaths` `d`
            ON
                `d`.`player_id` = `btp`.`player_id`
            WHERE
                `btp`.`battleground_id` = 2111
                AND `d`.`ref_id` = 2111
            GROUP BY
                `d`.`player_id`