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=(CR.GameText LIKE '%ally%' or CR.GameText LIKE '%allies%') AND C.Side = 'Shadow' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 05:10, 13 March 2022
- No Ordinary Storm (1U130)
- Their Arrows Enrage (1C141)
- Goblin Warrior (1C185)
- Beauty Is Fading (1R205)
- Fear (1R212)
- Their Power Is in Terror (1U226)
- Úlairë Lemenya, Lieutenant of Morgul (1U232)
- Demands of the Sackville-Bagginses (2C40)
- Úlairë Attëa, The Easterling (2U82)
- Memory of Many Things (2C88)
- Tower Assassin (2R93)
- Uruk Raider (3C74)
- Our List of Allies Grows Thin (3R102)
- Dunlending Ravager (4C15)
- Dunlending Warrior (4C18)
- Ravage the Defeated (4R32)
- Secret Folk (4U34)
- Banished (4R139)
- Beyond Dark Mountains (4C141)
- Come Down (4R146)
- Down to the Last Child (4U148)
- Gríma, Son of Galmod (4C153)
- Haunting Her Steps (4U155)
- Ranks Without Number (4U170)
- Rohan Is Mine (4R172)
- Unferth, Grima's Bodyguard (4C178)
- Uruk Stalker (4C197)
- Uruk Stormer (4C198)
- Weary (4C212)
- Where Has Gríma Stowed It? (4R214)
- Arrow From the South (4U216)
- Desert Soldier (4U220)
- Desert Spearman (4C221)
- Desert Warrior (4C222)
- Southron Assassin (4R246)
- Southron Spear (4C255)
- Whirling Strike (4C260)
- Gollum, Nasty Treacherous Creature (5C24)
- Berserk Rager (5U45)
- Eye of Barad-Dûr (5R96)
- Twisted Tales (6U75)
- The Balrog, Terror of Flame and Shadow (6R76)
- Gate Picket (6R101)
- The Witch-king, Deathless Lord (6P122)
- Desert Soldier (7U136)
- Desert Spearman (7C137)
- Their Power Is in Terror (7U207)
- Corsair Lookout (8U56)
- Dark Alliance (12R141)
- Uruk Village Stormer (15C178)
- The Balrog, Terror of Flame and Shadow (0P30)
- Narzug, Orkish Assassin (30S36)
- War for Gold (31HB18)
- Ancestral Feuds (31HD29)
- Bert, Troll of Ettenmoors (31B156)
- Alfrid, Lickspittle (32HC25)
- Ulaire Lemenya, Revived (32B226)
- Terrifying Legend (32HC53)
- Warg (32B155)