Zum Inhalt springen

Sammel-Buchungen

Aus WeihnachtsRechnungen
Error: invalid field alias "Abt."; aliases cannot contain dots or quotes.
Error 1054: Unknown column 'bookings.itemkind' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `bookings`.`_pageID` AS `cargo_backlink_page_id_bookings`,CONCAT(COUNT(*)," Einträge") AS `Blank value 1`,CONCAT("Total in Denar: ",Sum(valDenar)) AS `Blank value 2` FROM `cargo__bookings` `bookings` WHERE `bookings`.`itemkind` = 'Sammel-Buchung' ORDER BY `bookings`.`_pageID`,CONCAT(COUNT(*)," Einträge"),CONCAT("Total in Denar: ",Sum(valDenar)) LIMIT 100