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=C.CardType = ' | |where=C.CardType = 'possession' AND C.Culture = 'gandalf' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 16:40, 28 February 2022
- Gandalf's Cart (1U73)
- Gandalf’s Pipe (1U74)
- Glamdring (1R75)
- Wizard Staff (2C29)
- Shadowfax (4R100)
- Glamdring, Lightning Brand (6R31)
- Glamdring, Elven Blade (7R39)
- Wizard Staff (7C52)
- Shadowfax, Greatheart (8R21)
- The Art of Gandalf (11U28)
- Glamdring, Foe-hammer (11R35)
- Shadowfax, Unequaled Steed (11U40)
- Glamdring, Foe-hammer (11RF4)
- Gandalf’s Hat (12R28)
- Shadowfax, Roaring Wind (13R40)
- Glamdring, Orc Beater (17R18)
- Shadowfax, Greatest of the Mearas (17R24)
- Glamdring, Orc Beater (17RF2)
- Shadowfax, Greatest of the Mearas (17RF3)
- Shadowfax, Greatest of the Mearas (17O1)
- Beorning Axe (18R18)
- Radagast's Herb Bag (18R26)
- Beorning Axe (18RF4)
- Radagast's Herb Bag (18RF5)
- Beorning Axe (18O1)
- Radagast's Herb Bag (18O2)
- Glamdring, Lightning Brand (0P44)