Pendenzen: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: «__NOCACHE__ {{#cargo_query: tables=bookings |fields=_pageName=Name, pendenz=Pendenz }} {{#cargo_query: tables=bookings |fields=_pageName=Buchung, DATE_FORMAT(datum, "%e.%b")= , itemtype=Art, department=Abt., LEFT(purpose,25)=Zweck, CONCAT(IF(pound>0, CONCAT(pound,"lb ") ," "), IF(shilling>0,CONCAT(shilling,"ß ")," "), IF(denar>0, CONCAT(denar, "dn")," …») |
Keine Bearbeitungszusammenfassung |
||
| Zeile 16: | Zeile 16: | ||
)=Betrag, | )=Betrag, | ||
person=Person(en), | person=Person(en), | ||
|where=pendenz > "" | |where=pendenz > "", | ||
|limit=200 | |limit=200 | ||
|order by=bookings._pageName | |order by=bookings._pageName | ||
|default=Keine Buchungen | |default=Keine Buchungen mit eingetragenen Problemen | ||
}} | }} | ||
{{#cargo_query: | {{#cargo_query: | ||
Version vom 10. August 2024, 12:56 Uhr
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`.`_pageName` 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 > "", ORDER BY `cargo__bookings`.`_pageName` LIMIT 100
83 Einträge