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'), '|500x500px]]</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'), '|500x500px]]</span></span>')=CardName | ||
|where=CR.GameText LIKE '% | |where=CR.GameText LIKE '%event%' AND C.Culture = 'rohan' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 00:59, 22 March 2023
- Ceorl, Weary Horseman (4U264)
- Éowyn, Lady of Rohan (4C270)
- Éowyn, Sister-daughter of Theoden (4R271)
- Rohirrim Helm (5R89)
- Rohirrim Helm (5R127)
- Blood Has Been Spilled (6U91)
- Éomer, Skilled Tactician (7R227)
- Éowyn's Sword, Dernhelm's Blade (7R230)
- Firefoot, Eomer's Steed (7R232)
- Herugrim, Sword of the Mark (7R236)
- His Golden Shield (7C237)
- Long Spear (7C240)
- Riding Armor (7U245)
- Snowmane (7R250)
- Rohirrim Army (8R91)
- Hrothlac, Man of Rohan (11C148)
- Riders of the Mark (11R154)
- Rush of Steeds (11C157)
- Coif (12R111)
- For the Mark (12C114)
- Golden Glimmer (12C115)
- Léofric, Defender of the Mark (12U117)
- Bitter Tidings (13U122)
- Hurried Barrows (13U130)
- Éowyn, Willing Fighter (15C125)
- Throne of the Golden Hall (17R98)
- Throne of the Golden Hall (17RF13)
- Throne of the Golden Hall (17O5)
- Erkenbrand's Shield (18R97)
- Erkenbrand's Shield (18RF12)
- Erkenbrand's Shield (18O7)
- Éowyn, Lady of Rohan (0P17)
- Éowyn, Sister-daughter of Theoden (0P39)
- Erkenbrand, Master of Westfold (0P59)
- Riders of the Mark (0P77)