---

SELECT DISTINCT
    a.id AS agent_id,
    concat_ws(' ', a.last_name, a.first_name, a.middle_name) AS fio,
    a.user_id,
    u.username,
    p.id AS agent_position_id,
    l.id AS loa_id,
    l.date AS loa_date,
    l.expire_date AS loa_expire_date,
    ladt.dt_id AS document_type_id
FROM ourpension.agent a
LEFT JOIN security."USER" u
    ON u.id = a.user_id
LEFT JOIN ourpension.agent_position p
    ON p.agent_id = a.id
LEFT JOIN ourpension.letter_of_attorney l
    ON l.agent_position_id = p.id
LEFT JOIN ourpension.letter_of_attorney_document_type ladt
    ON ladt.loa_id = l.id
WHERE upper(trim(a.last_name)) IN (
    'ГОРОХОВА',
    'МОРОЗОВА',
    'ЖАРАВИНА',
    'СЕРГЕЕВА',
    'КАНАТЬЕВА',
    'БЕЛЯЕВА',
    'ГОРБОЛЬ'
)
ORDER BY fio, agent_position_id, loa_id, document_type_id;