select enduser.id as "Person ID", tickets_id as "Ticket ID", name as "Nachname", forename as "Vorname", start as "Begin", mydate as "Letzer Zugriff" from mac left join enduser on enduser.address=mac.address where verified=1 and (tickets_id != 1) order by name, forename;

