Dicemonger (talk | contribs) (Created page with "<yambe:breadcrumb>Main_Page|Front Page</yambe:breadcrumb> {{#cargo_query:tables=Organizations |fields=CONCAT( '', Name, '' ) = Organization |group by=Name |format=ul |columns=3 }}") |
Dicemonger (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
<yambe:breadcrumb>Main_Page|Front Page</yambe:breadcrumb> | <yambe:breadcrumb>Main_Page|Front Page</yambe:breadcrumb> | ||
== Organizations of The City == | |||
{{#cargo_query:tables=Organizations | {{#cargo_query:tables=Organizations | ||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Organization | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Organization | ||
|where=Parent='The City' | |||
|group by=Name | |group by=Name | ||
|format=ul | |format=ul | ||
|columns=3 | |columns=3 | ||
|default=None found | |||
}} | |||
== Other Organizations == | |||
{{#cargo_query:tables=Organizations | |||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Organization | |||
|where=Parent!='The City' | |||
|group by=Name | |||
|format=ul | |||
|columns=3 | |||
|default=None found | |||
}} | }} | ||
Latest revision as of 13:14, 11 June 2023
Organizations of 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 `Organization` FROM `cargo__Organizations` WHERE Parent='The City' GROUP BY `Name` ORDER BY CONCAT( '', Name, '' ) LIMIT 100
Other Organizations
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 `Organization` FROM `cargo__Organizations` WHERE Parent!='The City' GROUP BY `Name` ORDER BY CONCAT( '', Name, '' ) LIMIT 100