View source for Template:5e24 Adventure Creatures List/Xref UL

<includeonly>'''Creatures:'''<br />
{{#cargo_query:
tables=5e_Adventure_Creature_xRef, 5e24_Creature, Pages_Info
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5e24_Creature.Creature, 5e24_Creature._pageName = Pages_Info._pageName
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND (5e24_Creature.Individual = NULL OR 5e24_Creature.Individual = 0)
|fields=COUNT(5e24_Creature._pageName)
}} creatures in {{pub|{{{1|}}}}}.
<div style="overflow:auto; font-size:0.8em; max-width:75svw; <!--max-height:90vh;--> columns:3;">
{{#cargo_query:
table=5e_Adventure_Creature_xRef
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}"
|fields=5e_Adventure_Creature_xRef.Creature
|order by=5e_Adventure_Creature_xRef.Creature
<!--|format=ul-->
|format=template
|template=5e24 Adventure Creatures List/Xref UL Creature
|limit=1000
|more results text=More Creatures
}}
</div>


'''Individuals:'''<br />
{{#cargo_query:
tables=5e_Adventure_Creature_xRef, 5e24_Creature, Pages_Info
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5e24_Creature.Creature, 5e24_Creature._pageName = Pages_Info._pageName
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5e24_Creature.Individual = TRUE
|fields=COUNT(5e24_Creature._pageName)
}} individuals in {{pub|{{{1|}}}}}.
<div style="overflow:auto; font-size:0.8em; max-width:75svw; <!--max-height:90vh;--> columns:3;">
{{#cargo_query:
tables=5e_Adventure_Creature_xRef, 5e24_Creature, Pages_Info
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5e24_Creature.Creature, 5e24_Creature._pageName = Pages_Info._pageName
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5e24_Creature.Individual = TRUE
|fields=5e24_Creature._pageName,5e24_Creature.Creature,5e24_Creature.Type,5e24_Creature.Individual
|order by=5e24_Creature.Sort_Text
<!--|format=ul-->
|format=template
|template=Template:5e24 Adventure Creatures List/UL Format
|named args=yes
|limit=1000
|more results text=More Creatures
}}
</div></includeonly><noinclude>{{template badge}}
==Syntax==
<pre>{{5e24 Adventure Creatures List/Xref UL|adventure}}</pre>

==Example==
<pre>{{5e24 Adventure Creatures List/Xref UL|Death at Sunset}}</pre>

{{5e24 Adventure Creatures List/Xref UL|Death at Sunset}}

[[Category:5e24 Templates]]
</noinclude>