select (select  CONCAT(us.USVORNAME,' ',us.USFAMILIENNAME) from CCUS us where us.USKURZZ=t.TASKRESP) as 'Name',
       (select vor.TASKNAME from CCTASK vor where vor.TASKID=(select par.PARENTID from CCTASK par where par.TASKID=t.PARENTID LIMIT 1) LIMIT 1) as 'Vorhaben',
       (select par.TASKNAME from CCTASK par where par.TASKID=t.PARENTID LIMIT 1) as 'Arbeitspaket',
       CONCAT(t.TASKNAME) as 'Aufgabe',
       CEILING(t.ESTEFFPH) as 'Planstunden',
       CONCAT(t.PSPCODE) as 'Kontierungs-Element' 
   from CCTASK t
  where t.PROJECT=?
    and t.TASKTYPE='TASK'
    and t.TASKRESP is not null
  order by t.TASKRESP, t.PSPCODE