Dicemonger (talk | contribs) mNo edit summary |
Dicemonger (talk | contribs) mNo edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
{{#cargo_query:tables=Organizations | {{#cargo_query:tables=Organizations | ||
|where=Parent='The City' | |where=Parent='The City' | ||
|group by=Name | |group by=Name | ||
|format= | |fields=_pageName = Name,Short | ||
|format=template | |||
|template=OrganizationCard | |||
|named args=yes | |||
}} | }} | ||
Latest revision as of 19:26, 15 July 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 `_pageName` AS `Name`,`Short` AS `Short` FROM `cargo__Organizations` WHERE Parent='The City' GROUP BY `Name` ORDER BY `_pageName`,`Short` LIMIT 100