---

SELECT
  contract.number as contract_number,
  sh.number as sh_number,
  i.last_name as last_name,
  i.first_name as first_name,
  i.middle_name as middle_name,
  to_char(i.birth_date, 'DD.MM.YYYY') as birth_date,
  i.insurance_number as insurance_number,
  i.certificate_series as certificate_series,
  i.certificate_number as certificate_number,
  case 
	when i.sex ='F' then 'Ж'
	else 'М'
end as sex,
  i.id as id 
FROM ourpension.application_termination_contract atc 
left join ourpension.application_termination_contract_data atcd on atcd.application_termination_contract_id = atc.id
LEFT JOIN ourpension.sharer sh ON sh.id = atcd.sharer_id
LEFT JOIN ourpension.contract contract ON contract.id = sh.contract_id
left join ourpension.individual i on sh.individual_id = i.id
left join ourpension.uv_activity_type uat 
			 on uat.activity_eng_type = contract.service_type 
			and uat.client_type = contract.client_type
			/*ourpension.individual i
LEFT JOIN ourpension.sharer sh ON sh.individual_id = i.id
LEFT JOIN ourpension.contract contract ON contract.id = sh.contract_id
LEFT JOIN ourpension.application_termination_contract atc on atc.individual_id = i.id
left join ourpension.service_app_type sat on atc.service_app_type_code = sat.code

left join ourpension.uv_activity_type uat 
			 on uat.activity_eng_type = contract.service_type 
			and uat.client_type = contract.client_type*/
WHERE atc.id is not null and (uat.activity_rus_type = 'ПДС' or uat.activity_rus_type = 'НПО') and
1=1
  and 1 = 0