select JAHR, KW, wm_concat(distinct LOADNAME) as IN_LADEBESTAENDEN, (select wm_concat(count(*)) from CCDCRES d where d.JAHR=dcr.JAHR and d.KW=dcr.KW group by d.JAHR, d.KW, d.LOADNAME) as LADEBESTANDGROESSEN from CCDCRES dcr group by JAHR, KW order by JAHR, KW asc