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=C.Culture = ' | |where=C.Culture = 'sauron' AND CR.GameText LIKE '%hand%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 02:48, 14 March 2022
- Band of the Eye (1R240)
- The Dark Lord's Summons (1U242)
- Desperate Defense of the Ring (1R244)
- Orc Inquisitor (1C268)
- Tower Lieutenant (1U280)
- Southern Spies (2C91)
- Verily I Come (2R94)
- The Dark Lord Advances (3C87)
- Hand of Sauron (3C90)
- Orc Trooper (3R99)
- Tower of Barad-dûr (3R104)
- Hand of Sauron (3M2)
- Eye of Barad-Dûr (5R96)
- Morannon (5R102)
- Orc Runner (5C109)
- Teeth of Mordor (5U110)
- Troll of Udûn (6R106)
- Gorgoroth Garrison (7C273)
- Gorgoroth Officer (7R274)
- Gorgoroth Sapper (7C277)
- Gorgoroth Soldier (7U278)
- Mordor Fighter (7R286)
- Mordor Warrior (7U293)
- Orc Brood (7C296)
- Rope and Winch (7U309)
- Siege Commander (7R311)
- Some Secret Art of Flame (7C313)
- Called Away (8R93)
- Gorgoroth Servitor (8U100)
- Morgai (8C104)
- Ruinous Hail (10U98)
- Speak No More to Me (10R100)
- Danger Wrapped in Shadows (32B237)