SELECT `p`.`name` AS 'postauthor', `a`.`name` AS 'authorname', `fr`.`pid`, `fp`.`post_topic` AS 'threadname', `fr`.`reason`
        FROM `z_forum_reports` `fr`
        LEFT JOIN `z_forum` `f` ON (`f`.`id` = `fr`.`pid`)
        LEFT JOIN `z_forum` `fp` ON (`f`.`first_post` = `fp`.`id`)
        LEFT JOIN `ps` `p` ON (`p`.`id` = `f`.`author_guid`)

        LEFT JOIN
                    ( SELECT b.account_id, b.name
                      FROM
                          ( SELECT c.account_id, MAX(c.level) AS level
                            FROM ps AS c
                            GROUP BY c.account_id
                          )
                        JOIN ps AS b
                          ON  b.account_id = c.account_id
                          AND b.level = c.level
                     ) AS a
                   ON (a.account_id = fr.author)