$sql = "select a.*, p.name as park_name, k.name as kingdom_name, e.name as event_name, u.name as unit_name, m.mundane_id as m_mundane_id, m.username, m.given_name, m.surname, m.persona, m.restricted, o.role as officer_role, o.officer_id
                    from " . DB_PREFIX . "officer o
                        left join " . DB_PREFIX . "mundane m on o.mundane_id = m.mundane_id
                        left join " . DB_PREFIX . "authorization a on a.authorization_id = o.authorization_id
                            left join ".DB_PREFIX."park p on a.park_id = p.park_id