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 '%token%' AND C.Culture = 'rohan' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 15:02, 3 October 2022
- Fortress Never Fallen (4U276)
- Armory (5U79)
- Parapet (5U87)
- We Left None Alive (6C97)
- Seeking New Foes (7R249)
- Théoden, Rekindled King (7R255)
- Doom Drove Them (8U86)
- Border Patrol (11U144)
- Coif (12R111)
- Éowyn, Restless Warrior (13U124)
- Firefoot, Mearas of the Mark (13R126)
- Freely Across Our Land (13C127)
- Merchant of Westfold (13C132)
- Riddermark Tactician (13C133)
- Snowmane, Noble Mearas (13R136)
- Wind-swept Homestead (13R139)
- Cast from the Hall (18C94)
- Rohirrim Recruit (18C103)
- Éowyn, Restless Warrior (0P118)