SELECT `characters`.`obj_id`, `characters`.`char_name`, `characters`.`level`, `characters`.`karma`, `characters`.`pvpkills`, `characters`.`pkkills`, `characters`.`clanid`, `characters`.`onlinetime`, SUM(`character_raidpoints`.`points`) AS rPoints FROM `characters` LEFT JOIN `character_raidpoints` ON `character_raidpoints`.`owner_id` = `characters`.`obj_id` WHERE `character_raidpoints`.`owner_id` = `characters`.`obj_id` AND `characters`.`accesslevel` = 0 GROUB BY obj_id, char_name, level