SELEC
                `btp`.`player_id`
                ,`btp`.`team_id`
                ,`btp`.`deserter`
                ,`btp`.`ip_address`
                ,(
                    SELECT
                        COUNT(*) AS kills
                    FROM
                        `custom_pvp_kills` AS `k`
                    WHERE
                        `k`.`player_id` = `btp`.`player_id`
                        AND `k`.`is_frag` = 1
                        AND `k`.`ref_id` = {$fetch->id}
                ) AS kills
                ,
                (
                    SELECT
                        COUNT(*) AS assists
                    FROM
                        `custom_pvp_kills` AS `k`
                    WHERE
                        `k`.`player_id` = `btp`.`player_id`
                        AND `k`.`ref_id` = {$fetch->id}
                ) AS assists
                ,
                (
                    SELECT
                        COUNT(*) AS deaths
                    FROM
                        `custom_pvp_deaths` AS `k`
                    WHERE
                        `k`.`player_id` = `btp`.`player_id`
                        AND `k`.`ref_id` = {$fetch->id}
                ) AS deaths
            FROM
                `battleground_teamplayers` `btp`

            WHERE
                `btp`.`battleground_id` = {$fetch->id}
            GROUP BY
                `btp`.`player_id`