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