Template:MonsterListLinks

From Epic Paths
Revision as of 13:34, 20 November 2021 by Admin (talk | contribs)
Jump to navigation Jump to search

Either

  • type: type that should be included (optional)
  • subtype: type that should be included (optional)

or

  • where: a where statement

{{MonsterListLinks|type=magical beast}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE Type = "magical beast" GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100

{{MonsterListLinks|subtype=undead}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "undead") GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100

{{MonsterListLinks|where=Subtypes HOLDS "human"}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "human") GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100


Retrieved from "http://epicpaths.games/epicpaths/index.php?title=Template:MonsterListLinks&oldid=2856"