2021-12-12T21:16:08+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:19:01+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:19:03+00:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS `lastnummer` FROM `projekt`
2021-12-12T21:19:34+00:00 NOTICE (5): ProjekteTable - SQL: SELECT MAX(projektnummer) AS `lastnummer` FROM `projekt`
2021-12-12T21:19:34+00:00 NOTICE (5): KundenTable - SQL: SELECT `kunde`.`uid` AS `uid`, `kunde`.`name` AS `name` FROM `kunde` ORDER BY `name` ASC
2021-12-12T21:19:34+00:00 NOTICE (5): ProjekteTable - SQL: SELECT `projektstatus`.`uid` AS `uid`, `projektstatus`.`name` AS `name` FROM `projektstatus` ORDER BY `key` ASC
2021-12-12T21:19:34+00:00 NOTICE (5): ProjekteTable - SQL: SELECT `p`.*, `k`.`name` AS `kunde`, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname`, `s`.`name` AS `status`, `s`.`key` AS `class` FROM `projekt` AS `p` INNER JOIN `kunde` AS `k` ON `p`.`uid_kunde` = `k`.`uid` INNER JOIN `benutzer` AS `b` ON `p`.`angelegt_von` = `b`.`uid` INNER JOIN `projektstatus` AS `s` ON `p`.`uid_projektstatus` = `s`.`uid` WHERE `p`.`archiv` = ? ORDER BY `name` ASC
2021-12-12T21:19:46+00:00 NOTICE (5): LeistungenTable - SQL: SELECT `l`.*, `p`.`name` AS `projektname`, `p`.`projektnummer` AS `projektnummer`, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname`, `k`.`name` AS `kunde` FROM `leistung` AS `l` INNER JOIN `projekt` AS `p` ON `l`.`uid_projekt` = `p`.`uid` INNER JOIN `benutzer` AS `b` ON `l`.`angelegt_von` = `b`.`uid` INNER JOIN `kunde` AS `k` ON `k`.`uid` = `p`.`uid_kunde` WHERE `l`.`ist_fakturiert` = ?
2021-12-12T21:20:11+00:00 NOTICE (5): LeistungenTable - SQL: SELECT `l`.*, `p`.`name` AS `projektname`, `p`.`projektnummer` AS `projektnummer`, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname`, `k`.`name` AS `kunde` FROM `leistung` AS `l` INNER JOIN `projekt` AS `p` ON `l`.`uid_projekt` = `p`.`uid` INNER JOIN `benutzer` AS `b` ON `l`.`angelegt_von` = `b`.`uid` INNER JOIN `kunde` AS `k` ON `k`.`uid` = `p`.`uid_kunde` WHERE `l`.`ist_fakturiert` = ?
2021-12-12T21:22:18+00:00 NOTICE (5): LeistungenTable - SQL: SELECT `l`.*, `p`.`name` AS `projektname`, `p`.`projektnummer` AS `projektnummer`, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname`, `k`.`name` AS `kunde` FROM `leistung` AS `l` INNER JOIN `projekt` AS `p` ON `l`.`uid_projekt` = `p`.`uid` INNER JOIN `benutzer` AS `b` ON `l`.`angelegt_von` = `b`.`uid` INNER JOIN `kunde` AS `k` ON `k`.`uid` = `p`.`uid_kunde` WHERE `l`.`ist_fakturiert` = ?
2021-12-12T21:22:19+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:22:23+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:22:23+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-12-01' AND l.endzeit <= '2021-12-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:22:23+00:00 ERR (3): AuswertungenTable - Error: Statement couldn't be produced with sql: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-12-01' AND l.endzeit <= '2021-12-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:33:08+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:33:08+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-12-01' AND l.endzeit <= '2021-12-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:33:08+00:00 ERR (3): AuswertungenTable - Error: Prepared statement needs to be re-prepared
2021-12-12T21:33:52+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:33:52+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-12-01' AND l.endzeit <= '2021-12-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:33:52+00:00 ERR (3): AuswertungenTable - Error: Prepared statement needs to be re-prepared
2021-12-12T21:37:41+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:37:58+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:37:58+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-03-01' AND l.endzeit <= '2021-03-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:37:58+00:00 ERR (3): AuswertungenTable - Error: Prepared statement needs to be re-prepared
2021-12-12T21:38:35+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:38:35+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-03-01' AND l.endzeit <= '2021-03-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:38:35+00:00 ERR (3): AuswertungenTable - Error: Prepared statement needs to be re-prepared
2021-12-12T21:39:50+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:39:50+00:00 NOTICE (5): AuswertungenTable - SQL: SELECT `l`.* FROM `V_LEISTUNGEN_MIT_UMSATZ` AS `l` WHERE `l`.`kunden_nummer` = ? AND l.startzeit >= '2021-03-01' AND l.endzeit <= '2021-03-31' ORDER BY `l`.`datum` ASC, `l`.`startzeit` ASC
2021-12-12T21:39:50+00:00 ERR (3): AuswertungenTable - Error: Prepared statement needs to be re-prepared
2021-12-12T21:40:37+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC
2021-12-12T21:40:40+00:00 NOTICE (5): LeistungenTable - SQL: SELECT `l`.*, `p`.`name` AS `projektname`, `p`.`projektnummer` AS `projektnummer`, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname`, `k`.`name` AS `kunde` FROM `leistung` AS `l` INNER JOIN `projekt` AS `p` ON `l`.`uid_projekt` = `p`.`uid` INNER JOIN `benutzer` AS `b` ON `l`.`angelegt_von` = `b`.`uid` INNER JOIN `kunde` AS `k` ON `k`.`uid` = `p`.`uid_kunde` WHERE `l`.`ist_fakturiert` = ?
2021-12-12T21:40:42+00:00 NOTICE (5): KundenTable - SQL: SELECT `k`.*, `b`.`vorname` AS `vorname`, `b`.`nachname` AS `nachname` FROM `kunde` AS `k` INNER JOIN `benutzer` AS `b` ON `k`.`angelegt_von` = `b`.`uid` WHERE `k`.`archiv` = ? ORDER BY `k`.`name` ASC