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 '%token%' AND C.Culture = 'gandalf' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 10:32, 4 February 2022
- Questions That Need Answering (1R81)
- Risk a Little Light (1C82)
- Strength of Spirit (1C85)
- Deep in Thought (3C30)
- Unknown Perils (3C36)
- Behold the White Rider (4U88)
- Gandalf, Greyhame (4R89)
- Gandalf, The White Wizard (4C90)
- Gandalf's Staff, Walking Stick (4R91)
- Keep Your Forked Tongue (4U96)
- Under the Living Earth (4C105)
- Fury of the White Rider (5R18)
- Gandalf's Staff, Focus of Power (7R38)
- Undaunted (7C51)
- Not the First Halfling (8U18)
- Gandalf’s Hat (12R28)
- Alatar, Final Envoy (13U28)
- Dasron, Merchant from Dorwinion (13C29)
- Fear and Great Wonder (13C30)
- Shadowfax, Roaring Wind (13R40)
- Traveler’s Homestead (13R42)
- Quickbeam, Hastiest of All Ents (15R34)
- Quickbeam, Hastiest of All Ents (15RF7)
- Quickbeam, Hastiest of All Ents (15O3)
- Gandalf, Returned (17R17)
- Last Stand (18U21)
- Librarian, Keeper of Ancient Texts (18C22)
- Gandalf's Staff, Walking Stick (0P38)
- Gandalf, Returned (0W32)
