SELECT pid,GROUP_CONCAT(personchronic.chroniccode) as chroniccode,datefirstdiag,datedischart,typedischart,dateupdate
from personchronic
WHERE personchronic.chroniccode BETWEEN 'E10' and 'E15'
GROUP BY pid
HAVING COUNT(pid)> 1