5e:Beast List: Difference between revisions
No edit summary |
mNo edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
<div class="gi-main"> | <div class="gi-main"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=5eMonster, Pages_Info | |||
|where=(5eMonster.Type="Beast" OR 5eMonster.Monster_Tags HOLDS "Beast") AND ( | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=(5eMonster.Type="Beast" OR 5eMonster.Monster_Tags HOLDS "Beast") AND (Pages_Info.Hidden=0 OR Pages_Info.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" | {| class="zebra sortable" | ||
!Beast | !Beast | ||
!Size | !Size | ||
| Line 26: | Line 27: | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=(5eMonster.Type="Beast" OR 5eMonster.Monster_Tags HOLDS "Beast") AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |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, | |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,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
|format=template | |format=template | ||
|template=5e Beast List Row | |template=5e Beast List Row <!--expanded--> | ||
|limit=1000 | |limit=1000 | ||
|more results text=More Beasts | |more results text=More Beasts | ||
Latest revision as of 20:29, 5 May 2020
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__5eMonster`.`Type`="Beast" OR `rly2_cargo__5eMonster`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5eMonster__Monster_Tags` WHERE `_value`= "Beast") ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
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`,`rly2_cargo__5eMonster`.`_pageName` AS `_pageName`,`rly2_cargo__5eMonster`.`Monster_Name` AS `Monster Name`,`rly2_cargo__5eMonster`.`Monster_Size` AS `Monster Size`,`rly2_cargo__5eMonster`.`Type` AS `Type`,`Monster_Tags__full` AS `Monster Tags`,`rly2_cargo__5eMonster`.`Monster_Alignment` AS `Monster Alignment`,`rly2_cargo__5eMonster`.`Hit_Points` AS `Hit Points`,`rly2_cargo__5eMonster`.`Hit_Dice` AS `Hit Dice`,`Movement_Type__full` AS `Movement Type`,`rly2_cargo__5eMonster`.`Challenge_Rating` AS `Challenge Rating`,`rly2_cargo__5eMonster`.`Experience_Points` AS `Experience Points`,`Monster_Features__full` AS `Monster Features`,`rly2_cargo__Pages_Info`.`Canon` AS `Canon`,`rly2_cargo__Pages_Info`.`Pointer` AS `Pointer`,`rly2_cargo__Pages_Info`.`UA` AS `UA`,`rly2_cargo__Pages_Info`.`User` AS `User`,`Sources__full` AS `Sources` 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`.`Type`="Beast" OR `rly2_cargo__5eMonster`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5eMonster__Monster_Tags` WHERE `_value`= "Beast") ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__5eMonster`.`Sort_Text` LIMIT 100
| Beast | Size | Type | Tags | Alignment | HP | Movement | CR | Marked | Source |
|---|