User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
|join on=C.ID = CR.ID | |join on=C.ID = CR.ID | ||
|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'), '|500x500px]]</span></span>')=CardName | ||
|where=C.Culture = 'gandalf' AND C.CardType = 'companion' | |where=C.Culture = 'gandalf' AND C.CardType = 'companion' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
Line 14: | Line 14: | ||
|join on=C.ID = CR.ID | |join on=C.ID = CR.ID | ||
|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'), '|500x500px]]</span></span>')=CardName | ||
|where=C.CardType = 'Event' AND C.Culture = 'rohan' AND CR.GameText LIKE '%token%' AND C.Side = 'Free Peoples' AND CR.Subtitle LIKE '%thrall%' | |where=C.CardType = 'Event' AND C.Culture = 'rohan' AND CR.GameText LIKE '%token%' AND C.Side = 'Free Peoples' AND CR.Subtitle LIKE '%thrall%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} |
Revision as of 05:53, 4 March 2022
- Gandalf, Friend of the Shirefolk (1R72)
- Gandalf, The Grey Wizard (1P364)
- The Lord of the Rings, Trading Card Game (1M1)
- Gandalf, The Grey Pilgrim (2P122)
- Gandalf, Greyhame (4R89)
- Gandalf, The White Wizard (4C90)
- Birchseed, Tall Statesman (5U15)
- Forest Guardian (5C17)
- Lindenroot, Elder Shepherd (5R19)
- Ent Avenger (6C27)
- Ent Horde (6R28)
- Gandalf, Mithrandir (6R30)
- Host of Fangorn (6U32)
- Quickbeam, Bregalad (6C33)
- Skinbark, Fladrif (6R35)
- Treebeard, Guardian of the Forest (6C37)
- Skinbark, Fladrif (AI) (6R124)
- Treebeard, Guardian of the Forest (6M1)
- Gandalf, Defender of the West (7C36)
- Gandalf, Manager of Wizards (7R37)
- Gandalf, Leader of Men (8R15)
- Huorn (9R25)
- Radagast, The Brown (9R+26)
- Treebeard, Keeper of the Watchwood (10R18)
- Erland, Dale Counselor (11R30)
- Gandalf, Leader of the Company (11S33)
- Gandalf, The White Rider (12R27)
- Járnsmid, Barding Emissary (12R30)
- Gandalf, The White Rider (12RF3)
- Gandalf, The White Rider (12O1)
- Dasron, Merchant from Dorwinion (13C29)
- Gandalf, Bearer of Obligation (13R33)
- Gandalf, Bearer of Obligation (13RF4)
- Gandalf, Bearer of Obligation (13O4)
- Brand, King of Dale (14R5)
- Grimbeorn, Beorning Chieftain (14R6)
- Ent Avenger (15C28)
- Gandalf, Powerful Guide (15R29)
- Leaflock, Finglas (15R30)
- Quickbeam, Hastiest of All Ents (15R34)
- Shadow of the Wood (15U35)
- Shepherd of the Trees (15R36)
- Skinbark, Elder Ent (15U37)
- Treebeard, Enraged Shepherd (15R38)
- Gandalf, Powerful Guide (15RF5)
- Quickbeam, Hastiest of All Ents (15RF7)
- Gandalf, Powerful Guide (15O2)
- Quickbeam, Hastiest of All Ents (15O3)
- Barliman Butterbur, Red-faced Landlord (17U16)
- Gandalf, Returned (17R17)
- Woodland Onod (17U26)
- Librarian, Keeper of Ancient Texts (18C22)
- Gandalf, Wise Guide (19P8)
- Treebeard, Guardian of the Forest (0P21)
- Gandalf, Defender of the West (0P26)
- Gandalf, Mithrandir (0P32)
- Radagast, The Brown (0P51)
- Ghan-bûri-Ghan, Chieftain of the Woses (0P56)
- Gandalf, Stormcrow (0P64)
- Gandalf, Leader of the Company (0P70)
- Járnsmid, Barding Emissary (0P89)
- Gandalf, Stormcrow (0D17)
- The Lord of the Rings, Trading Card Game (0M1)
- Treebeard, Enemy of the Hand (0W4)
- Gandalf, Stormcrow (0W17)
- Gandalf, Returned (0W32)
- Gandalf, Powerful Guide (0W38)
- Gandalf, Leader of Dwarves (30S25)
- Gandalf, Friend of Thorin (30S26)
- Gandalf, The Grey (30S27)
- Gandalf, Leader of the Company (30S28)
- Gandalf, Olorin (V1_14)