5e:Monster List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 7: Line 7:
tables=5eMonster, Pages_Info
tables=5eMonster, Pages_Info
|join on=5eMonster._pageName=Pages_Info._pageName
|join on=5eMonster._pageName=Pages_Info._pageName
<!--|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (5eMonster.Type <>"Overview")-->
|where=5eMonster.Named_NPC=0
|fields=COUNT(5eMonster._pageName)
|fields=COUNT(5eMonster._pageName)
}} {{srd5lc|Monster}}s
}} {{srd5lc|Monster}}s (not including {{5ed|Named NPC}}s)
<div style="overflow:auto; font-size:0.7em; max-width:90vw; max-height:90vh;">
<div style="overflow:auto; font-size:0.7em; max-width:90vw; max-height:90vh;">
{|class="zebra sortable"  
{|class="zebra sortable"  
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=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)-->
|where=5eMonster.Named_NPC=0
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden
|order by=5eMonster.Sort_Text
|order by=5eMonster.Sort_Text

Revision as of 20:47, 7 October 2021

< Monster

D&D 5e Varied ʰ 
See sections for licenses


Error 1054: Unknown column 'rly2_cargo__5eMonster.Named_NPC' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT COUNT(`rly2_cargo__5eMonster`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5eMonster` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5eMonster`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE `rly2_cargo__5eMonster`.`Named_NPC`=0 ORDER BY COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100

monsters (not including Named NPCs)
Error: No field named "Hidden" found for the database table "Pages_Info".
Monster Size Type Tags Alignment HP CR Marked Source

Related Pages

Retrieved from "https://wiki.rlyehable.com/index.php?title=5e:Monster_List&oldid=13129"