Bestandsordnung
Ordnung in Reihenfolge der Klassifikation
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_PROPERTY_maingroup_assignment" AS "Hauptgruppe","ARCHIUM_PROPERTY_dateString" AS "Laufzeiten" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_title" "t" ON (("s"."_ID"="t"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup" "mg" ON (("s"."_ID"="mg"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup_priority" "mgp" ON (("s"."_ID"="mgp"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_date_of_creation1" "d" ON (("s"."_ID"="d"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_ID"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' 0+1 ORDER BY CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ),"ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_maingroup_assignment","ARCHIUM_PROPERTY_dateString" LIMIT 100 Function: CargoSQLQuery::run Error: 42601 FEHLER: Syntaxfehler bei »0« LINE 1: ...D"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' 0+1 ORDER...
^
<1| AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}
|format=tree |searchable columns=title |rows per page=500 |limit=500 |order by=mgp."ARCHIUM_PROPERTY_maingroup_priority" ASC,s."ARCHIUM_PROPERTY_ID" ASC }}