AcidZer0

Flashsms называется, сам разобрался. Всем спасибо.

USE hlstatsx;

CREATE TABLE tmp_PlayerIds (playerId INT);

INSERT INTO tmp_PlayerIds
SELECT playerId
FROM hlstats_PlayerUniqueIds
WHERE game = 'tf'
AND uniqueId NOT LIKE '[U:%';

DELETE FROM hlstats_Players WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_PlayerNames WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_PlayerUniqueIds WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Players_Awards WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Players_History WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Players_Ribbons WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);

DELETE FROM hlstats_Events_ChangeName WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_ChangeTeam WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Connects WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Disconnects WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Frags WHERE killerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Frags WHERE victimId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Latency WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Entries WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_PlayerActions WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Suicides WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_TeamBonuses WHERE playerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Teamkills WHERE killerId IN (SELECT playerId FROM tmp_PlayerIds);
DELETE FROM hlstats_Events_Teamkills WHERE victimId IN (SELECT playerId FROM tmp_PlayerIds);

DROP TABLE tmp_PlayerIds;

UPDATE hlstats_PlayerUniqueIds
SET uniqueId = concat(MOD(SUBSTRING(uniqueId,6,9),2), ':', FLOOR(SUBSTRING(uniqueId,6,9)/2))

Помог товарищ погромист.