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=CR.GameText LIKE '% | |where=CR.GameText LIKE '%instead%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 15:42, 7 December 2022
- The One Ring, Isildur's Bane (1R1)
- The One Ring, The Ruling Ring (1C2)
- Beauty Is Fading (1R205)
- Blade Tip (1U209)
- Extraordinary Resilience (1C287)
- The One Ring, Answer To All Riddles (4R1)
- The One Ring, The Ruling Ring (4C2)
- Elven Brooch (4U63)
- Into Dark Tunnels (4R95)
- Treebeard, Earthborn (4R103)
- Come Down (4R146)
- Held (6R109)
- The One Ring, The Ruling Ring (7C1)
- The One Ring, Such a Weight to Carry (7R2)
- The Dead City (7R56)
- Hobbitses Are Dead (7R61)
- Morning Came (7C243)
- Encirclement (7R268)
- Gorgoroth Sapper (7C277)
- Elessar's Edict (8R33)
- The One Ring, The Binding Ring (9R+1)
- Gorbag's Sword (10R60)
- The One Ring, The Ring of Rings (11R1)
- The One Ring, The Ruling Ring (11S2)
- Persistent Orc (11R134)
- Force of Uruk-hai (11R184)
- The One Ring, The Ring of Rings (11RF1)
- Cunningly Hidden (13U45)
- Fires Brightly Burning (13U91)
- Defiled (13U105)
- Ride With Me (13C134)
- New Enemy (13U166)
- Uruk Reserve (13C173)
- From Hideous Eyrie (13U179)
- The One Ring, The Ring of Doom (15R1)
- The One Ring, The Ruling Ring (15S2)
- The Mirror of Galadriel, Dangerous Guide (15R22)
- One Last Surprise (15R33)
- Lying Counsel (15U85)
- The One Ring, The Ring of Doom (15RF1)
- The Mirror of Galadriel, Dangerous Guide (15RF4)
- One Last Surprise (15RF6)
- Gwaihir, The Windlord (17R20)
- Land Had Changed (17R114)
- Gwaihir, The Windlord (17RF4)
- Gwaihir, The Windlord (17O2)
- Erkenbrand's Horn (18R96)
- Final Triumph (18R115)
- Foot of Mount Doom (18U135)
- Erkenbrand's Horn (18RF11)
- Erkenbrand's Horn (18O6)
- The One Ring, The Great Ring (19P1)
- Sauron’s Might (19P27)
- The One Ring, The Binding Ring (0P68)
- The One Ring (30S48)
- The Arkenstone, King's Jewel (31HE7)
- War for Gold (31HB18)
- Rath Dínen (V0_1)