Dicemonger (talk | contribs) mNo edit summary |
Dicemonger (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
List of organization in [[The City]]: | List of organization in [[The City]]: | ||
{{#cargo_query:tables=Organizations|fields=CONCAT( '[[', _pageName, ']]' )|where=Parent='The City'|format=category}} | {{#cargo_query:tables=Organizations | ||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Organizations | |||
|where=Parent='The City' | |||
|group by=Name | |||
|format=category | |||
}} | |||
Revision as of 09:43, 11 June 2023
List of organization in The City:
Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ne_wiki.cargo__Organizations._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `Organizations` FROM `cargo__Organizations` WHERE Parent='The City' GROUP BY `Name` ORDER BY CONCAT( '', Name, '' ) LIMIT 100