SELECT
    subj.name AS subject,
    split_part(SOURCE.name, ' ', 1) AS SOURCE,
    CASE WHEN SOURCE.TYPE = 'OWN'
        THEN 'Внутренняя'
        ELSE 'Внешняя'
    END AS SrcType,
    macroregion.name AS macro,
    REPLACE(city.nameru, 'ё', 'е') AS city,
    msg.issuedatecreated + INTERVAL '3 hours' AS DATE
    msg.issuedatecreated + INTERVAL '3 hours' AS TIME,
    split_part(msg.issueurl, '#', 1) AS Url,
    msg.issueauthorname AS Author,
    msg.issuetext AS text,
    CASE WHEN msg.entrytone = 'NEGATIVE'
        THEN 'Негатив'
    WHEN msg.entrytone = 'NEUTRAL'
        THEN 'Нейтрал'
    WHEN msg.entrytone = 'POSITIVE'
        THEN 'Позитив'
    END AS Tone,
    cat.name AS Cat,
Ответы,
Вариаты закрытия инцидентов

FROM monitoring_customerissues AS msg
    LEFT JOIN monitoring_projectcategories AS cat
        ON (msg.projectcategory_id = cat.id)
    LEFT JOIN geo_city AS city
        ON (city.id = msg.geocity_id)
    LEFT JOIN monitoring_macroregions AS macroregion
        ON (msg.monitoringmacroregion_id = macroregion.id)
    LEFT JOIN monitoring_projectsubjects AS subj
        ON (msg.projectsubject_id = subj.id)
    LEFT JOIN monitoring_projectsites AS SOURCE
        ON (msg.projectsite_id = SOURCE.id)

WHERE msg.project_id = 18791
    AND msg.issuedatecreated >= :mindate
    AND msg.issuedatecreated <= :maxdate
    AND msg.deleted IS NULL
ORDER BY msg.issuenumber ASC;