The City Organizations: Difference between revisions

From Night's End
mNo edit summary
mNo edit summary
Line 7: Line 7:
   |where=Parent='The City'
   |where=Parent='The City'
   |group by=Name
   |group by=Name
   |format=ul
   |format=template
   |columns=3
   |template=OrganizationCard
}}
}}

Revision as of 19:24, 15 July 2023

The City > The City Organizations

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