User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 3: | Line 3: | ||
|fields= | |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 | ,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 | ||
|where= | |where=C.CardType = 'Ally' AND C.Culture = 'elven' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 07:52, 14 February 2022
- Celeborn, Lord of Lorien (1R34)
- Elrond, Lord of Rivendell (1R40)
- Galadriel, Lady of Light (1R45)
- Orophin, Lorien Bowman (1U56)
- Rúmil, Elven Protector (1U57)
- Silinde, Elf of Mirkwood (1U60)
- Uruviel, Maid of Lorien (1C67)
- Calaglin, Elf of Lorien (3U10)
- Dínendal, Silent Scout (3U12)
- Elrond, Herald to Gil-galad (3R13)
- Erestor, Chief Advisor to Elrond (3C14)
- Galadriel, Lady of the Golden Wood (3R17)
- Galdor, Councilor From the West (3U18)
- Golradir, Councilor of Imladris (3U20)
- Saelbeth, Elven Councilor (3U25)
- Elrond, Keeper of Vilya (6R15)
- Galadriel, Keeper of Nenya (6R18)
- Elrond, Elven Lord (30P21)
- Elrond, Elven Lord (30S21)
- Rivendell Scout (30HK51)
- Elf Army (31HD8)
- Legolas, Prince of Mirkwood (31HD9)
- Tauriel, Staunch Defender (31HD10)
- Thranduil, Elven King (31HD12)
- Galadriel, Elven Lady (32HG13)