QFQ

#  Download Button
, CONCAT('z|t:Download'
    # Excel: alle Antraege
    , CONCAT('||d:Applications_', fa.name_short, '_{{setRequesttyp:R}}.', IFNULL(gmPeriod.note4,''), '.xlsx'
             , '|b:0|G:0|M:excel|s:1|t:<i class="fas fa-file-excel"></i> Excel list applications <span class="badge">'
               , COUNT(DISTINCT re.id), '</span>'
             , '|', REPLACE('{{excelSourceRequests:R}}', '#PERIOD_NAME#', IFNULL(gmPeriod.note4,'') ),'&faculty_id=', fa.id
                  , '&reIdSet=', GROUP_CONCAT(DISTINCT re.id)
             , '|o:Excel export of all applications')

    # Excel: alle Reviews
    , CONCAT('||d:Reviews_', fa.name_short, '_{{setRequesttyp:R}}.', IFNULL(gmPeriod.note4,''), '.xlsx'
             , '|b:0|G:0|M:excel|s:1'
             , '|{{excelSourceReviews:R}}&show_reviewer=yes&faculty_id=', fa.id, '&reIdSet=', GROUP_CONCAT(DISTINCT re.id)
             , '|t:<i class="fas fa-file-excel"></i> Excel list reviews <span class="badge">'
               , COUNT( DISTINCT revSubmitted.id), '/', COUNT( DISTINCT revAssigned.id), '</span>'
             , '|o:Reviews submitted/assigned'
            )
    # FK, Stwf, Mob: ZIP aller Antraege: vorberechnet
    , CONCAT('||d|t:<i class="fas fa-file-archive"></i> All applications of entire faculty|b:0|G:0|F:', gmZip.note
             , IF( gmZip.modified=0 OR (gmZip.modified + INTERVAL 6 MONTH) < NOW()
                  , '|r:3|o:The ZIP file is older than 6 months and probably outdated'
                  , '|o:Download all applications in one ZIP file' )
            )                                                                                
 ) AS _link

• In der Definition ist der dritte Link kaputt. Referenziert wird eine ZIP Datei.