The Fellowship of the Ring/Index: Difference between revisions

From LOTR-TCG Wiki
(Added tengwar)
(Adding oversized section to index)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
__NOTOC__
__NOTOC__
{{NavBar|Fellowship of the Ring Index| [[Main Page]]|[[Promotional Index]]|[[Mines of Moria Index]]}}
{{NavBar|Fellowship of the Ring/Index| [[Main Page]]|[[Promotional/Index|Promotional]]|[[Mines of Moria/Index|Mines of Moria]]}}
{{SetTabs}}


Here you will find every card in the [[Fellowship of the Ring]] set. Please see that page for additional information.
<big>{{C|The One Ring}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.CardType = 'The One Ring'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
<big>{{C|Dwarven}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Dwarven'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Elven}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Elven'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Gandalf}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Gandalf'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Gondor}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Gondor'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Isengard}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Isengard'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Moria}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Moria'
|sort= {{StandardSort}}
|columns=3
}}
 
----
 
 
<big>{{C|Ringwraith}}</big>
{{ListTable
|filter= C.SetNum = 1 AND C.Culture = 'Ringwraith'
|sort= {{StandardSort}}
|columns=3
}}


= Standard Cards =
----


{{#cargo_query:tables=Cards=C,CardReleases=CR
<big>{{C|Sauron}}</big>
|join on=C.ID = CR.ID
{{ListTable
|fields=CR.ID=CardID
|filter= C.SetNum = 1 AND C.Culture = 'Sauron'
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|sort= {{StandardSort}}
,C.Subset
|columns=3
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'S'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
|no html
}}
}}


= Oversized Cards =
----


{{#cargo_query:tables=Cards=C,CardReleases=CR
 
|join on=C.ID = CR.ID
<big>{{C|Shire}}</big>
|fields=CR.ID=CardID
{{ListTable
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|filter= C.SetNum = 1 AND C.Culture = 'Shire'
,C.Subset
|sort= {{StandardSort}}
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|columns=3
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'M'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
|no html
}}
}}


= Tengwar Anthology =


{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=ECR
----
|join on=C.ID = CR.BaseCardID,C.ID = ECR.ID
 
|fields=CR.ID=CardID
 
,IFNULL(IFNULL(ECR.FormattedGameText, ECR.GameText),'')=GameText
<big>{{C|Site}}</big>
,C.Subset
{{ListTable
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|filter= C.SetNum = 1 AND C.Culture = 'Site'
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
|sort= {{StandardSort}}
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
|columns=3
,C.Culture
}}
,C.CardType
 
,''=CardSubtype
 
,ECR.Title=Title
----
,ECR.Subtitle=Subtitle
 
,ECR.SiteNum
 
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
<big>[[Oversized]]</big>
|where= C.SetNum = 1 AND CR.LanguageCode = 'TW'
{{ListTable
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|filter= C.SetNum = 1 AND C.Subset = 'M'
|limit=400
|sort=CR.ID, C.CardNum, CR._rowID
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
|no html
}}
}}

Latest revision as of 01:57, 21 January 2023

Promotional
Back to Main Page 		Mines of Moria
Set Info
Index
Thumbs
Product

The One Ring



Dwarven




Elven




Gandalf




Gondor




Isengard




Moria




Ringwraith



Sauron




Shire





Site





Oversized



Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=The_Fellowship_of_the_Ring/Index&oldid=120732"