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