W&T-Schlagworte: Unterschied zwischen den Versionen
| Zeile 14: | Zeile 14: | ||
|rows per page=500 | |rows per page=500 | ||
|limit=500 | |limit=500 | ||
| − | |order by= | + | |order by=in."ARCHIUM_PROPERTY_INDEX_nameList" ASC,s."ARCHIUM_PROPERTY_ID" ASC |
}} | }} | ||
Version vom 28. Februar 2020, 15:07 Uhr
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_INDEX_subject" AS "Name" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_locationList" "il" ON (("s"."_pageName"="il"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_nameList" "in" ON (("s"."_pageName"="in"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_subjectList" "is" ON (("s"."_pageName"="is"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_pageName"="r"."_pageName")) ORDER BY in."ARCHIUM_PROPERTY_INDEX_nameList",s."ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42601 ERROR: syntax error at or near "in" LINE 1: ...N (("s"."_pageName"="r"."_pageName")) ORDER BY in."ARCHIU...
^