Pendenzen
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', ORDER BY `cargo__bookings`.`pendenz` LIMIT 100' at line 4
Function: CargoSQLQuery::run Query: SELECT `cargo__bookings`.`_pageID` AS `cargo_backlink_page_id_bookings`,`_pageName` AS `Buchung`,DATE_FORMAT(datum, "%e.%b") AS ` `,`itemtype` AS `Art`,`department` AS `Abt.`,LEFT(purpose,25) AS `Zweck`,CONCAT(IF(pound>0, CONCAT(pound,"lb ") ," "),
IF(shilling>0,CONCAT(shilling,"ß ")," "),
IF(denar>0, CONCAT(denar, "dn")," ")
) AS `Betrag`,`person__full` AS `Person(en)` FROM `cargo__bookings` WHERE pendenz IS NOT NULL AND pendenz > "", ORDER BY `cargo__bookings`.`pendenz` LIMIT 100
83 Einträge