select count (data2.address_id), data2.address_id, data2.full_name, data2.bo_dist_full_name from (select count(adr.address_id),  adr.address_id, adr.full_name from (
      select distinct adr.address_id, adr.full_name, def
          from (
                select elp.address_id,  orgs.key::bigint as "contractor", bo.full_name, jsonb_array_elements(orgs.value) as def
                  from edc_person.entrances_legal_person elp,
                       edc_person.legal_person lp,
                       edc_bti.bti_object bo,
                       jsonb_each( elp.attribute ) as entr,
                       jsonb_each( entr.value ) as roles,
                       jsonb_each( roles.value ) as orgs
                  where
                        now() between elp.start_date and elp.end_date
                        and roles.key = 'contractor'
                        and bo.id = elp.address_id
                        and lp.id = orgs.key :: bigint
                        and lp.type_id = 563
                        and lp."attribute" #>> '{legal_person_role_list,0,role_id,legal_person_role}'='557'
               ) as adr
      group by adr.address_id, adr.full_name, def
      having count(def) > 1) as adr
    group by adr.address_id, adr.full_name
    having count(adr.address_id) > 1) as data
inner join (select elp.address_id,  orgs.key::bigint as "contractor", bo.full_name, orgs.value as deffects, bo_dist.full_name as bo_dist_full_name
                  from edc_person.entrances_legal_person elp,
                       edc_person.legal_person lp,
                       edc_bti.bti_object bo,
                       jsonb_each( elp.attribute ) as entr,
                       jsonb_each( entr.value ) as roles,
                       jsonb_each( roles.value ) as orgs,
                       edc_bti.bti_object bo_dist
                  where
                        now() between elp.start_date and elp.end_date
                        and roles.key = 'contractor'
                        and bo.id = elp.address_id
                        and lp.id = orgs.key :: bigint
                        and lp.type_id = 563
                        and lp."attribute" #>> '{legal_person_role_list,0,role_id,legal_person_role}'='557'
                        and bo_dist.id = (bo.district_list_id[1])::bigint) data2 on data2.address_id = data.address_id
group by data2.address_id, data2.full_name, data2.bo_dist_full_name;