The City Organizations: Difference between revisions

From Night's End
mNo edit summary
mNo edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
<yambe:breadcrumb>The City</yambe:breadcrumb>
<yambe:breadcrumb>The City</yambe:breadcrumb>


{{#cargo_query:tables=Organizations|fields=CONCAT( '[[', _pageName, ']]' )|where=Parent='The City'|format=category}}
List of organization in [[The City]]:
 
{{#cargo_query:tables=Organizations
  |where=Parent='The City'
  |group by=Name
  |fields=_pageName = Name,Short
  |format=template
  |template=OrganizationCard
  |named args=yes
}}

Latest revision as of 19:26, 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 `_pageName` AS `Name`,`Short` AS `Short` FROM `cargo__Organizations` WHERE Parent='The City' GROUP BY `Name` ORDER BY `_pageName`,`Short` LIMIT 100