Page History

select GPGgpg.NAMEname, GPFgpf.NAMEname, GPMgpm.SUBJECTsubject_IDid, GPMgpm.SUBJECTsubject_SOURCEsource, GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime, gpmav.membership_end_time
from from
   GROUPERgrouper_PITpit_MEMBERSHIPSmemberships_ALLall_Vv gpmav,
  grouper_pit_members gpm,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg
where where
  GPMAV gpmav.MEMBERmember_IDid = GPMgpm.IDid
  and GPMgpm.subject_source = 'pennperson'
  and GPMAVgpmav.OWNERowner_GROUPgroup_IDid = GPGgpg.IDid
  and GPGgpg.NAMEname = 'penn:sas:service:mailing_list:staff:permanent_staff:list'
  and GPMAVgpmav.FIELDfield_IDid = GPFgpf.IDid
  and (GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime is null or GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime < 1374595200000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1374595200000000 )

select GPGgpg.NAMEname, GPFgpf.NAMEname, GPGgpg_MEMBERmember.NAMEname, GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime, gpmav.membership_end_time
from 
  grouper_pit_groups gpg_member,
  GROUPER grouper_PITpit_MEMBERSHIPSmemberships_ALLall_Vv gpmav,
  grouper_pit_members gpm,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg
where where
   GPMAVgpmav.MEMBERmember_IDid = GPMgpm.IDid
  and gpf.name = 'members'
  and GPMgpm.subject_source = 'g:gsa'
  and GPMgpm.SUBJECTsubject_IDid = GPGgpg_MEMBERmember.source_ID
  and GPGgpg_member.NAMEname like 'penn:community:employee:org%'
  and GPMAVgpmav.OWNERowner_GROUPgroup_IDid = GPGgpg.IDid
  and GPGgpg.NAMEname not like 'penn:community:employee%'
  and GPMAVgpmav.FIELDfield_IDid = GPFgpf.IDid
  and (GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime is null or GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime < 1364270400000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1364270400000000 )

select GPGgpg.NAMEname, GPMgpm.SUBJECTsubject_IDid
from from
   GROUPERgrouper_PITpit_MEMBERSHIPSmemberships_ALLall_Vv gpmav,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg,
  grouper_pit_members gpm
where 
  GPMgpm.subject_source != 'g:gsa'
   and GPMAVgpmav.MEMBERmember_IDid = GPMgpm.IDid
   and GPMgpm.SUBJECTsubject_IDid not in ('10094590', '10037375', '10033223')
  and GPGgpg.NAMEname like 'penn:community:employee:org:TOPU%'
  and gpg.name not like '%_rolluporg_systemOfRecordAndIncludes'
  and gpg.name not like '%systemOfRecord'
  and gpg.name not like '%_personorg'
  and gpg.name not like '%_rolluporg'
  and GPMAVgpmav.OWNERowner_GROUPgroup_IDid = GPGgpg.IDid
  and and gpf.name = 'members'
  and and GPMAVgpmav.FIELDfield_IDid = GPFgpf.IDid
  and and (GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime is null or GPMAVgpmav.MEMBERSHIPmembership_STARTstart_TIMEtime < 1364270400000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1364270400000000 )

  ;