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 = 'rohan' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 02:07, 20 February 2022
- Brego (4U263)
- Éomer, Sister-son of Theoden (4C266)
- Guma, Plains Farmer (4C277)
- Supplies of the Mark (4R290)
- Weland, Smith of the Riddermark (4U295)
- Well Stored (4U296)
- Théoden, Lord of the Mark (4P365)
- I Am Here (5R84)
- Rohirrim Shield (5C91)
- Théoden, King of the Golden Hall (5C93)
- Thundering Host (5R94)
- Éowyn, Daughter of Eomund (5P122)
- Thundering Host (5R128)
- Hrethel, Rider of Rohan (6C95)
- Guarded Fastness (7U234)
- Léowyn (7R239)
- Théoden, Rekindled King (7R255)
- With Strength to Fight (7R261)
- Théoden, King of the Golden Hall (0P19)
- Eomer, Forthwith Banished (0D23)