Test cargo1: Difference between revisions
From CSDMS
No edit summary |
No edit summary Tag: Reverted |
||
| Line 4: | Line 4: | ||
|join on=BibEntryCargo._pageName = _pageData._pageName | |join on=BibEntryCargo._pageName = _pageData._pageName | ||
|fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*) | |fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*),SUM(COUNT(*)) | ||
|limit=5000 | |limit=5000 | ||
Revision as of 10:53, 24 October 2021
Error 1111: Invalid use of group function (localhost)
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__BibEntryCargo`.`_pageID` AS `cargo_backlink_page_id_BibEntryCargo`,`mw_cargo__BibEntryCargo`.`_pageName` AS `_pageData._creationDate`,COUNT(*),SUM(COUNT(*)) FROM `mw_cargo__BibEntryCargo` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`mw_cargo__BibEntryCargo`.`_pageName`=`mw_cargo___pageData`.`_pageName`)) WHERE `mw_cargo___pageData`.`_creationDate` LIKE '%2021%' GROUP BY `mw_cargo__BibEntryCargo`.`_pageName` ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`,`mw_cargo__BibEntryCargo`.`_pageName`,COUNT(*),SUM(COUNT(*)) LIMIT 50000
