Template:MonsterQuery
{{MonsterQuery|CR=1|Race=human}}
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__Terrain` WHERE `_value`= "Any") OR `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Terrain` WHERE `_value`= "Mountains") OR `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Terrain` WHERE `_value`= "Underground") ) AND(1) GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Page`,`Name` AS `Name`,`Fluff` AS `Fluff`,`Alignment` AS `Alignment`,`Size` AS `Size`,`Type` AS `Type`,`Subtypes__full` AS `Subtypes`,`CR` AS `CR`,`XP` AS `XP`,`Init` AS `Init`,`Perception` AS `Perception`,`Senses` AS `Senses`,`Speed` AS `Speed`,`hp` AS `hp`,`hpBonus` AS `hpBonus`,`AC` AS `AC`,`TouchAC` AS `TouchAC`,`FlatfootedAC` AS `FlatfootedAC`,`ACBonus` AS `ACBonus`,`Fort` AS `Fort`,`Reflex` AS `Reflex`,`Will` AS `Will`,`saveBonus` AS `saveBonus`,`SR` AS `SR`,`DR` AS `DR`,`CMB` AS `CMB`,`AltCMB` AS `AltCMB`,`CMD` AS `CMD`,`AltCMD` AS `AltCMD`,`MMD` AS `MMD`,`AltMMD` AS `AltMMD`,`Tenacity` AS `Tenacity`,`AltTenacity` AS `AltTenacity`,`SP` AS `SP`,`MSB` AS `MSB`,`AltMSB` AS `AltMSB`,`MSD` AS `MSD`,`AltMSD` AS `AltMSD`,`Concentration` AS `Concentration`,`Immune` AS `Immune`,`StandardActions` AS `StandardActions`,`FullroundActions` AS `FullroundActions`,`MoveActions` AS `MoveActions`,`SwiftActions` AS `SwiftActions`,`ImmediateActions` AS `ImmediateActions`,`FreeActions` AS `FreeActions`,`SpecialQualities` AS `SpecialQualities`,`Skills` AS `Skills`,`Strength` AS `Str`,`Dexterity` AS `Dex`,`Constitution` AS `Con`,`Intelligence` AS `Int`,`Wisdom` AS `Wis`,`Charisma` AS `Cha`,`Equipment` AS `Equipment` FROM `cargo__Monsters` WHERE (`cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Terrain` WHERE `_value`= "Any") OR `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Terrain` WHERE `_value`= "Mountains") OR `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Terrain` WHERE `_value`= "Underground") ) AND(1) GROUP BY `Name` ORDER BY `Name` LIMIT 100
This template adds rows to the table "Monsters", which is declared by the template Monster. View table. (It actually doesn't. It is used to query the table.)