SELECT
                weapon_name,
                kill_timestamp,

                rp1.player_id AS killerID,
                rp1.roleperiod_team AS killerTeam,
                c1.class_name AS killerClass,
                s1.session_alias AS killerName,

                rp2.player_id AS victimID,
                rp2.roleperiod_team AS victimTeam,
                c2.class_name AS victimClass,
                s2.session_alias AS victimName,

                rp3.player_id AS assistID,
                rp3.roleperiod_team AS assistTeam,
                c3.class_name AS assistClass,
                s3.session_alias AS assistName
        FROM
                kills
                NATURAL JOIN weapons

                INNER JOIN roleperiods AS rp1 ON kill_killer = rp1.roleperiod_id
                INNER JOIN sessions AS s1 ON rp1.session_id = s1.session_id
                INNER JOIN classes AS c1 ON rp1.class_id = c1.class_id

                INNER JOIN roleperiods AS rp2 ON kill_victim = rp2.roleperiod_id
                INNER JOIN sessions AS s2 ON rp2.session_id = s2.session_id
                INNER JOIN classes AS c2 ON rp2.class_id = c2.class_id

                LEFT OUTER JOIN roleperiods AS rp3 ON kill_assist = rp3.roleperiod_id
                LEFT OUTER JOIN sessions AS s3 ON rp3.session_id = s3.session_id
                LEFT OUTER JOIN classes AS c3 ON rp3.class_id = c3.class_id
        WHERE
                (
                        rp1.player_id = $playerid
                        OR rp2.player_id = $playerid
                        OR rp3.player_id = $playerid
                )
        ORDER BY kill_timestamp DESC
        LIMIT 0,20