Latest revision |
Your text |
Line 1: |
Line 1: |
| __NOTOC__ | | __NOTOC__ |
| {{NavBar|Fellowship of the Ring/Index| [[Main Page]]|[[Promotional/Index|Promotional]]|[[Mines of Moria/Index|Mines of Moria]]}} | | {{NavBar|Fellowship of the Ring Index| [[Main Page]]|[[Promotional Index]]|[[Mines of Moria Index]]}} |
| {{SetTabs}} | | {{SetTabs}} |
|
| |
|
| <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>
| | {{#cargo_query:tables=Cards=C,CardReleases=CR |
| {{ListTable
| | |join on=C.ID = CR.ID |
| |filter= C.SetNum = 1 AND C.Culture = 'Dwarven' | | |fields= |
| |sort= {{StandardSort}} | |
| |columns=3
| |
| }}
| |
|
| |
|
| ----
| | ,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 |
|
| |
|
| | ,C.CardType |
| | ,CONCAT('[[Image:Culture_', C.Culture, '.svg|x20px|text-bottom|link=', C.Culture, '_Culture]] [[', C.Culture, '_Culture|', C.Culture, ']]')=Culture |
|
| |
|
| <big>{{C|Elven}}</big>
| |
| {{ListTable
| |
| |filter= C.SetNum = 1 AND C.Culture = 'Elven'
| |
| |sort= {{StandardSort}}
| |
| |columns=3
| |
| }}
| |
|
| |
|
| ----
| |
|
| |
|
|
| |
|
| <big>{{C|Gandalf}}</big>
| | ,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText |
| {{ListTable
| | |where= C.SetNum = 1 |
| |filter= C.SetNum = 1 AND C.Culture = 'Gandalf'
| | |order by={{StandardSort}} |
| |sort= {{StandardSort}}
| | |limit=400 |
| |columns=3
| | |format=dynamic table |
| }}
| | |rows per page=400 |
| | | |named args= yes |
| ----
| | |default= |
| | | |delimiter= |
| | |
| <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 | |
| }}
| |
| | |
| ----
| |
| | |
| <big>{{C|Sauron}}</big>
| |
| {{ListTable
| |
| |filter= C.SetNum = 1 AND C.Culture = 'Sauron'
| |
| |sort= {{StandardSort}} | |
| |columns=3 | |
| }}
| |
| | |
| ----
| |
| | |
| | |
| <big>{{C|Shire}}</big>
| |
| {{ListTable
| |
| |filter= C.SetNum = 1 AND C.Culture = 'Shire' | |
| |sort= {{StandardSort}}
| |
| |columns=3
| |
| }}
| |
| | |
| | |
| ----
| |
| | |
| | |
| <big>{{C|Site}}</big>
| |
| {{ListTable
| |
| |filter= C.SetNum = 1 AND C.Culture = 'Site'
| |
| |sort= {{StandardSort}} | |
| |columns=3 | |
| }}
| |
| | |
| | |
| ----
| |
| | |
| | |
| <big>[[Oversized]]</big>
| |
| {{ListTable
| |
| |filter= C.SetNum = 1 AND C.Subset = 'M' | |
| |sort=CR.ID, C.CardNum, CR._rowID | |
| }} | | }} |