Query 1.0.0.0

Aus Stadtarchiv Butzbach
Wechseln zu: Navigation, Suche
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