OTRS Agentenleistung

SELECT date_format(t.change_time,  "%Y-%m-%d") AS DATUM, date_format(t.change_time,  "%H") AS STUNDE, q.name as QUEUE, tt.name AS STATUS, u.first_name, u.last_name, count(t.id) AS ANZAHL FROM ticket t
left join users u on
  u.id = t.user_id
left join ticket_state tt on
 tt.id=t.ticket_state_id
left join queue q on
  q.id = t.queue_id
left join article a on
  a.ticket_id = t.id
where t.change_time >= NOW() - INTERVAL 1 DAY
group by date_format(t.change_time,  "%Y-%m-%d"), q.name, t.ticket_state_id, tt.name, u.first_name, u.last_name