SELECT somefield, cast(mid(player_id,9,1) as unsigned) + cast('76561197960265728' as unsigned) + cast(mid(player_id, 11,10)*2 as unsigned) AS comid, somefield FROM sometable