Template:MonsterListLinks
Jump to navigation
Jump to search
One (and only one) of the following
- type: type that should be included
- 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|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