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 '%heal%' AND C.Culture = 'elven' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 03:25, 27 January 2022
- Celeborn, Lord of Lorien (1R34)
- Elrond, Lord of Rivendell (1R40)
- Galadriel, Lady of Light (1R45)
- Shoulder to Shoulder (1C59)
- Elrond, Herald to Gil-galad (3R13)
- Friends of Old (3C16)
- Galadriel, Lady of the Golden Wood (3R17)
- Master of Healing (3C22)
- Legolas' Sword (5U12)
- That Is No Orc Horn (5C14)
- Legolas, Archer of Mirkwood (5P121)
- Elrond, Keeper of Vilya (6R15)
- Galadriel, Keeper of Nenya (6R18)
- Must Be a Dream (6U20)
- Bow of the Galadhrim, Gift of Galadriel (7R18)
- Elrond, Elven Lord (7R21)
- Shadow Between (7R28)
- A Grey Ship (8U9)
- Nenya, Ring of Adamant (9R20)
- Elrond, Venerable Lord (10R9)
- Farewell to Lórien (11C19)
- Legolas' Bow (11R23)
- Refuge (12U21)
- Asfaloth, Swift Blossom (13R10)
- Galadriel, Sorceress of the Hidden Land (13R15)
- Galadriel, Sorceress of the Hidden Land (13RF2)
- Galadriel, Sorceress of the Hidden Land (13O2)
- Focus (15C15)
- Elven Guardian (17S7)
- The World Ahead (17R13)
- Miruvóre (18C16)
- Elrond, Elven Lord (30P21)
- Elrond, Elven Lord (30S21)
- Rivendell Scout (30HK51)
- Galadriel, Elven Lady (32HG13)
- Nenya (32HG14)
- Lament for the Fallen (V1_8)
- Three for the Elven-Kings (V1_12)