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=CR.GameText LIKE '%discard%' AND | |where=CR.GameText LIKE '%discard%' AND CR.GameText LIKE '%minion%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 06:25, 26 January 2022
- Dwarven Axe (1C9)
- Ancient Enmity (1U29)
- Foul Creation (1U44)
- Stand Against Darkness (1U63)
- Gondor's Vengeance (1C106)
- What Are They? (1C119)
- Caradhras Has Not Forgiven Us (1R123)
- Saruman's Chill (1C134)
- Saruman's Frost (1U135)
- Saruman's Power (1U136)
- Saruman's Snows (1C138)
- Spies of Saruman (1R140)
- Uruk Rager (1C150)
- Uruk Soldier (1C154)
- Uruk Spy (1R155)
- Goblin Scavengers (1C179)
- Goblin Sneak (1U181)
- Goblin Warrior (1C185)
- Lost to the Goblins (1R189)
- Through the Misty Mountains (1U198)
- Úlairë Nertëa, Messenger of Dol Guldur (1U234)
- Band of the Eye (1R240)
- Morgul Skulker (1U258)
- Orc Inquisitor (1C268)
- Tower Lieutenant (1U280)
- Midgewater Moors (1U333)
- Dismay Our Enemies (2U17)
- Hosts of the Last Alliance (2U18)
- Staff Asunder (2R27)
- Flee in Terror (2U33)
- Evil Afoot (2U41)
- Goblin Man (2C42)
- Too Much Attention (2R45)
- Wizard Storm (2U48)
- The Balrog, Durin's Bane (2C51)
- Foul Tentacle (2C58)
- Foul Things (2U59)
- Goblin Scrabbler (2C64)
- Huge Tentacle (2R66)
- Watcher in the Water, Keeper of Westgate (2R73)
- Orc Scout (2C89)
- Southern Spies (2C91)
- Beren and Lúthien (3U9)
- Gift of the Evenstar (3R19)
- Abandoning Reason for Madness (3C49)
- Isengard Smith (3U60)
- Such a Little Thing (3R80)
- The Dark Lord Advances (3C87)
- Get Off the Road! (3U88)
- Hand of Sauron (3C90)
- His Cruelty and Malice (3R91)
- Massing in the East (3U92)
- Orc Guard (3C95)
- Orc Veteran (3U100)
- Orc Warrior (3C101)
- Terrible as the Dawn (3R103)
- Tower of Barad-dûr (3R104)
- Why Shouldn't I Keep It? (3R105)
- Old Noakes, Purveyor of Wisdoms (3C111)
- Hand of Sauron (3M2)
- Dunlending Pillager (4U13)
- Blades Drawn (4U60)
- Elven Sword (4C64)
- Fereveldir, Son of Thandronen (4C67)
- Killing Field (4R72)
- Lórien Is Most Welcome (4U77)
- Strength of Arms (4U82)
- Thandronen, Veteran Protector (4C85)
- Behold the White Rider (4U88)
- Shadowfax (4R100)
- Task Was Not Done (4C102)
- Windows in a Stone Wall (4R107)
- Wizardry Indeed (4U108)
- Henneth Annûn (4R125)
- Ithilien Trap (4U126)
- Ranks Without Number (4U170)
- Uglúk's Sword (4R177)
- Uruk Follower (4R186)
- Uruk Hunter (4U188)
- Uruk Pursuer (4C190)
- Weapons of Isengard (4R211)
- Southron Commander (4U249)
- Southron Troop (4R256)
- Cliffs of Emyn Muil (4R299)
- Palantír Chamber (4U363)
- Dunlending Rampager (5U1)
- Dunlending Renegade (5U2)
- Leaping Blaze (5R3)
- Wild Men of the Hills (5R4)
- Lindenroot, Elder Shepherd (5R19)
- Turn of the Tide (5U20)
- Be Back Soon (5R21)
- Evil-smelling Fens (5U22)
- Fall Back (5U34)
- Black Shapes Crawling (5U48)
- Warg-master (5C66)
- Parapet (5U87)
- Rohirrim Bow (5C88)
- Rohirrim Helm (5R89)
- Rohirrim Shield (5C91)
- Sigewulf, Brave Volunteer (5U92)
- Orc Infantry (5C106)
- Orc Runner (5C109)
- Rohirrim Helm (5R127)
- Dunlending Headman (6C4)
- Agility (6C12)
- Galadriel, Keeper of Nenya (6R18)
- Naith Longbow (6C21)
- Naith Troop (6U22)
- Don’t Follow the Lights (6C38)
- Don’t Look at Them (6R39)
- Safe Paths (6R44)
- Perilous Ventures (6U54)
- Desertion (6U61)
- Isengard Mechanics (6R68)
- Durin’s Tower (6R77)
- Southron Invaders (6C81)
- Banner of the Mark (6U90)
- Éomer, Rohirrim Captain (6R92)
- Ever the Hope of Men (6U93)
- Háma, Doorward of Theoden (6R94)
- We Left None Alive (6C97)
- Gate Sentry (6C102)
- Troll of Udûn (6R106)
- Wisp of Pale Sheen (6C108)
- Held (6R109)
- Pippin, Hastiest of All (6R114)
- Saruman’s Laboratory (6U120)
- Don’t Look at Them (6R125)
- Isengard Mechanics (6R127)
- Preparations (7R12)
- Reckless Pride (7U13)
- Slaked Thirsts (7U14)
- Ancient Blade (7U15)
- Legolas, Fearless Marksman (7R25)
- Glamdring, Elven Blade (7R39)
- Stay This Madness (7R48)
- Steadfast Champion (7U49)
- Gollum, Plotting Deceiver (7R58)
- Hobbitses Are Dead (7R61)
- Let Her Deal With Them (7R63)
- Scouting (7R68)
- We Hates Them (7U77)
- Where Shall We Go (7U78)
- City of Men (7C83)
- Dervorin (7U88)
- Faramir, Stout Captain (7C90)
- Gondor Still Stands (7R95)
- Gondorian Merchant (7R97)
- Guarded (7R101)
- Long Prepared (7U109)
- Madril, Faramir's Aide (7U110)
- Ranger of Osgiliath (7C116)
- Stand to Arms (7U120)
- Unexpected Visitor (7U126)
- Stronghold of Minas Morgul (7R206)
- Úlairë Cantëa, Faster Than Winds (7R211)
- Úlairë Nelya, Assailing Minion (7R215)
- Firefoot, Eomer's Steed (7R232)
- Rohirrim Guard (7C246)
- Encirclement (7R268)
- Gorgoroth Axeman (7U271)
- Gorgoroth Ransacker (7C276)
- Legions of Morgul (7R283)
- Mordor Guard (7C287)
- Mordor Warrior (7U293)
- Orc Brood (7C296)
- Orc Fanatic (7C300)
- Orc Rager (7C304)
- Stronghold of Cirith Ungol (7R314)
- Slow-kindled Courage (7U328)
- Larder (8U23)
- Sméagol, Slippery Sneak (8R27)
- Oathbreaker (8C41)
- A Path Appointed (8U42)
- Sleepless Dead (8U45)
- Black Númenorean (8R49)
- Corsair Lookout (8U56)
- Corsair Marauder (8R57)
- Corsair Plunderer (8C58)
- Haradwaith (8C61)
- Morgul Squealer (8R77)
- Éowyn's Shield (8R88)
- Rohirrim Army (8R91)
- Called Away (8R93)
- Gorgoroth Agitator (8U94)
- Gorgoroth Patrol (8U99)
- Great Hill Troll (8C102)
- Grond, Hammer of the Underworld (8R103)
- Morgai (8C104)
- Sting, Bane of the Eight Legs (8R113)
- City of the Dead (8U118)
- Pippin, Guard of Minas Tirith (8P122)
- Aiglos (9R+12)
- Elven Rope (9R13)
- Knife of the Galadhrim (9R+17)
- Merry’s Dagger (9R18)
- Pippin’s Dagger (9R21)
- Vilya, Ring of Air (9R23)
- Sent Back (9R27)
- Sméagol, Bearer of Great Secrets (9R+30)
- Boromir, Bearer of Council (9R+31)
- Library of Orthanc (9R+39)
- Horn of the Mark (9R45)
- Ithil Stone (9R+47)
- Arwen, Echo of Luthien (10U5)
- Celeborn, Lord of the Galadhrim (10R7)
- Círdan, The Shipwright (10R8)
- Phial of Galadriel, Star-glass (10R13)
- Out of the High Airs (10R17)
- Unabated in Malice (10C24)
- Every Little is a Gain (10C31)
- Corsair Ruffian (10U39)
- Far Harad Mercenaries (10C42)
- Mûmak Chieftain (10R45)
- Cirith Ungol Scavenger (10U54)
- Stooping to the Kill (10C64)
- Unyielding (10U74)
- Advance Scout (10U78)
- Barren Land (10C79)
- Flames Within (10C85)
- Gorgoroth Swarm (10C87)
- Orc Ravager (10R94)
- Rank and File (10U96)
- Ruinous Hail (10U98)
- Make Haste (10C109)
- Narrow Escape (10U111)
- Slunk Out of Sight (10U115)
- Pelennor Prairie (10U118)
- Gimli's Battle Axe, Vicious Weapon (11R9)
- Gandalf's Staff, Ash-staff (11R34)
- New Authority (11U37)
- Strange and Terrible (11U52)
- Bold and Cunning (11C71)
- Column of Easterlings (11C72)
- Force of Harad (11C83)
- Oath Sworn (11R91)
- Patroller of Haradrim (11C93)
- Armed for Battle (11U106)
- Beastly Olog-hai (11R108)
- Bound to its Fate (11U110)
- Dread and Despair (11U118)
- Goblin Hordes (11R123)
- Isengard Underling (11C125)
- Marauding Orcs (11S126)
- Mocking Goblin (11C127)
- Orkish Smith (11C132)
- Persistent Orc (11R134)
- Border Patrol (11U144)
- Rush of Steeds (11C157)
- Devastation (11U182)
- Fortitude (11U185)
- Overpowering Uruk (11U197)
- Ruthless Uruk (11C200)
- Sentinel Uruk (11C201)
- Dark Wings (11U208)
- Hatred Stirred (11U210)
- Watch-tower of Cirith Ungol (11S262)
- Argument Ready to Hand (12U1)
- Belt of Erebor (12U2)
- His Father’s Charge (12C8)
- Loud and Strong (12R9)
- Elrond, Witness to History (12R17)
- Not Alone (12U39)
- Blade of Gondor, Sword of Boromir (12R42)
- Guardian (12U50)
- Invigorated (12U51)
- Tireless (12C52)
- Valorous Leader (12C53)
- Hemmed In (12C70)
- Last Days (12U71)
- Mûmak Rider (12R74)
- Wrathful Hillman (12C78)
- Great Cost (12C88)
- Morgul Tormentor (12U90)
- Orc Dreg (12C92)
- Orc Footman (12C93)
- Orc Tormentor (12C98)
- Retribution (12R101)
- Scavenging Goblins (12C102)
- Storming the Ramparts (12U103)
- Aldred, Eored Soldier (12C107)
- Cast Out (12R108)
- Cleaving a Path (12C110)
- Diversion (12R120)
- Advancing Uruk (12C134)
- Breeding Pit Conscript (12C137)
- Broken Heirloom (12U138)
- Crushing Uruk (12U140)
- Shingle in a Storm (12C145)
- Strange Device (12C146)
- Tempest of War (12U148)
- Uruk Common (12C149)
- Uruk Slaughterer (12R154)
- Worthy of Mordor (12C160)
- Elrond, Witness to History (12RF1)
- City of the Trees (13C12)
- Crashing Cavalry (13C13)
- Kindreds Estranged (13U17)
- Standing Tall (13C25)
- Take Up the Bow (13R26)
- The Palantír of Orthanc, Recovered Seeing Stone (13R36)
- Cunningly Hidden (13U45)
- Gollum, Her Sneak (13U50)
- Little Snuffler (13U52)
- Softly Up Behind (13U56)
- Denethor, Last Ruling Steward (13R64)
- Storied Homestead (13R76)
- Staff of Saruman, Fallen Istar's Stave (13R81)
- Caravan From the South (13C83)
- Driven From the Plains (13C87)
- Dunlending Trapper (13U89)
- Fires Brightly Burning (13U91)
- Howdah (13U94)
- Stragglers (13S99)
- Always Threatening (13U103)
- Defiled (13U105)
- Expendable Servants (13C107)
- Forced March (13R108)
- Isengard Informant (13U110)
- Massing Strength (13C111)
- Orc Plains Runner (13S114)
- Ordnance Grunt (13R117)
- Unforgiving Depths (13C120)
- Bill the Pony, Dearly-loved (13R143)
- Sam, Bearer of Great Need (13R156)
- Endless Assault (13C161)
- Enemy Without Number (13C162)
- Entranced Uruk (13C163)
- Fearless Approach (13C164)
- New Enemy (13U166)
- Uruk Distractor (13U170)
- War Machine (13C176)
- Weapons of Control (13U177)
- They Came From Mordor (13U181)
- Denethor, Last Ruling Steward (13RF8)
- Sam, Bearer of Great Need (13RF16)
- Denethor, Last Ruling Steward (13O7)
- Dain Ironfoot, King Under the Mountain (14R1)
- Grimbeorn, Beorning Chieftain (14R6)
- Duinhir, Tall Man of Blackroot Vale (14R8)
- Furious Hillman (14R10)
- Half-troll of Far Harad (14R12)
- Gandalf, Powerful Guide (15R29)
- Controlled By The Ring (15U41)
- Desperate Move (15R42)
- Swear by the Precious (15U52)
- Unseen Foe (15R53)
- Ithilien Blade (15C62)
- Bold Easterling (15C73)
- Courageous Easterling (15C75)
- Easterling Scout (15C77)
- Ravaging Wild Man (15C91)
- Battlefield Recruit (15S95)
- Battlefield Veteran (15S96)
- Beasts of Burden (15C97)
- Isengard Marauder (15C110)
- Mountain-troll (15R112)
- Orkish Camp (15U113)
- Unreasonable Choice (15R119)
- Éomer’s Spear, Trusty Weapon (15R124)
- Uruk Infantry (15U175)
- Uruk Village Assassin (15C176)
- With All Possible Speed (15R180)
- Gandalf, Powerful Guide (15RF5)
- Gandalf, Powerful Guide (15O2)
- Dead Faces (16R4)
- Balin Avenged (17R2)
- Thorin III, Stonehelm (17R6)
- A New Light (17U15)
- Madril, Loyal Lieutenant (17S30)
- Throne of Minas Tirith (17R36)
- Ceremonial Armor (17R41)
- In the Wild Men's Wake (17R45)
- Saruman, Coldly Still (17S48)
- Stampeding Chief (17R49)
- Stampeding Hillsman (17C50)
- Stampeding Savage (17C53)
- Stampeding Shepherd (17C54)
- Sunland Scout (17R56)
- Sunland Trooper (17C59)
- Sunland Warrior (17C60)
- Vengeful Savage (17C62)
- Vengeful Primitive (17R65)
- Wildman's Oath (17C66)
- Orkish Berserker (17R73)
- Orkish Flanker (17C77)
- Orkish Invader (17R79)
- Orkish Lackey (17C80)
- Orkish Marauder (17C81)
- Orkish Warg-master (17R87)
- Orkish Warrior (17U88)
- Hornblower Leaf (17U108)
- Saruman, Master of the White Hand (17R116)
- White Hand Veteran (17R135)
- You Do Not Know Fear (17R137)
- Dol Guldur (17U145)
- Throne of Minas Tirith (17RF8)
- Stampeding Chief (17RF10)
- Orkish Invader (17RF11)