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 '% | |where=CR.GameText LIKE '%resistance%' AND (C.Culture = 'gondor' OR C.Culture = 'rohan' OR C.Culture = 'dwarven') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 02:41, 1 March 2022
- Gimli, Bearer of Grudges (9R+4)
- Scroll of Isildur (9R36)
- Fallen Lord (11U6)
- On Guard (11C13)
- Well-equipped (11R14)
- The Highest Quality (11R60)
- Much-needed Rest (11C63)
- Pledge of Loyalty (11S64)
- Hrothlac, Man of Rohan (11C148)
- Rally Cry (11S150)
- War Now Calls Us (11S160)
- Dwarven Skill (12C6)
- His Father’s Charge (12C8)
- Sharp Defense (12U13)
- Tireless (12C52)
- Challenging the Orc-host (12C109)
- Cleaving a Path (12C110)
- For the Mark (12C114)
- 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)
- Ferthu Théoden Hal (13C125)
- Théodred, Second Marshal of the Mark (13R138)
- 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)
- Éomer’s Spear, Trusty Weapon (15R124)
- Faramir, Captain of Ithilien (18R48)
- Watcher at Sarn Ford, Ranger of the North (18R59)
- Théoden, Ednew (18R105)
- Watcher at Sarn Ford, Ranger of the North (18RF9)
- Théoden, Ednew (18RF14)
- Watcher at Sarn Ford, Ranger of the North (18O5)
- Isildur, Heir of Elendil (0P119)
- Watcher at Sarn Ford, Ranger of the North (0P129)
- Théodred, Second Marshal of the Mark (0D5)
- Elendil, High-King of Gondor (0D6)