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=C. | |where=(C.Culture = 'dwarven' OR C.Culture = 'elven') AND (CR.GameText LIKE '%burden%' OR CR.GameText LIKE '%resistance%') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 03:05, 17 February 2022
- Elf-song (1C39)
- Songs of the Blessed Realm (1C61)
- Phial of Galadriel (3U24)
- Gimli, Bearer of Grudges (9R+4)
- Galadriel, Bearer of Wisdom (9R+14)
- Fallen Lord (11U6)
- On Guard (11C13)
- Well-equipped (11R14)
- Farewell to Lórien (11C19)
- Legolas, Companion of the Ring (11S21)
- Nocked (11U25)
- Dwarven Skill (12C6)
- His Father’s Charge (12C8)
- Sharp Defense (12U13)
- Arwen, Reflection of Luthien (13S9)
- Celeborn, The Wise (13R11)
- Standing Tall (13C25)
- Celeborn, The Wise (13RF1)
- Celeborn, The Wise (13O1)
- Arwen, She-Elf (15R11)
- Galadriel's Silver Ewer (18R11)
- Galadriel's Silver Ewer (18RF3)
- Phial of Galadriel (0P9)
- Nocked (0P69)
- Legolas, Companion of the Ring (0P87)