Automatischer Report für Mitarbeiter

SELECT DISTINCT 
    w.created_by_id,
    u.email, 
    CONCAT(u.lastname, ' ', u.firstname) AS NAME1, 
    r.*, 
   DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 20 HOUR), '%Y.%m.%d %H:%i:%s') AS 'vonDatum', 
   CONCAT(DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), '%Y.%m.%d'), ' 23:00:00') AS 'bisDatum'
FROM
    ticket_time_accountings w
JOIN 
    users u ON w.created_by_id = u.id
JOIN 
    roles_users r ON r.user_id = u.id
WHERE 
    r.role_id = 5 
    AND u.out_of_office = 0;