Ents of Fangorn/Index: Difference between revisions

From LOTR-TCG Wiki
(Created page with "__NOTOC__ {{NavBar|Ents of Fangorn/Index|Main Page|Battle of Helm's Deep/Index|The Return of the King/Index}} {{SetTabs}} {{#cargo_query:tables=Cards=C,CardRele...")
 
(adding missing sauron)
 
(One intermediate revision by the same user not shown)
Line 5: Line 5:




{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=


,CONCAT('<span class="tooltip">[[',  REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),  '|',  CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
<big>{{C|Dunland}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Dunland'
|sort= {{StandardSort}}
|columns=3
}}


,C.CardType
----
,CONCAT('[[Image:Culture_', C.Culture, '.svg|x20px|text-bottom|link=', C.Culture, '_Culture]] [[', C.Culture, '_Culture|', C.Culture, ']]')=Culture


,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
 
|where= C.SetNum = 6  
<big>{{C|Dwarven}}</big>
|order by={{StandardSort}}
{{ListTable
|limit=400
|filter= C.SetNum = 6 AND C.Culture = 'Dwarven'
|format=dynamic table
|sort= {{StandardSort}}
|rows per page=400
|columns=1
|named args= yes
}}
|default=
 
|delimiter=
----
 
 
<big>{{C|Elven}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Elven'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Gandalf}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Gandalf'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Gollum}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Gollum'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Gondor}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Gondor'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Isengard}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Isengard'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Moria}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Moria'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Raider}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Raider'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Ringwraith}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Ringwraith'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Rohan}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Rohan'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
<big>{{C|Sauron}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Sauron'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Shire}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Shire'
|sort= {{StandardSort}}
|columns=3
}}
 
 
----
 
 
<big>{{C|Site}}</big>
{{ListTable
|filter= C.SetNum = 6 AND C.Culture = 'Site'
|sort= {{StandardSort}}
|columns=3
}}
}}

Latest revision as of 05:52, 6 March 2022

Battle of Helm's Deep/Index
Back to Main Page
The Return of the King/Index



Dunland





Dwarven





Elven





Gandalf





Gollum





Gondor





Isengard





Moria





Raider





Ringwraith





Rohan




Sauron





Shire






Site