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'), '|500x500px]]</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'), '|500x500px]]</span></span>')=CardName | ||
|where=C. | |where=C.Side = 'Free Peoples' AND CR.GameText LIKE '%liberate%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 03:51, 5 April 2023
- Haldir, Emissary of the Galadhrim (4C71)
- Night Without End (4R79)
- Sword-wall (4R84)
- Forests of Ithilien (4R121)
- Helm! Helm! (4R279)
- Théoden, Son of Thengel (4C292)
- That Is No Orc Horn (5C14)
- Let Us Be Swift (5C85)
- Banner of Elbereth (6U14)
- Crack Into Rubble (6U25)
- Banner of Westernesse (6U51)
- Banner of the Mark (6U90)
- Reckless Counter (7C117)
- Vorondil (7R127)
- Snowmane (7R250)
- Elendil, The Tall (9R+32)
- Fell Deeds Awake (10U73)
- Unyielding (10U74)
- Rohan Worker (15R135)
- Sturdy Shield (15R141)
- Andúril, Sword That Was Broken (17R27)
- Théoden, Northman, King of Rohan (17R102)
- Warrior of Rohan (17U104)
- Andúril, Sword That Was Broken (17RF5)
- Théoden, Northman, King of Rohan (17RF14)
- Théoden, Northman, King of Rohan (17O6)
