User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary Tag: Manual revert |
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=C.Culture = ' | |where=C.Culture = 'gondor' AND CR.GameText LIKE '%token%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 07:17, 16 February 2022
- Ithilien Trap (4U126)
- Aragorn, Defender of Free Peoples (6R50)
- Garrison of Osgiliath (6C52)
- Mortal Men (6C53)
- Ring of Barahir (6R55)
- Trust (6C56)
- Aragorn, Defender of Free Peoples (6M2)
- Hidden Knowledge (7R104)
- Iorlas (7U107)
- Noble Leaders (7R112)
- Support of the City (7U123)
- A Path Appointed (8U42)
- Houses of Healing (11U61)
- Aragorn, Isildur's Heir (13R59)
- Brego, Loyal Steed (13R63)
- Elendil, High-king of Gondor (13R65)
- Guarded City (13C68)
- Heirs of Gondor (13C69)
- Hope Renewed (13U70)
- Storied Homestead (13R76)
- Tradesman From Lebennin (13C77)
- Aragorn, Isildur's Heir (13RF7)
- Aragorn, Isildur's Heir (13O6)
- Gondorian Prowler (15U61)
- Silent Traveler (15C69)
- Throne of Minas Tirith (17R36)
- Throne of Minas Tirith (17RF8)
- Throne of Minas Tirith (17O3)
- Defenses Long Held (18C44)
- The Faithful Stone (18R50)
- Ranger of the South (18C56)
- Soldier's Cache (18U58)
- Aragorn, Defender of Free Peoples (0P47)
- Elendil, High-King of Gondor (0D6)