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 = ' | |where=C.CardType = 'companion' AND CR.GameText LIKE '%discard%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 05:21, 9 March 2022
- Pippin, Friend to Frodo (1C306)
- Arwen, Elven Rider (3U7)
- Arwen, Elven Rider (3M1)
- Fereveldir, Son of Thandronen (4C67)
- Thandronen, Veteran Protector (4C85)
- Gandalf, Greyhame (4R89)
- Éowyn, Sister-daughter of Theoden (4R271)
- Frodo, Courteous Halfling (4R301)
- Merry, Learned Guide (4C310)
- Merry, Unquenchable Hobbit (4R311)
- Pippin, Just a Nuisance (4R313)
- Pippin, Woolly-footed Rascal (4C314)
- Birchseed, Tall Statesman (5U15)
- Forest Guardian (5C17)
- Lindenroot, Elder Shepherd (5R19)
- Knight of Gondor (5C36)
- Frodo, Master of the Precious (5U111)
- Naith Troop (6U22)
- Sméagol, Poor Creature (6C45)
- Éomer, Rohirrim Captain (6R92)
- Háma, Doorward of Theoden (6R94)
- Merry, Impatient Hobbit (6R113)
- Pippin, Hastiest of All (6R114)
- Merry, Impatient Hobbit (6M3)
- Gimli, Feared Axeman (7R7)
- Legolas, Fearless Marksman (7R25)
- Sméagol, Hurried Guide (7C72)
- Derufin (7R87)
- Dervorin (7U88)
- Faramir, Stout Captain (7C90)
- Gondorian Captain (7C96)
- Ingold (7C106)
- Iorlas (7U107)
- Madril, Faramir's Aide (7U110)
- Ranger of Osgiliath (7C116)
- Targon (7C124)
- Éomer, Skilled Tactician (7R227)
- Éowyn, Restless Maiden (7C229)
- Grimbold, Marshal of Rohan (7R233)
- Guthláf, Herald (7C235)
- Rohirrim Guard (7C246)
- Merry, Swordthain (7R321)
- Sam, Resolute Halfling (7R327)
- Éomer, Valiant Warchief (7P365)
- Sméagol, Slippery Sneak (8R27)
- Oathbreaker (8C41)
- Sleepless Dead (8U45)
- Rohirrim Army (8R91)
- Théoden, Tall and Proud (8R92)
- Merry, Noble Warrior (8P121)
- Pippin, Guard of Minas Tirith (8P122)
- Linnar, Dwarven Lord (9R5)
- Radagast, The Brown (9R+26)
- Sméagol, Bearer of Great Secrets (9R+30)
- Boromir, Bearer of Council (9R+31)
- Elendil, The Tall (9R+32)
- Arwen, Echo of Luthien (10U5)
- Celeborn, Lord of the Galadhrim (10R7)
- Círdan, The Shipwright (10R8)
- Galadriel, Lady Redeemed (10R11)
- Treebeard, Keeper of the Watchwood (10R18)
- Farin, Emissary of Erebor (11C7)
- Grimir, Dwarven Emissary (11R10)
- Elven Scout (11S18)
- Erland, Dale Counselor (11R30)
- Théoden, King of the Eorlingas (11U159)
- Frodo, Protected by Many (11S164)
- Dwarven Warrior (12C7)
- Elrond, Witness to History (12R17)
- Aldred, Eored Soldier (12C107)
- Bilbo, Melancholy Hobbit (12R119)
- Elrond, Witness to History (12RF1)
- Bilbo, Melancholy Hobbit (12RF12)
- Celeborn, The Wise (13R11)
- Dasron, Merchant from Dorwinion (13C29)
- Gandalf, Bearer of Obligation (13R33)
- Sméagol, Simple Stoor (13U55)
- Denethor, Last Ruling Steward (13R64)
- Guard of the White Tree (13U67)
- Háma, Captain of the King's Guard (13U128)
- Sam, Bearer of Great Need (13R156)
- Celeborn, The Wise (13RF1)
- Gandalf, Bearer of Obligation (13RF4)
- Denethor, Last Ruling Steward (13RF8)
- Sam, Bearer of Great Need (13RF16)
- Celeborn, The Wise (13O1)
- Gandalf, Bearer of Obligation (13O4)
- Denethor, Last Ruling Steward (13O7)
- Dain Ironfoot, King Under the Mountain (14R1)
- Grimbeorn, Beorning Chieftain (14R6)
- Duinhir, Tall Man of Blackroot Vale (14R8)
- Halbarad, Ranger of the North (14R9)
- Elven Warrior (15C14)
- Gandalf, Powerful Guide (15R29)
- Quickbeam, Hastiest of All Ents (15R34)
- Skinbark, Elder Ent (15U37)
- Éomer, Horsemaster (15R123)
- Haleth, Son of Hama (15U128)
- Gandalf, Powerful Guide (15RF5)
- Quickbeam, Hastiest of All Ents (15RF7)
- Éomer, Horsemaster (15RF13)
- Gandalf, Powerful Guide (15O2)
- Quickbeam, Hastiest of All Ents (15O3)
- Éomer, Horsemaster (15O6)
- Thorin III, Stonehelm (17R6)
- Barliman Butterbur, Red-faced Landlord (17U16)
- Gandalf, Returned (17R17)
- Woodland Onod (17U26)
- Madril, Loyal Lieutenant (17S30)
- Merry, In the Bloom of Health (17U107)
- Pippin, In the Bloom of Health (17U109)
- Gil-galad, High King of the Noldor (18R12)
- Haldir, Warrior Messenger (18R14)
- Librarian, Keeper of Ancient Texts (18C22)
- Sméagol, Pitiable Guide (19P11)
- Boromir, Destined Guide (19P13)
- Frodo, Little Master (19P28)
- Merry, Resolute Friend (19P29)
- Éowyn, Sister-daughter of Theoden (0P39)
- Radagast, The Brown (0P51)
- Erkenbrand, Master of Westfold (0P59)
- Háma, Captain of the King's Guard (0P106)
- Guard of the White Tree (0P107)
- Treebeard, Enemy of the Hand (0W4)
- Gandalf, Returned (0W32)
- Gandalf, Powerful Guide (0W38)
- Balin, Brother of Dwalin (30S2)
- Nori, Of the Blue Mountains (30S15)
- Thorin, Oakenshield (30S19)
- Thorin, Oakenshield (30P19)
- Gandalf, Friend of Thorin (30S26)
- Gandalf, The Grey (30S27)
- Gandalf, Leader of the Company (30S28)
- Bilbo, Expert Burglar (30S43)
- Bilbo, Master in Riddles (30S45)
- Gandalf, Olorin (V1_14)
- Aragorn, Estel (V1_19)