5e:Beast List: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
{{#cargo_query: | {{#cargo_query: | ||
table=5eMonster | table=5eMonster | ||
|where=Type="Beast" AND (5eMonster.Hidden=0 OR 5eMonster.Hidden IS NULL) | |where=(5eMonster.Type="Beast" OR 5eMonster.Monster_Tags HOLDS "Beast") AND (5eMonster.Hidden=0 OR 5eMonster.Hidden IS NULL) | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{srd5lc|Beast}}s | }} {{srd5lc|Beast}}s | ||
<div style="overflow:scroll; font-size:0.7em; max-width:80vw; max-height:80vh;"> | <div style="overflow:scroll; font-size:0.7em; max-width:80vw; max-height:80vh;"> | ||
{| | {| class="sortable" | ||
!Monster | !Monster | ||
!Size | !Size | ||
| Line 25: | Line 25: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=Type= | |where=(5eMonster.Type="Beast" OR 5eMonster.Monster_Tags HOLDS "Beast") AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | ||
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Movement_Type,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,5eMonster.Canon,5eMonster.Pointer,5eMonster.UA,Pages_Info.User,Pages_Info.Sources | |fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Movement_Type,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,5eMonster.Canon,5eMonster.Pointer,5eMonster.UA,Pages_Info.User,Pages_Info.Sources | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
Revision as of 21:06, 26 March 2020
< Monster
Error 1054: Unknown column 'rly2_cargo__5eMonster.Hidden' in 'where clause'
beasts
Function: CargoSQLQuery::run Query: SELECT COUNT(`rly2_cargo__5eMonster`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5eMonster` WHERE (`rly2_cargo__5eMonster`.`Type`="Beast" OR `rly2_cargo__5eMonster`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5eMonster__Monster_Tags` WHERE `_value`= "Beast") ) AND (`rly2_cargo__5eMonster`.`Hidden`=0 OR `rly2_cargo__5eMonster`.`Hidden` IS NULL) ORDER BY COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
Error: No field named "Canon" found for the database table "5eMonster".
| Monster | Size | Type | Tags | Alignment | HP | Movement | CR | Marked | Source |
|---|