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= | |where=CR.GameText LIKE '%assignment%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 02:41, 18 April 2022
- Uruk Guard (1R147)
- The End Comes (1R169)
- Frenzy (1C171)
- Return to Its Master (1R224)
- Úlairë Toldëa, Messenger of Morgul (1R236)
- Orc Assassin (1U262)
- Bucklebury Ferry (1U330)
- Saruman, Servant of the Eye (3C69)
- Dunlending Ravager (4C15)
- Dunlending Warrior (4C18)
- Over the Isen (4U31)
- Brought Back Alive (4U143)
- Get Back (4U152)
- Many Riddles (4U159)
- Orthanc Champion (4R164)
- Southron Commander (4U249)
- Southron Troop (4R256)
- Southron Wanderer (4C258)
- Vision From Afar (4R259)
- Birchseed, Tall Statesman (5U15)
- Forest Guardian (5C17)
- Lindenroot, Elder Shepherd (5R19)
- Alcarin, Warrior of Lamedon (5R31)
- Treebeard, Guardian of the Forest (6C37)
- Berserk Butcher (6R60)
- Desertion (6U61)
- Treebeard, Guardian of the Forest (6M1)
- Reckless Pride (7U13)
- Ancient Blade (7U15)
- Steadfast Champion (7U49)
- Sméagol, Always Helps (7R71)
- We Hates Them (7U77)
- Unexpected Visitor (7U126)
- Called (7U174)
- Slow-kindled Courage (7U328)
- Gorgoroth Assassin (8R95)
- The Red Arrow (9R46)
- Reclaim the Precious (10U22)
- High Vantage (10U44)
- Morgul Vanguard (10R63)
- Beastly Olog-hai (11R108)
- Entrapping Orc (11C120)
- Protecting the Hall (11U149)
- The Mouth of Sauron, Lieutenant of Barad-dur (12R118)
- Barbaric Uruk (12U135)
- Shingle in a Storm (12C145)
- Uruk-hai Guard (12R156)
- Sense of Obligation (12U170)
- Shadowy Mount (12R171)
- Úlairë Cantëa, Black Assassin (12R174)
- The Witch-king’s Beast, Fell Creature (12U184)
- The Mouth of Sauron, Lieutenant of Barad-dur (12RF11)
- Úlairë Cantëa, Black Assassin (12RF16)
- Úlairë Cantëa, Black Assassin (12O7)
- Gimli, Lord of the Glittering Caves (13R5)
- Crashing Cavalry (13C13)
- Aragorn, Isildur's Heir (13R59)
- Dunlending Trapper (13U89)
- Aragorn, Isildur's Heir (13RF7)
- Aragorn, Isildur's Heir (13O6)
- Half-troll of Far Harad (14R12)
- Uruk-hai Healer (14R14)
- Tower Troll (15R117)
- Mauhúr, Relentless Hunter (15S164)
- A Shadow Fell Over Them (15R182)
- Orkish Cavalry (17R74)
- Éowyn, Northwoman (17R96)
- Into the Caves (17U100)
- Orkish Sneak (18C91)
- Lurtz, Halfling Hunter (18R118)
- Gríma, Servant of Another Master (19P16)
- Saruman, Servant of the Eye (0P11)
- Treebeard, Guardian of the Forest (0P21)
- The Witch-king’s Beast, Fell Creature (0P82)
- Saruman, Many-coloured Wizard (0D20)
- Lurtz, Halfling Hunter (0W35)
- Orkish Aggressor (30S39)
- Gollum, Small Slimy Creature (31B120)
- Threatening Warg (31B126)
- Forest River (31HD46)
- Spider Nest (31S154)
- Crown of Erebor (32HB1)
- Sauron, The Necromancer (32B245)
- Boromir, Redeemed (V1_20)
- Guided by One Purpose (V1_31)
- Harry Goatleaf, In Thrall to the Nine (V1_38)
- Merry, Of Buckland (V1_52)