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=C.Culture = 'isengard' AND C.SetNum IN (1,2,3,4,5,6,7,8,9,10) | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 08:02, 21 March 2022
- Alive and Unspoiled (1R120)
- Bred for Battle (1C121)
- Breeding Pit (1C122)
- Caradhras Has Not Forgiven Us (1R123)
- Cruel Caradhras (1R124)
- Greed (1R125)
- Hunt Them Down! (1U126)
- Lurtz, Servant of Isengard (1R127)
- Lurtz's Battle Cry (1R128)
- The Misadventure of Mr. Underhill (1R129)
- No Ordinary Storm (1U130)
- Orthanc Assassin (1R131)
- Parry (1R132)
- Saruman's Ambition (1C133)
- Saruman's Chill (1C134)
- Saruman's Frost (1U135)
- Saruman's Power (1U136)
- Saruman's Reach (1R137)
- Saruman's Snows (1C138)
- Savagery to Match Their Numbers (1R139)
- Spies of Saruman (1R140)
- Their Arrows Enrage (1C141)
- Traitor's Voice (1U142)
- Troop of Uruk-hai (1R143)
- Uruk Bloodlust (1C144)
- Uruk Brood (1C145)
- Uruk Fighter (1C146)
- Uruk Guard (1R147)
- Uruk Lieutenant (1R148)
- Uruk Messenger (1C149)
- Uruk Rager (1C150)
- Uruk Savage (1C151)
- Uruk Shaman (1C152)
- Uruk Slayer (1U153)
- Uruk Soldier (1C154)
- Uruk Spy (1R155)
- Uruk Warrior (1C156)
- Uruk-hai Armory (1C157)
- Uruk-hai Raiding Party (1C158)
- Uruk-hai Rampage (1U159)
- Uruk-hai Sword (1C160)
- Wariness (1U161)
- Worry (1U162)
- Lurtz, Servant of Isengard (1M3)
- Beyond the Height of Men (2R39)
- Demands of the Sackville-Bagginses (2C40)
- Evil Afoot (2U41)
- Goblin Man (2C42)
- Lurtz's Sword (2R43)
- No Business of Ours (2C44)
- Too Much Attention (2R45)
- Uruk Captain (2R46)
- Uruk Scout (2C47)
- Wizard Storm (2U48)
- Abandoning Reason for Madness (3C49)
- Can You Protect Me From Yourself? (3R50)
- Coming for the Ring (3C51)
- A Fell Voice on the Air (3R52)
- Hate and Anger (3U53)
- Hollowing of Isengard (3R54)
- Isengard Axe (3C55)
- Isengard Forger (3C56)
- Isengard Retainer (3U57)
- Isengard Servant (3U58)
- Isengard Shaman (3C59)
- Isengard Smith (3U60)
- Isengard Warrior (3U61)
- Isengard Worker (3C62)
- One of You Must Do This (3C63)
- Orc Commander (3R64)
- Orc Overseer (3R65)
- Orthanc Berserker (3R66)
- The Palantír of Orthanc (3R67)
- Saruman, Keeper of Isengard (3R68)
- Saruman, Servant of the Eye (3C69)
- Servants to Saruman (3C70)
- Tower of Orthanc (3R71)
- Trapped and Alone (3U72)
- The Trees Are Strong (3U73)
- Uruk Raider (3C74)
- Uruk Ravager (3U75)
- Advance Uruk Patrol (4U136)
- Attack on Helm's Deep (4C137)
- Band of Uruk Bowmen (4U138)
- Banished (4R139)
- Beyond All Hope (4R140)
- Beyond Dark Mountains (4C141)
- Broad-bladed Sword (4C142)
- Brought Back Alive (4U143)
- Burning of Westfold (4R144)
- Cloud of Arrows (4C145)
- Come Down (4R146)
- Covering Fire (4U147)
- Down to the Last Child (4U148)
- Driven Back (4R149)
- Elite Crossbowmen (4R150)
- Ferocity (4C151)
- Get Back (4U152)
- Gríma, Son of Galmod (4C153)
- Gríma, Wormtongue (4R154)
- Haunting Her Steps (4U155)
- Kill Them Now (4C156)
- Leechcraft (4R157)
- Lieutenant of Orthanc (4R158)
- Many Riddles (4U159)
- Mauhúr, Patrol Leader (4R160)
- Men Will Fall (4U161)
- New Power Rising (4R162)
- No Dawn for Men (4R163)
- Orthanc Champion (4R164)
- Orthanc Warrior (4C165)
- The Palantír of Orthanc, Seventh Seeing-stone (4R166)
- Pillage of Rohan (4R167)
- Race Across the Mark (4R168)
- Ranged Commander (4R169)
- Ranks Without Number (4U170)
- Rest While You Can (4R171)
- Rohan Is Mine (4R172)
- Saruman, Black Traitor (4R173)
- Saruman's Staff, Wizard's Device (4R174)
- Still They Came (4C175)
- Uglúk, Servant of Saruman (4R176)
- Uglúk's Sword (4R177)
- Unferth, Grima's Bodyguard (4C178)
- Uruk Assault Band (4R179)
- Uruk Besieger (4C180)
- Uruk Chaser (4C181)
- Uruk Crossbow Troop (4U182)
- Uruk Crossbowman (4C183)
- Uruk Defender (4C184)
- Uruk Fanatic (4C185)
- Uruk Follower (4R186)
- Uruk Foot Soldier (4C187)
- Uruk Hunter (4U188)
- Uruk Plains Runner (4C189)
- Uruk Pursuer (4C190)
- Uruk Rear Guard (4C191)
- Uruk Regular (4C192)
- Uruk Runner (4C193)
- Uruk Searcher (4U194)
- Uruk Seeker (4C195)
- Uruk Spear (4C196)
- Uruk Stalker (4C197)
- Uruk Stormer (4C198)
- Uruk Trooper (4R199)
- Uruk Vanguard (4R200)
- Uruk Veteran (4U201)
- Uruk-hai Band (4U202)
- Uruk-hai Horde (4R203)
- Uruk-hai Marauder (4C204)
- Uruk-hai Mob (4U205)
- Uruk-hai Patrol (4C206)
- Uruk-hai Raiding Party (4C207)
- Vengeance (4U208)
- Volley Fire (4R209)
- We Are the Fighting Uruk-hai (4C210)
- Weapons of Isengard (4R211)
- Weary (4C212)
- What Did You Discover? (4R213)
- Where Has Gríma Stowed It? (4R214)
- Wounded (4R215)
- Battering Ram (5U44)
- Berserk Rager (5U45)
- Berserk Savage (5R46)
- Berserk Slayer (5R47)
- Black Shapes Crawling (5U48)
- Devilry of Orthanc (5R49)
- Foul Horde (5R50)
- Gríma, Chief Counselor (5R51)
- Isengard Flanker (5C52)
- Isengard Rider (5C53)
- Isengard Scimitar (5U54)
- Isengard Scout Troop (5U55)
- Saruman, Master of Foul Folk (5R56)
- Scaling Ladder (5U57)
- Sharku, Warg-captain (5R58)
- Sharku's Warg (5R59)
- Siege Engine (5U60)
- Uruk Engineer (5C61)
- Uruk Sapper (5C62)
- Uruk-hai Berserker (5U63)
- War-warg (5U64)
- Warg (5C65)
- Warg-master (5C66)
- Warg-rider (5C67)
- Wolf-voices (5C68)
- Wolves of Isengard (5R69)
- Foul Horde (5R125)
- Gríma, Chief Counselor (5M2)
- Agents of Orthanc (6R57)
- Assault Ladder (6U58)
- Banner of Isengard (6C59)
- Berserk Butcher (6R60)
- Desertion (6U61)
- Fires and Foul Fumes (6R62)
- Gnawing, Biting, Hacking, Burning (6U63)
- Iron Fist of the Orc (6U64)
- Isengard Artisan (6C65)
- Isengard Builder (6U66)
- Isengard Journeyman (6C67)
- Isengard Mechanics (6R68)
- Isengard Plodder (6C69)
- Isengard Tender (6U70)
- Isengard Tinker (6C71)
- Rohirrim Traitor (6C72)
- Scaffolding (6U73)
- Sharku, Vile Marauder (6R74)
- Twisted Tales (6U75)
- Isengard Mechanics (6R127)
- Library of Orthanc (9R+39)
- Sack of the Shire (9R40)
- Suffered Much Loss (10U35)