Ask MS: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=RefsInt1 | tables=RefsInt1 | ||
|fields=MS_PublicationClusterID | | fields=_pageName,MS_PublicationClusterID | ||
|where=table1.field1='0' | | where=table1.field1='0' | ||
| limit=5000 | | limit=5000 | ||
| format=list | | format=list | ||
Revision as of 21:02, 23 April 2020
Error 1054: Unknown column 'table1.field1' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`_pageName` AS `_pageName`,`MS_PublicationClusterID` AS `MS PublicationClusterID` FROM `mw_cargo__RefsInt1` WHERE table1.field1='0' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`_pageName`,`MS_PublicationClusterID` LIMIT 1000
Lab-0005 (Labtitle: Sediment Supply to the Global Ocean, LabCOModule: 1 of 1)
