5e:Monster List: Difference between revisions
Jump to navigation
Jump to search
No 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) | |where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (5eMonster.Type <>"Overview") | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{srd5lc|Monster}}s | }} {{srd5lc|Monster}}s | ||
Revision as of 20:23, 3 June 2020
< Monster
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'
monsters
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,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__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) AND (`rly2_cargo__5eMonster`.`Type` <>"Overview") ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
Error: No field named "Hidden" found for the database table "Pages_Info".
| Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source |
|---|