UPDATE `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` FROM (SELECT `guid`, `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1545),' ',-1) AS `atid`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1550),' ',-1) AS `atpr` FROM `characters`) AS `attq1` INNER JOIN `arena_team_member` ON `arenateamid` = `atid` AND `arena_team_member`.`guid` = `attq1`.`guid` WHERE `atid` <> 0) AS `b` SET `a`.`personal_rating` = `b`.`atpr` WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; UPDATE `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` FROM (SELECT `guid`, `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1551),' ',-1) AS `atid`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1556),' ',-1) AS `atpr` FROM `characters`) AS `attq1` INNER JOIN `arena_team_member` ON `arenateamid` = `atid` AND `arena_team_member`.`guid` = `attq1`.`guid` WHERE `atid` <> 0) AS `b` SET `a`.`personal_rating` = `b`.`atpr` WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; UPDATE `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` FROM (SELECT `guid`, `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1557),' ',-1) AS `atid`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1562),' ',-1) AS `atpr` FROM `characters`) AS `attq1` INNER JOIN `arena_team_member` ON `arenateamid` = `atid` AND `arena_team_member`.`guid` = `attq1`.`guid` WHERE `atid` <> 0) AS `b` SET `a`.`personal_rating` = `b`.`atpr` WHERE `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`;