Ask MS: Difference between revisions

From CSDMS
No edit summary
No edit summary
Line 3: Line 3:
| fields=MS_PublicationClusterID
| fields=MS_PublicationClusterID
| where=table1.MS_PublicationClusterID='0'
| where=table1.MS_PublicationClusterID='0'
| limit=5000
| format=list
| format=list
}}
}}

Revision as of 21:03, 23 April 2020

Error 1054: Unknown column 'table1.MS_PublicationClusterID' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`MS_PublicationClusterID` AS `MS PublicationClusterID` FROM `mw_cargo__RefsInt1` WHERE table1.MS_PublicationClusterID='0' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`MS_PublicationClusterID` LIMIT 1000



Lab-0005 (Labtitle: Sediment Supply to the Global Ocean, LabCOModule: 1 of 1)