SELECT pr_contr.nprot, pr_contr.datap, spr_vid.vid,
pr_poruch.npor, pr_poruch.text, pr_poruch.srok,
GROUP_CONCAT(IF(dataf,CONCAT(spr_otv.fio," (выполнено: ",DATE_FORMAT(pr_otv.dataf,"%d.%m.%Y"),")"),spr_otv.fio) ORDER BY spr_otv.fio ASC SEPARATOR "; ") AS otv
FROM pr_contr
INNER JOIN spr_vid ON pr_contr.vid = spr_vid.id
RIGHT OUTER JOIN pr_poruch ON pr_poruch.id_prot = pr_contr.id
RIGHT OUTER JOIN pr_otv ON pr_otv.id_poruch = pr_poruch.id
INNER JOIN spr_otv ON pr_otv.id_otv = spr_otv.id
WHERE pr_contr.id = 1
GROUP BY pr_poruch.npor
ORDER BY pr_poruch.npor

SELECT pr_contr.nprot, pr_contr.datap, spr_vid.vid,
pr_poruch.npor, pr_poruch.text, pr_poruch.srok,
LIST(IIF(pr_otv.dataf IS NOT NULL,(spr_otv.fio || ' (выполнено: ' || CAST(lpad(EXTRACT(DAY FROM pr_otv.dataf),2,'0') AS varchar(2)) || '.' || CAST(lpad(EXTRACT(MONTH FROM pr_otv.dataf),2,'0') AS varchar(2)) || '.' || EXTRACT(YEAR FROM pr_otv.dataf) || ')'), spr_otv.fio), '; ') AS otv
FROM pr_contr
INNER JOIN spr_vid ON pr_contr.vid = spr_vid.id
RIGHT OUTER JOIN pr_poruch ON pr_poruch.id_prot = pr_contr.id
RIGHT OUTER JOIN pr_otv ON pr_otv.id_poruch = pr_poruch.id
INNER JOIN spr_otv ON pr_otv.id_otv = spr_otv.id
WHERE pr_contr.id = 1
GROUP BY pr_poruch.npor
ORDER BY pr_poruch.npor

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).

GROUP BY pr_poruch.npor, pr_contr.datap, spr_vid.vid, pr_poruch.npor, pr_poruch.text, pr_poruch.srok
ORDER BY pr_poruch.npor