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 '%condition%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 03:15, 18 April 2023
- Curse From Mordor (1U241)
- Gleaming Spires Will Crumble (1U249)
- Shadow's Reach (1C277)
- Orc Butcher (3C94)
- Orc Guard (3C95)
- Orc Veteran (3U100)
- Orc Warrior (3C101)
- Why Shouldn't I Keep It? (3R105)
- Dead Marshes (5R95)
- Gate Soldier (5C97)
- Morannon (5R102)
- Orc Captain (5R103)
- Orc Fighter (5U105)
- Orc Infantry (5C106)
- Orc Patrol (5U107)
- Gate Sentry (6C102)
- Encirclement (7R268)
- Great Peril of Fire (7U280)
- Great Siege-towers (7U281)
- Legions of Morgul (7R283)
- Orc Butcher (7C297)
- Some Secret Art of Flame (7C313)
- Stronghold of Cirith Ungol (7R314)
- Tower Walkway (7C315)
- Troop Tower (7R316)
- Great Hill Troll (8C102)
- Morgai (8C104)
- Barren Land (10C79)
- Flames Within (10C85)
- Orc Ravager (10R94)
- Speak No More to Me (10R100)
- Jail (32HG39)
- Fell to Its Power (V1_44)
- Gaze of the Eye (V1_45)
- I See You (V1_46)
- A Shadow of the Past (V1_49)