Piethan

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

Piethan

Keybase proof

I hereby claim:

• I am piethan on github.
• I am ccpiethan (https://keybase.io/ccpiethan) on keybase.
• I have a public key ASBzBbGjyOi55qiK1K2SmrOqvYXrs47n8zY5oqK3iqjCBAo

To claim this, I am signing this object:

Piethan

"C:\Program Files\Lets Encrypt\letsencrypt.exe" --renew --baseuri "https://acme-v01.api.letsencrypt.org/"
powershell -File "C:\Program Files\Lets Encrypt\RDS_INSTALL_CERT.ps1" -CertificateImport "C:\ProgramData\letsencrypt-win-simple\httpsacme-v01.api.letsencrypt.org\remote.example.com-all.pfx" -RDCB remote.example.com