select t.PROJECT as 'Projekt',t.TASKID as 'Task-ID',t.TASKNAME as 'Name',t.TASKDESC as 'Beschreibung',

            DATE_FORMAT(t.STARTTIME,'%d.%m.%Y') as 'Beginn', DATE_FORMAT(t.ENDTIME,'%d.%m.%Y') as 'Ende',

            t.TASKRESP as 'Verantwortlich', t.ESTEFFPH as 'Planstunden',  t.ESTEUR as 'Plankosten (excl.GK, EUR)', t.RATEUR as 'Stundensatz (excl.GK, EUR)',

           (CASE WHEN JSON_LENGTH(t.TASKATTRIB)=0 THEN '' ELSE  t.TASKID END) as 'Attribute' 

  from CCTASK t where PARENTID=?