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=field1=MS_PublicationClusterID
|fields=MS_PublicationClusterID
|where=table1.field1='0'
|where=table1.field1='0'
| limit=5000
| limit=5000

Revision as of 21:00, 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`,`MS_PublicationClusterID` AS `MS PublicationClusterID` FROM `mw_cargo__RefsInt1` WHERE table1.field1='0' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`MS_PublicationClusterID` LIMIT 1000



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