select*from(select people_ptr_id,status, title, biography, research_interests, presentations, publications from wwami_peoplefaculty where faculty_type ~* 'Regular|Fellow' union all select people_ptr_id, status, position_title, biography, research_interests, presentations, publications from wwami_peopledfm)t1 inner join wwami_people on wwami_people.id = t1.people_ptr_id where status = 'Active' and primary_section_id = 6 order by last_name asc
