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 '%region%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 10:07, 14 March 2022
- Eregion Hills (3U116)
- Gandalf, Leader of the Company (11S33)
- Well-traveled (11R66)
- Crags of Emyn Muil (11S234)
- Traveled Leader (12C34)
- Traveler’s Homestead (13R42)
- Little Snuffler (13U52)
- Trap Is Sprung (13R57)
- Voice of the Desert, Southron Troop (13R101)
- Chamber Patrol (13R104)
- Sauron, Dark Lord of Mordor (13R140)
- Sceptre of the Dark Lord (13R141)
- Phial of Galadriel, The Light of Earendil (13R155)
- Uruk Blitz (13R169)
- Dark Fell About Him (13R178)
- Abandoned Mine Shaft (13U185)
- Voice of the Desert, Southron Troop (13RF9)
- Chamber Patrol (13RF10)
- Sauron, Dark Lord of Mordor (13RF14)
- Uruk Blitz (13RF17)
- Rapid Reload (15U89)
- Lurtz, Now Perfected (15R162)
- Mount Doom (15R193)
- Mount Doom (15RF18)
- The World Ahead (17R13)
- Orkish Runner (17C83)
- Throne of the Dark Lord (17R105)
- Falls of Rauros (17U146)
- Throne of the Dark Lord (17RF15)
- Ents Marching (18C20)
- Ranger of the North (18R55)
- Harry Goatleaf (18C68)
- Ruffian (18C72)
- Rough Man of the South (18C73)
- Squint-eyed Southerner (18C74)
- Fredegar Bolger, Fatty (18R107)
- Fredegar Bolger, Fatty (18RF15)
- Gandalf, Leader of the Company (0P70)
- Lurtz, Now Perfected (0P126)