User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 4: | Line 4: | ||
,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 '%defender%' AND C.Side = 'Free Peoples' AND NOT C.CardType = 'companion' | |where=CR.GameText LIKE '%defender%' AND C.Side = 'Free Peoples' AND NOT C.CardType = 'companion' | ||
|order by= | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul |
Revision as of 03:20, 21 February 2022
- Elendil's Valor (1C103)
- Swordarm of the White Tower (1C116)
- Valiant Man of the West (1R118)
- Disquiet of Our People (2C2)
- Wielder of the Flame (2U28)
- Banner of the White Tree (3R39)
- Ruins of Osgiliath (4R133)
- Firefoot (4R274)
- Forth Eorlingas! (4U275)
- Down From the Hills (5R16)
- No Rest for the Weary (5R86)
- Númenor's Pride (7U45)
- Andúril, King's Blade (7R80)
- I Will Go (7C105)
- Armor of the Citadel (11U55)
- Protecting the Hall (11U149)
- Rohirrim Mount (11U156)
- Elendil’s Valor (12C46)
- Firefoot, Mearas of the Mark (13R126)
- Burial Mounds (15R122)
- Spear of the Mark (15U140)
- Ents Marching (18C20)
- Horn of Boromir, The Great Horn (18R53)
- Ranger of the North (18R55)
- Firefoot (0P33)
- His Wrath Was Redoubled (31HH16)
- Saruman, The White (32HG24)
- So Bold and So Courteous (V1_6)