Ask MS: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
|tables=RefsInt1 | |tables=RefsInt1 | ||
| fields=MS_PublicationClusterID | | fields=MS_PublicationClusterID | ||
| where=table1. | | where=table1.MS_PublicationClusterID='0' | ||
| limit=5000 | | 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)
