Skip to content

Instantly share code, notes, and snippets.

@varpa89

varpa89/gist:371dd3ae7fc5639b6972e8ed15dd8662

Created January 12, 2017 14:06
Show Gist options
  • Save varpa89/371dd3ae7fc5639b6972e8ed15dd8662 to your computer and use it in GitHub Desktop.
Save varpa89/371dd3ae7fc5639b6972e8ed15dd8662 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select
groupmembe0_.guid as guid1_59_,
groupmembe0_.createdTs as createdT2_59_,
groupmembe0_.updatedTs as updatedT3_59_,
groupmembe0_.provider_guid as provide12_59_,
groupmembe0_. timestamp as timestam4_59_,
groupmembe0_.deleted as deleted5_59_,
groupmembe0_.deleted_by_provider as deleted_6_59_,
groupmembe0_.origin_id as origin_i7_59_,
groupmembe0_.end_date as end_date8_59_,
groupmembe0_.enrollorder_guid as enrollo13_59_,
groupmembe0_.fin_type as fin_type9_59_,
groupmembe0_."group_guid" as group_g14_59_,
groupmembe0_.organization_membership_guid as organiz15_59_,
groupmembe0_.person_guid as person_16_59_,
groupmembe0_.releaseorder_guid as release17_59_,
groupmembe0_.start_date as start_d10_59_,
groupmembe0_.study_form as study_f11_59_
from
group_membership groupmembe0_
inner join "group" group1_ on groupmembe0_."group_guid" = group1_.guid
inner join organization_membership organizati2_ on groupmembe0_.organization_membership_guid = organizati2_.guid
cross join person person3_
where
groupmembe0_.person_guid = person3_.guid
and groupmembe0_.deleted = false
and organizati2_.deleted = false
and groupmembe0_.person_guid = $1
and person3_.deleted = false
and group1_.organization_guid = $2
and organizati2_. role = 'STUDENT'
order by
group1_.studyyear asc,
groupmembe0_.start_date asc nulls last 2017 - 01 - 12 16 : 58 : 11 MSK [ 607 - 12 ] postgres@gd_mosreg_last_23 DETAIL : parameters : $1 = 'cbac004d-eff2-4c9d-999f-2bf9a0c1567a',
$2 = '4adc6a33-f779-4338-a8ba-f39a80cafc86'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment