Zandbak/Sub-zandbak3
Database (Cargo) queries
Function: CargoSQLQuery::run Query: SELECT `cargo__Authors`.`_pageID` AS `cargo_backlink_page_id_Authors`,`cargo__Books`.`_pageID` AS `cargo_backlink_page_id_Books`,`cargo__Books`.`_pageName` AS `_pageName`,`cargo__Books__Authors`.`_value` AS `Authors`,`cargo__Authors`.`_pageTitle` AS `_pageTitle`,`cargo__Authors`.`Country` AS `Country` 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__Authors`.`_value_pageID`,`cargo__Books`.`_pageID`,`cargo__Books`.`_pageName`,`cargo__Books__Authors`.`_value`,`cargo__Books__Authors`.`_value_pageTitle` LIMIT 100