SELECT DISTINCT issuenum as ТІКЕТ, summary as ТЕМА, 
CASE customvalue 
        WHEN 'ДЗК (ЦБД-2)' THEN issuestatus.pname
        ELSE '---'
        END AS ДЗК_ЦБД2,
CASE customvalue 
        WHEN 'Загальна процедура (ЦБД-2)' THEN issuestatus.pname
        ELSE '---'
        END AS Загальна_процедура_ЦБД2,
CASE customvalue 
        WHEN 'Мала приватизація (ЦБД-2)' THEN issuestatus.pname
        ELSE '---'
        END AS Мала_приватизація_ЦБД2,
CASE customvalue 
        WHEN 'Оренда майна (ЦБД-2)' THEN issuestatus.pname
        ELSE '---'
        END AS Оренда_майна_ЦБД_2,
CASE customvalue 
        WHEN 'УкрОборонПром (ЦБД-2)' THEN issuestatus.pname
        ELSE '---'
        END AS УкрОборонПром_ЦБД2,
CASE customvalue 
        WHEN 'ФГВ (ЦБД-1)' THEN issuestatus.pname
        ELSE '---'
        END AS ФГВ_ЦБД1
FROM customfieldvalue
JOIN jiraissue ON jiraissue.id = customfieldvalue.issue
JOIN issuestatus ON issuestatus.id = jiraissue.issuestatus
JOIN customfieldoption ON customfieldvalue.customfield = customfieldoption.customfield 
AND customfieldoption.id = cast(customfieldvalue.STRINGVALUE as decimal) 
WHERE customfieldvalue.customfield in (12601) 
ORDER BY issuenum