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