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=CR.GameText LIKE '%Aragorn%' | |where=CR.GameText LIKE '%Aragorn%' AND CR.Title != 'Aragorn' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 07:51, 2 January 2022
- Aragorn’s Bow (1R90)
- Arwen's Fate (1R93)
- The Choice of Lúthien (1R100)
- One Whom Men Would Follow (1U109)
- Ranger’s Sword (1U112)
- Valiant Man of the West (1R118)
- The Weight of a Legacy (1R282)
- The Prancing Pony (1U324)
- No Mere Ranger (2R36)
- Pippin, Mr. Took (2C110)
- Gift of the Evenstar (3R19)
- Voice of Rauros (3U47)
- Can You Protect Me From Yourself? (3R50)
- Hard Choice (4U123)
- Ranger's Sword, Blade of Aragorn (4U132)
- Beyond Dark Mountains (4C141)
- The Riddermark (4U328)
- Hornburg Courtyard (4U350)
- These Are My People (5R41)
- Ring of Barahir (6R55)
- Westfold (6U116)
- Elrond, Elven Lord (7R21)
- Andúril, Flame of the West (7R79)
- Andúril, King's Blade (7R80)
- Noble Leaders (7R112)
- At His Command (8C31)
- King of the Dead, Oathbreaker (8R38)
- Knife of the Galadhrim (9R+17)
- Kings’ Legacy (13U72)
- Forth the Three Hunters! (15C60)
- Forth the Three Hunters! (15C60)
- Arwen, She-Elf (15R11)
- Gift of the Evenstar, Blessed Light (15U16)
- Aragorn’s Bow, Ranger's Longbow (15R56)
- Forth the Three Hunters! (15C60)
- No Quicker Path (15C65)
- Andúril, Sword That Was Broken (17R27)
- Andúril, Sword That Was Broken (17RF5)
- Crown of Gondor (18R41)
- Crown of Gondor (18RF7)
- Crown of Gondor (18O3)
- Not Bound to His Fate (19P14)
- The Prancing Pony (0P1)
- Aragorn’s Bow (0P41)
- Boromir, Redeemed (V1_20)
- The Sons of Gondor Have Returned (V1_21)
- Gilraen's Memorial (V1_22)
- I Would Have Gone With You to the End (V1_23)
- You Have My Sword (V1_24)