Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tz.Datum_von, tz.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tz.Datum_bis, tz.Datum_von)) / 60)>) As 'Heute Telefon' from ticket_zeiten tz LEFT OUTER JOIN Mitarbeiter m on m.ID=tz.Mitarbeiter where tz.Telefon_log IS NULL and tz.Datum_von>= '{SQL_NOW}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tl.Datum_von, tl.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tl.Datum_bis, tl.Datum_von)) / 60)>) As 'Heute Tickets' from Telefon_log tl LEFT OUTER JOIN Mitarbeiter m on m.ID=tl.Mitarbeiter where tl.Datum_bis is not null  and  tl.Datum_von>= '{SQL_NOW}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tz.Datum_von, tz.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tz.Datum_bis, tz.Datum_von)) / 60)>) As 'Gestern Telefon' from ticket_zeiten tz LEFT OUTER JOIN Mitarbeiter m on m.ID=tz.Mitarbeiter where tz.Telefon_log IS NULL and tz.Datum_von>='{SQL_YESTERDAY}' and tz.Datum_von<'{SQL_NOW}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tl.Datum_von, tl.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tl.Datum_bis, tl.Datum_von)) / 60)>) As 'Gestern Tickets' from Telefon_log tl LEFT OUTER JOIN Mitarbeiter m on m.ID=tl.Mitarbeiter where tl.Datum_bis is not null  and tl.Datum_von>='{SQL_YESTERDAY}' and tl.Datum_von<'{SQL_NOW}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tz.Datum_von, tz.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tz.Datum_bis, tz.Datum_von)) / 60)>) As 'letzte 7 Tage Telefon' from ticket_zeiten tz LEFT OUTER JOIN Mitarbeiter m on m.ID=tz.Mitarbeiter where tz.Telefon_log IS NULL and tz.Datum_von>= '{SQL_L7DAYS}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tl.Datum_von, tl.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tl.Datum_bis, tl.Datum_von)) / 60)>) As 'letzte 7 Tage Tickets' from Telefon_log tl LEFT OUTER JOIN Mitarbeiter m on m.ID=tl.Mitarbeiter where tl.Datum_bis is not null  and  tl.Datum_von>= '{SQL_L7DAYS}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tz.Datum_von, tz.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tz.Datum_bis, tz.Datum_von)) / 60)>) As 'diesen Monat Telefon' from ticket_zeiten tz LEFT OUTER JOIN Mitarbeiter m on m.ID=tz.Mitarbeiter where tz.Telefon_log IS NULL and tz.Datum_von>= '{SQL_MONTH}' AND m.Fremd_ID={AKTIVE_USER}
Select SUM(<DEF_FOR_MSSQL:datediff(MINUTE,tl.Datum_von, tl.Datum_bis)><DEF_FOR_MYSQL:ceil(TIME_TO_SEC(TIMEDIFF(tl.Datum_bis, tl.Datum_von)) / 60)>) As 'diesen Monat Tickets' from Telefon_log tl LEFT OUTER JOIN Mitarbeiter m on m.ID=tl.Mitarbeiter where tl.Datum_bis is not null  and  tl.Datum_von>= '{SQL_MONTH}' AND m.Fremd_ID={AKTIVE_USER}
