select JAHR as "Jahr", count(KW) as "Anzahl Wochen", count(IN_LADEBESTAENDEN) as "Anzahl Ladebestände", 
       min(KW) as "Erste Kalenderwoche", max(KW) as "Letzte Kalenderwoche",
       min(IN_LADEBESTAENDEN) as "Erster Ladebestand", max(IN_LADEBESTAENDEN) as "Letzter Ladebestand"
  from (select JAHR, KW, GROUP_CONCAT(distinct LOADNAME) as IN_LADEBESTAENDEN, 
                            (select GROUP_CONCAT(ls.LOADSIZE) 
                                from CCVDCLOADSIZES ls where ls.JAHR=dcr.JAHR and ls.KW=dcr.KW 
                               group by ls.JAHR, ls.KW) as LADEBESTANDGROESSEN 
          from CCDCRESA dcr 
         group by JAHR, KW 
         order by JAHR, KW asc) gd 
 group by JAHR
 order by JAHR asc