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 '%resistance%' AND C. | |where=CR.GameText LIKE '%resistance%' AND C.Culture = 'gondor' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 06:39, 10 February 2022
- Scroll of Isildur (9R36)
- The Highest Quality (11R60)
- Much-needed Rest (11C63)
- Pledge of Loyalty (11S64)
- Tireless (12C52)
- Aragorn, Isildur's Heir (13R59)
- Boromir, Doomed Heir (13S62)
- Denethor, Last Ruling Steward (13R64)
- Elendil, High-king of Gondor (13R65)
- Isildur, Heir of Elendil (13U71)
- Rally the Company (13S74)
- Storied Homestead (13R76)
- Aragorn, Isildur's Heir (13RF7)
- Denethor, Last Ruling Steward (13RF8)
- Aragorn, Isildur's Heir (13O6)
- Denethor, Last Ruling Steward (13O7)
- Halbarad, Ranger of the North (14R9)
- Faramir, Captain of Ithilien (18R48)
- Watcher at Sarn Ford, Ranger of the North (18R59)
- Watcher at Sarn Ford, Ranger of the North (18RF9)
- Watcher at Sarn Ford, Ranger of the North (18O5)
- Isildur, Heir of Elendil (0P119)
- Watcher at Sarn Ford, Ranger of the North (0P129)
- Elendil, High-King of Gondor (0D6)