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'), ']]</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'), ']]</span></span>')=CardName | ||
|where=CR.GameText LIKE '%dead% | |where=CR.GameText LIKE '%dead%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 09:38, 27 January 2022
- Despair (1R243)
- Orc Butchery (1R265)
- Sauron's Defenses (1U274)
- Uruk Raider (3C74)
- Well Met Indeed (4R106)
- Beyond All Hope (4R140)
- Driven Back (4R149)
- Uruk Fanatic (4C185)
- Uruk Stalker (4C197)
- Meduseld (6U117)
- Put Forth His Strength (7R205)
- Breached (7R266)
- Saved From the Fire (8R20)
- King of the Dead, Oathbreaker (8R38)
- Sent Back (9R27)
- Sméagol, Bearer of Great Secrets (9R+30)
- Borne Far Away (10R14)
- Field of the Fallen (10U43)
- Houses of Lamentation (10C61)
- Pinnacle of Zirakzigil (11S255)
- Suppressing Uruk (12U147)
- Away on the Wind (13U60)
- Isildur, Heir of Elendil (13U71)
- Uruk Outrider (13C172)
- Shadow of the Wood (15U35)
- Unmistakable Omen (15U118)
- Undead of Angmar (16R6)
- Falls of Rauros (17U146)
- Sting of Shelob (18R35)
- Corsair Halberd (18U63)
- Orkish Headsman (18C89)
- Isildur, Heir of Elendil (0P119)
- Not at Home (30P37)
- Not at Home (30S37)
- Dragon-Sickness (32HI51)
- Lament for the Fallen (V1_8)