---

select
    current_database() as database_name,
    s.id as sharer_id,
    s.number as sharer_number,
    concat_ws(' ', i.last_name, i.first_name, i.middle_name) as fio,
    (
        select count(*)
        from back_office.account a
        where a.owner_sharer_id = s.id
    ) as linked_account_count
from ourpension.sharer s
left join ourpension.individual i
    on i.id = s.individual_id
where s.number like '%00857634061%';