select count(zsl.id) as zsl_count
from     (select zsl_id
          from
          bills.get_zsl_id_by_category_id('74', 'a5c11fa3-a1c1-414d-9c37-d885be30ac63', '2021-01-01', '2022-01-01')) zs

         join bills.zsl on zsl.id = zs.zsl_id
         --join bills.schet on schet.id = zsl.idschet
         join bills.sluch sl on sl.idzsl = zsl.id and sl.is_final_record = true
         join pacients.person on person.id = zsl.idperson
         join directory.f003 on f003.id = zsl.idmedorg
         left join directory.podr_omsk podr_omsk on :code_filial = 55
            and podr_omsk.lpu_1::varchar = sl.lpu ->> 'LPU_1'
            and zsl.date_end between podr_omsk.date_begin and coalesce(podr_omsk.date_end, '9999-01-01')
         left join directory.t_podr_tula podr_tula on :code_filial = 71
            and podr_tula.podr_id = sl.lpu ->> 'LPU_1'
         left join directory.v006 v006 on v006.code_type_usl = zsl.idtypeusl
         left join directory.v008 v008 on v008.idvmp::text = zsl.med_pom ->> 'VIDPOM'
         left join directory.v009 on v009.id = zsl.idresult
         left join directory.v017 on v017.id = zsl.idresult
         left join directory.v012 on v012.id = zsl.idishod
        --left join directory.v016 on v016.id = schet.iddisp
where   exists(   select 1 from bills.sluch
                        left join directory.v002 on v002.id = sluch.idprofil
                        where sluch.idzsl = zsl.id )