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= C.CardType = 'Companion' AND CR.Resistance | |where= C.CardType = 'Companion' AND CR.Resistance = 5 | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 03:07, 16 April 2022
- Sam, Faithful Companion (1R310)
- Sam, Son of Hamfast (1C311)
- Sam, Proper Poet (2C114)
- Sam, Proper Poet (2M3)
- Sam, Frodo's Gardener (4R315)
- Sam, Samwise the Brave (4C316)
- Sam, Nice Sensible Hobbit (5U115)
- Sam, Needer of Vittles (7C326)
- Sam, Resolute Halfling (7R327)
- Sam, Great Elf Warrior (10P122)
- Sméagol, Scout and Guide (11R51)
- Boromir, Hero of Osgiliath (11R57)
- Sméagol, Scout and Guide (11RF6)
- Járnsmid, Barding Emissary (12R30)
- Aldred, Eored Soldier (12C107)
- Haethen, Veteran Fighter (12R116)
- Gandalf, Bearer of Obligation (13R33)
- Sméagol, Simple Stoor (13U55)
- Denethor, Last Ruling Steward (13R64)
- Guard of the White Tree (13U67)
- Tradesman From Lebennin (13C77)
- Merchant of Westfold (13C132)
- Riddermark Tactician (13C133)
- Sam, Bearer of Great Need (13R156)
- Gandalf, Bearer of Obligation (13RF4)
- Denethor, Last Ruling Steward (13RF8)
- Sam, Bearer of Great Need (13RF16)
- Gandalf, Bearer of Obligation (13O4)
- Denethor, Last Ruling Steward (13O7)
- Duilin, Ranger from Blackroot Vale (14R7)
- Duinhir, Tall Man of Blackroot Vale (14R8)
- Sméagol, Wretched and Hungry (15R49)
- Sméagol, Wretched and Hungry (15RF8)
- Ranger of the White Tree (17S33)
- Soldier of Rohan (17U101)
- Librarian, Keeper of Ancient Texts (18C22)
- Boromir, Proud and Noble Man (18R40)
- Denethor, On the Edge of Madness (18R42)
- Sméagol, Pitiable Guide (19P11)
- Boromir, Destined Guide (19P13)
- Ghan-bûri-Ghan, Chieftain of the Woses (0P56)
- Erkenbrand, Master of Westfold (0P59)
- Boromir, Hero of Osgiliath (0P71)
- Járnsmid, Barding Emissary (0P89)
- Guard of the White Tree (0P107)
- Sam, Lover of Trees (0W13)