Template:MonsterListLinks

One of:

type: type that should be included
subtype: type that should be included
where: a where statement

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

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=Type = "humanoid" AND 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 Type = "humanoid" AND `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "human") GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100

Template:MonsterListLinks

Navigation menu

Search