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=CR.GameText LIKE '%token%' AND CR.GameText LIKE '%condition%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 09:31, 14 February 2022
- Deep in Thought (3C30)
- Stout and Strong (4U57)
- Fereveldir, Son of Thandronen (4C67)
- Strength of Arms (4U82)
- Behold the White Rider (4U88)
- Ithilien Trap (4U126)
- Fortress Never Fallen (4U276)
- Good Work (4U305)
- Armory (5U79)
- Parapet (5U87)
- Suspended Palaces (6C10)
- Agility (6C12)
- Garrison of Osgiliath (6C52)
- We Left None Alive (6C97)
- Kept Safe (6C111)
- Hidden Knowledge (7R104)
- Iorlas (7U107)
- Noble Leaders (7R112)
- Support of the City (7U123)
- Seeking New Foes (7R249)
- Uncertain Future (11U26)
- Houses of Healing (11U61)
- Border Patrol (11U144)
- Traveler’s Homestead (13R42)
- Gladden Homestead (13R49)
- Storied Homestead (13R76)
- The Fortunes of Balin’s Folk (15U4)
- Nice Fish (15C46)
- Balin Avenged (17R2)
- Namárië (17U10)
- Run Until Found (18U2)
- Gil-galad, High King of the Noldor (18R12)
- Soldier's Cache (18U58)
- Scouring of the Shire (18R112)