Template:5e Adventure Creatures List/Xref UL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<includeonly>{{#cargo_query: tables=5e_Adventure_Creature_xRef, 5eMonster |join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name |where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" |fields=COUNT(5eMonster._pageName) }} creatures in {{{1|}}}. <div style="overflow:auto; font-size:0.8em; max-width:90vw; max-height:90vh; columns:3;"> {{#cargo_query: tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info |join on=5e_Adventure_Creature_xRef.Creature H...") |
No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query: | <includeonly>'''Creatures:'''<br /> | ||
tables=5e_Adventure_Creature_xRef, 5eMonster | {{#cargo_query: | ||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name | tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | ||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" | |join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | ||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND (5eMonster.Individual = NULL OR 5eMonster.Individual = 0) | |||
|fields=COUNT(5eMonster._pageName) | |||
}} creatures in {{{1|}}}. | |||
<div style="overflow:auto; font-size:0.8em; max-width:90vw; max-height:90vh; columns:3;"> | |||
{{#cargo_query: | |||
tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | |||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND (5eMonster.Individual = NULL OR 5eMonster.Individual = 0) | |||
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Type,5eMonster.Individual | |||
|order by=5eMonster.Sort_Text | |||
<!--|format=ul--> | |||
|format=template | |||
|template=Template:5e Adventure Creatures List/UL Format | |||
|named args=yes | |||
|limit=1000 | |||
|more results text=More Creatures | |||
}} | |||
</div> | |||
'''Individuals:'''<br /> | |||
{{#cargo_query: | |||
tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | |||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5eMonster.Individual = TRUE | |||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} creatures in {{{1|}}}. | }} creatures in {{{1|}}}. | ||
| Line 9: | Line 32: | ||
tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | ||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | ||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" | |where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5eMonster.Individual = TRUE | ||
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Type,5eMonster.Individual | |fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Type,5eMonster.Individual | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
Revision as of 05:16, 30 May 2024
Syntax
{{Template:5e Adventure Creatures List/Xref UL|adventure}}
Normally type is not used and only one subtype is specified.
Example
{{Template:5e Adventure Creatures List/Xref UL|Danger at Dunwater}}
Creatures:
16 creatures in The Sinister Secret of Saltmarsh.
Individuals:
7 creatures in The Sinister Secret of Saltmarsh.