Zandbak/Sub-zandbak3: verschil tussen versies
< Zandbak
Naar navigatie springen
Naar zoeken springen
(Nieuwe pagina aangemaakt met '== Database (Cargo) queries ==') |
|||
| Regel 1: | Regel 1: | ||
== Database (Cargo) queries == | == Database (Cargo) queries == | ||
{{#cargo_query: | |||
tables=Books,Authors | |||
|join on=Books.Authors HOLDS Authors._pageName | |||
|fields=Books._pageName, Books.Authors, Authors._pageName | |||
}} | |||
Versie van 3 jul 2022 15:23
Database (Cargo) queries
Error 1054: Unknown column 'cargo__Books__Authors._value_pageID' in 'order clause'
Function: CargoSQLQuery::run Query: SELECT `cargo__Books`.`_pageID` AS `cargo_backlink_page_id_Books`,`cargo__Authors`.`_pageID` AS `cargo_backlink_page_id_Authors`,`cargo__Authors`.`_pageName` AS `_pageName`,`cargo__Books__Authors`.`_value` AS `Authors` FROM `cargo__Books` LEFT OUTER JOIN `cargo__Books__Authors` ON ((`cargo__Books`.`_ID`=`cargo__Books__Authors`.`_rowID`)) RIGHT OUTER JOIN `cargo__Authors` ON ((`cargo__Books__Authors`.`_value`=`cargo__Authors`.`_pageName`)) ORDER BY `cargo__Books`.`_pageID`,`cargo__Books__Authors`.`_value_pageID`,`cargo__Books__Authors`.`_value_pageName`,`cargo__Books__Authors`.`_value` LIMIT 100