Grundsteuer 1435

Fehler im Ausdruck: Unerwarteter Operator <

Error 1054: Unknown column 'pourpose' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `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`,IF(person__full>"",CONCAT("",person__full,""),personOrig) AS `Person(en)`,IF(pendenz>"","P"," ") AS `Blank value 1`  FROM `cargo__bookings` `bookings`    WHERE department= 'Grundsteuer' AND year='1435' AND pourpose='Abgabe'  ORDER BY `bookings`.`_pageName` LIMIT 100