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= | |where=C.Culture = 'gandalf' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 11:10, 26 January 2022
- Albert Dreary, Entertainer From Bree (1R69)
- Barliman Butterbur, Prancing Pony Proprietor (1U70)
- Durin’s Secret (1R71)
- Gandalf, Friend of the Shirefolk (1R72)
- Gandalf's Cart (1U73)
- Gandalf’s Pipe (1U74)
- Glamdring (1R75)
- Intimidate (1C76)
- Let Folly Be Our Cloak (1U77)
- Mysterious Wizard (1C78)
- The Nine Walkers (1R79)
- Ottar, Man of Laketown (1R80)
- Questions That Need Answering (1R81)
- Risk a Little Light (1C82)
- Servant of the Secret Fire (1R83)
- Sleep, Caradhras (1C84)
- Strength of Spirit (1C85)
- Treachery Deeper Than You Know (1C86)
- A Wizard Is Never Late (1R87)
- Gandalf, The Grey Wizard (1P364)
- The Lord of the Rings, Trading Card Game (1M1)
- Erland, Advisor to Brand (2C21)
- Gandalf's Staff (2R22)
- Gandalf's Wisdom (2C23)
- Hugin, Emissary from Laketown (2C24)
- Járnsmid, Merchant from Dale (2R25)
- Speak “Friend” and Enter (2C26)
- Staff Asunder (2R27)
- Wielder of the Flame (2U28)
- Wizard Staff (2C29)
- You Cannot Pass! (2U30)
- Gandalf, The Grey Pilgrim (2P122)
- Betrayal of Isengard (3R29)
- Deep in Thought (3C30)
- Depart Silently (3C31)
- Fireworks (3C32)
- His First Serious Check (3C33)
- Narya (3R34)
- Trust Me as You Once Did (3U35)
- Unknown Perils (3C36)
- Behold the White Rider (4U88)
- Gandalf, Greyhame (4R89)
- Gandalf, The White Wizard (4C90)
- Gandalf's Staff, Walking Stick (4R91)
- Grown Suddenly Tall (4R92)
- Have Patience (4C93)
- Hearken to Me (4R94)
- Into Dark Tunnels (4R95)
- Keep Your Forked Tongue (4U96)
- Long I Fell (4C97)
- Mithrandir, Mithrandir! (4C98)
- Roll of Thunder (4U99)
- Shadowfax (4R100)
- Stump and Bramble (4U101)
- Task Was Not Done (4C102)
- Treebeard, Earthborn (4R103)
- Treebeard, Oldest Living Thing (4C104)
- Under the Living Earth (4C105)
- Well Met Indeed (4R106)
- Windows in a Stone Wall (4R107)
- Wizardry Indeed (4U108)
- Birchseed, Tall Statesman (5U15)
- Down From the Hills (5R16)
- Forest Guardian (5C17)
- Fury of the White Rider (5R18)
- Lindenroot, Elder Shepherd (5R19)
- Turn of the Tide (5U20)
- Boomed and Trumpeted (6U24)
- Crack Into Rubble (6U25)
- Enraged (6R26)
- Ent Avenger (6C27)
- Ent Horde (6R28)
- Ent Moot (6C29)
- Gandalf, Mithrandir (6R30)
- Glamdring, Lightning Brand (6R31)
- Host of Fangorn (6U32)
- Quickbeam, Bregalad (6C33)
- Roused (6C34)
- Skinbark, Fladrif (6R35)
- Threw Down My Enemy (6U36)
- Treebeard, Guardian of the Forest (6C37)
- Enraged (6R123)
- Skinbark, Fladrif (AI) (6R124)
- Treebeard, Guardian of the Forest (6M1)
- All Save One (7C31)
- The Board Is Set (7R32)
- Citadel to Gate (7R33)
- Echoes of Valinor (7C34)
- Fool's Hope (7U35)
- Gandalf, Defender of the West (7C36)
- Gandalf, Manager of Wizards (7R37)
- Gandalf's Staff, Focus of Power (7R38)
- Glamdring, Elven Blade (7R39)
- Have Patience (7C40)
- Intimidate (7C41)
- King's Advisor (7U42)
- Light the Beacons (7R43)
- Moment of Respite (7R44)
- Númenor's Pride (7U45)
- Peace of Mind (7C46)
- Sharpen Your Swords (7U47)
- Stay This Madness (7R48)
- Steadfast Champion (7U49)
- Terrible and Evil (7R50)
- Undaunted (7C51)
- Wizard Staff (7C52)
- A Fool (8C14)
- Gandalf, Leader of Men (8R15)
- Let Us Not Tarry (8U16)
- Mighty Steed (8U17)
- Not the First Halfling (8U18)
- On Your Doorstep (8U19)
- Saved From the Fire (8R20)
- Shadowfax, Greatheart (8R21)
- Ent Draught (9R24)
- Huorn (9R25)
- Radagast, The Brown (9R+26)
- Sent Back (9R27)
- Borne Far Away (10R14)
- Brooding on Tomorrow (10U15)
- Gathering Wind (10C16)
- Out of the High Airs (10R17)
- Treebeard, Keeper of the Watchwood (10R18)
- The Art of Gandalf (11U28)
- Ease the Burden (11U29)
- Erland, Dale Counselor (11R30)
- Final Account (11C31)
- G for Grand (11S32)
- Gandalf, Leader of the Company (11S33)
- Gandalf's Staff, Ash-staff (11R34)
- Glamdring, Foe-hammer (11R35)
- Inspiration (11C36)
- New Authority (11U37)
- New-awakened (11U38)
- Prolonged Struggle (11C39)
- Shadowfax, Unequaled Steed (11U40)
- Glamdring, Foe-hammer (11RF4)
- Betrayal of Isengard (12U25)
- Discoveries (12R26)
- Gandalf, The White Rider (12R27)
- Gandalf’s Hat (12R28)
- Introspection (12U29)
- Járnsmid, Barding Emissary (12R30)
- Mysterious Wizard (12C31)
- Salve (12C32)
- The Terror of His Coming (12C33)
- Traveled Leader (12C34)
- Watch and Wait (12R35)
- With Doom We Come (12U36)
- Gandalf, The White Rider (12RF3)
- Gandalf, The White Rider (12O1)
- Alatar, Final Envoy (13U28)
- Dasron, Merchant from Dorwinion (13C29)
- Fear and Great Wonder (13C30)
- The Flame of Anor (13U31)
- For a While Less Dark (13C32)
- Gandalf, Bearer of Obligation (13R33)
- Look to My Coming (13U34)
- No Colour Now (13C35)
- The Palantír of Orthanc, Recovered Seeing Stone (13R36)
- Pallando, Far-travelling One (13R37)
- Radagast, Tender of Beasts (13R38)
- Return to Us (13C39)
- Shadowfax, Roaring Wind (13R40)
- Strange Meeting (13C41)
- Traveler’s Homestead (13R42)
- Vapour and Steam (13U43)
- Gandalf, Bearer of Obligation (13RF4)
- Pallando, Far-travelling One (13RF5)
- Gandalf, Bearer of Obligation (13O4)
- Pallando, Far-traveling One (13O5)
- Brand, King of Dale (14R5)
- Grimbeorn, Beorning Chieftain (14R6)
- Be Gone! (15U27)
- Ent Avenger (15C28)
- Gandalf, Powerful Guide (15R29)
- Leaflock, Finglas (15R30)
- Mellon! (15U31)
- Momentous Gathering (15U32)
- One Last Surprise (15R33)
- 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)
- One Last Surprise (15RF6)
- Quickbeam, Hastiest of All Ents (15RF7)
- Gandalf, Powerful Guide (15O2)
- Quickbeam, Hastiest of All Ents (15O3)
- A New Light (17U15)
- Barliman Butterbur, Red-faced Landlord (17U16)
- Gandalf, Returned (17R17)
- Glamdring, Orc Beater (17R18)
- Guidance of the Istari (17U19)
- Gwaihir, The Windlord (17R20)
- Long-stemmed Pipe (17U21)
- Meneldor, Misty Mountain Eagle (17U22)
- Scintillating Bird (17R23)
- Shadowfax, Greatest of the Mearas (17R24)
- The Sap is in the Bough (17U25)
- Woodland Onod (17U26)
- Glamdring, Orc Beater (17RF2)
- Shadowfax, Greatest of the Mearas (17RF3)
- Gwaihir, The Windlord (17RF4)
- Shadowfax, Greatest of the Mearas (17O1)
- Gwaihir, The Windlord (17O2)
- Beorning Axe (18R18)
- Drawn to Full Height (18C19)
- Ents Marching (18C20)
- Last Stand (18U21)
- Librarian, Keeper of Ancient Texts (18C22)
- One-Upsmanship (18U23)
- Our Time (18R24)
- Perspective (18U25)
- Radagast's Herb Bag (18R26)
- Ship of Smoke (18U27)
- Beorning Axe (18RF4)
- Radagast's Herb Bag (18RF5)
- Beorning Axe (18O1)
- Radagast's Herb Bag (18O2)
- Gandalf, Wise Guide (19P8)
- Stern Words (19P9)
- Fireworks (0P3)
- Treebeard, Guardian of the Forest (0P21)
- Gandalf, Defender of the West (0P26)
- Gandalf, Mithrandir (0P32)
- Gandalf's Staff, Walking Stick (0P38)
- Glamdring, Lightning Brand (0P44)
- Radagast, The Brown (0P51)
- Ghan-bûri-Ghan, Chieftain of the Woses (0P56)
- Radagast's Staff (0P57)
- Gandalf, Stormcrow (0P64)
- Gandalf, Leader of the Company (0P70)
- Járnsmid, Barding Emissary (0P89)
- Vapour and Steam (0P90)
- 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)
- A Wizard Is Never Late (30S23)
- Dawn Take You All! (30S24)
- Dawn Take You All! (30P24)File:HDG-EN30F024.0 card.jpg
- Gandalf, Leader of Dwarves (30S25)
- Gandalf, Friend of Thorin (30S26)
- Gandalf, The Grey (30S27)
- Gandalf, Leader of the Company (30S28)
- Glamdring (30S29)
- He Gives Me Courage (30S30)
- He Gives Me Courage (30P30)
- Take Up Arms. Fight! (30S31)
- Beorn, Skin-Changer (31HH13)
- The Eagles Are Coming (31HH14)
- Gwaihir, Lord of the Eagles (31HH15)
- His Wrath Was Redoubled (31HH16)
- Radagast, The Brown (31HH17)
- Former Herald (32HG21)
- Gathering of the Three Rings (32HG22)
- Narya (32HG23)
- Saruman, The White (32HG24)
- Wizard Staff (32HH63)
- Counsel of the Wise (V1_13)
- Gandalf, Olorin (V1_14)
- Gwaihir, Lord of Eagles (V1_15)
- My Heart Tells Me (V1_16)
- Two Eyes, as Often as I Can Spare Them (V1_17)
- The White Council (V1_18)