QFQ

!SELECT gm.id AS _id
        , CONCAT('p:lecture&feUser=', IFNULL(acc.name,'') 
        , IF(ISNULL(gma.id), '|r:3', '|s|b|G:glyphicon-user|o:Switch User (visible only to site admin)')
        , '|t:<span>', p.name,', ', p.vorname, '</span>'
        , '|q:Really switch user to ',  p.name,', ', p.vorname) AS 'Tutor|40|link'
        , CONCAT( LEFT(w.day,3), ' ', r.raum,  '<br>', DATE_FORMAT( zr.von, '%H:%i-'
                ), DATE_FORMAT( zr.bis,'%H:%i')) AS "Day/Time/Room|50|nostrip" 
                                        , grSplit.name AS 'Split group'
                    , IF(gm.x_id4=9980,'checked-gray.gif','') AS "SemAssi Edit Lecture|icon" 
                                        , gm.x_id5 AS 'Grading Workload'
                                       , gm.x_id7 'SAP Ex.-Group'
        FROM