Query 1.0.0.0
Aus Stadtarchiv Butzbach
Version vom 23. Mai 2022, 14:26 Uhr von KlausWendel (Diskussion | Beiträge)
Error 42803: FEHLER: Spalte »cargo__ARCHIUM_TABLE_sabu_signatur.ARCHIUM_PROPERTY_sabu_lfdnr« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden
ZEILE 1: ..._signatur"."ARCHIUM_PROPERTY_sabu_ebene4" AS "e4","ARCHIUM_P...
^
Function: CargoSQLQuery::run Query: SELECT "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1" AS "e1","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2" AS "e2","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3" AS "e3","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" AS "e4","ARCHIUM_PROPERTY_sabu_lfdnr" AS "ln" FROM "cargo__ARCHIUM_TABLE_sabu_signatur" WHERE "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1" = 1 GROUP BY "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1",
"cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2", "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3", "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" ORDER BY "cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene1","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene2","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene3","cargo__ARCHIUM_TABLE_sabu_signatur"."ARCHIUM_PROPERTY_sabu_ebene4" LIMIT 250000