gistfile1.txt

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
	)
)