replaced offering_instuctor with offering_x_instructor and offering_x_instructor_group as applicable. removed on sub-query that made would check for an illegal combination of values and therefore would always return an empty set.
something happened to session.php, had to recreate it.