Page History

select gpg.name, gpf.name, gpg_member.name, gpmav.membership_start_time, gpmav.membership_end_time
from 
  grouper_pit_groups gpg_member,
  grouper_pit_memberships_all_v gpmav,
  grouper_pit_members gpm,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg
where
  gpmav.member_id = gpm.id
  and gpf.name = 'members'
  and gpm.subject_source = 'g:gsa'
  and gpm.subject_id = gpg_member.source_IDid
  and gpg_member.name like 'penn:community:employee:org%'
  and gpmav.owner_group_id = gpg.id
  and gpg.name not like 'penn:community:employee%'
  and gpmav.field_id = gpf.id
  and (gpmav.membership_start_time is null or gpmav.membership_start_time < 1364270400000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1364270400000000 )