$sql = "select 
              a.*, c.name as class_name, 
                ifnull(p.name, ep.name) as park_name, 
                ifnull(k.name, ek.name) as kingdom_name, 
                e.name as event_name, e.park_id as event_park_id, e.kingdom_id as event_kingdom_id,