Created
January 11, 2017 14:48
-
-
Save varpa89/e28b7edc9114b714dec40b0fd65351a0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
person0_.guid as guid1_92_, | |
person0_.createdTs as createdT2_92_, | |
person0_.updatedTs as updatedT3_92_, | |
person0_.provider_guid as provide38_92_, | |
person0_. timestamp as timestam4_92_, | |
person0_.deleted as deleted5_92_, | |
person0_.deleted_by_provider as deleted_6_92_, | |
person0_.adapt_program_needy as adapt_pr7_92_, | |
person0_.birth_date as birth_da8_92_, | |
person0_.birthPlace as birthPla9_92_, | |
person0_.citizenship as citizen10_92_, | |
person0_.citizenship_type as citizen11_92_, | |
person0_.common_seniority_start_date as common_12_92_, | |
person0_.dead_info_guid as dead_in39_92_, | |
person0_.ded_ts as ded_ts13_92_, | |
person0_.disability_group as disabil14_92_, | |
person0_.education_guid as educati40_92_, | |
person0_.first_name as first_n15_92_, | |
person0_.fs_guid as fs_guid16_92_, | |
person0_.gender as gender17_92_, | |
person0_.has_pension as has_pen18_92_, | |
person0_.last_name as last_na19_92_, | |
person0_.locationAddress as locatio20_92_, | |
person0_.loc_address_fias_guid as loc_add21_92_, | |
person0_.long_therapy_needy as long_th22_92_, | |
person0_.medical_group as medical23_92_, | |
person0_.medical_group_adults as medical24_92_, | |
person0_.pt_group as pt_grou25_92_, | |
person0_.registrationAddress as registr26_92_, | |
person0_.reg_address_fias_guid as reg_add27_92_, | |
person0_.rename_date_by_zags as rename_28_92_, | |
person0_.second_name as second_29_92_, | |
person0_.seniority_start_date as seniori30_92_, | |
person0_.snils as snils31_92_, | |
person0_.special_org_needy as special32_92_, | |
person0_.teacher_edu as teacher33_92_, | |
person0_.temp_address_date as temp_ad34_92_, | |
person0_.temporaryAddress as tempora35_92_, | |
person0_.temp_address_fias_guid as temp_ad36_92_, | |
person0_.visa as visa37_92_, | |
date_part( | |
'year', | |
age(person0_.birth_date) | |
) as formula20_, | |
( | |
SELECT | |
c . name | |
FROM | |
citizenship c | |
WHERE | |
c .code = person0_.citizenship | |
) as formula21_, | |
( | |
coalesce(person0_.citizenship, 0) = 1 | |
OR person0_.citizenship IS NULL | |
) :: boolean as formula22_ | |
from | |
person person0_ | |
inner join person_ids personids1_ on person0_.guid = personids1_.person_guid | |
where | |
personids1_.provider_guid = $1 | |
and( | |
personids1_.origin_id in( | |
$2, | |
$3, | |
$4, | |
$5, | |
$6, | |
$7, | |
$8, | |
$9, | |
$10, | |
$11, | |
$12, | |
$13, | |
$14, | |
$15, | |
$16, | |
$17, | |
$18, | |
$19, | |
$20, | |
$21, | |
$22, | |
$23, | |
$24, | |
$25, | |
$26, | |
$27, | |
$28, | |
$29, | |
$30, | |
$31, | |
$32, | |
$33, | |
$34, | |
$35, | |
$36, | |
$37, | |
$38, | |
$39, | |
$40, | |
$41, | |
$42, | |
$43, | |
$44, | |
$45, | |
$46, | |
$47, | |
$48, | |
$49, | |
$50, | |
$51 | |
) | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment