---

SELECT
    c.company_id,
    c.company_name,
    c.field_id,
    c.comp_type_id,
    c.blocked,

    u.user_id,
    u.username,
    u.fio,
    u.phone,

    s.session_id,
    s.last_updated,

    (
        SELECT COUNT(*)
        FROM public.persons p
        WHERE p.company_id = c.company_id
    ) AS persons_count

FROM public.companies c
LEFT JOIN public.user_role_assignments ura
    ON ura.company_id = c.company_id
LEFT JOIN public.users u
    ON u.user_id = ura.user_id
LEFT JOIN public.sessions s
    ON s.user_id = u.user_id

WHERE
    -- u.user_id = 1168
    -- c.company_id = 977
    c.company_name ILIKE '%ритуа%';