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.CardType = 'minion' AND C.Culture = 'sauron' AND CR.GameText LIKE '%discard%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 11:30, 22 March 2022
- Band of the Eye (1R240)
- Morgul Skulker (1U258)
- Orc Inquisitor (1C268)
- Tower Lieutenant (1U280)
- Orc Scout (2C89)
- Orc Guard (3C95)
- Orc Veteran (3U100)
- Orc Warrior (3C101)
- Orc Cutthroat (5U104)
- Orc Infantry (5C106)
- Orc Patrol (5U107)
- Orc Runner (5C109)
- Gate Sentry (6C102)
- Troll of Udûn (6R106)
- Wisp of Pale Sheen (6C108)
- Army of Udûn (7U264)
- Gorgoroth Axeman (7U271)
- Gorgoroth Garrison (7C273)
- Gorgoroth Officer (7R274)
- Gorgoroth Ransacker (7C276)
- Gorgoroth Sapper (7C277)
- Gorgoroth Soldier (7U278)
- Mordor Guard (7C287)
- Mordor Warrior (7U293)
- Orc Brood (7C296)
- Orc Fanatic (7C300)
- Orc Rager (7C304)
- Siege Commander (7R311)
- Gorgoroth Agitator (8U94)
- Gorgoroth Patrol (8U99)
- Great Hill Troll (8C102)
- Advance Scout (10U78)
- Gorgoroth Swarm (10C87)
- Orc Ravager (10R94)
- Gorgoroth Swarm (0P55)
- Gorgoroth Swarm (0W28)
- Bolg, Servant of Sauron (31HD37)
- Azog, Servant of Sauron (32HF35)
- Bolg, Captain of the Goblin Army (32S236)
- Orkish Veteran (32S243)