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 '%spot 5 companions%' OR CR.GameText LIKE '%spot 6 companions%' OR CR.GameText LIKE '%spot 7 companions%' OR CR.GameText LIKE '%spot 5 threats%' OR CR.GameText LIKE '%spot 6 threats%' OR CR.GameText LIKE '%spot 7 threats%' | |where= (CR.GameText LIKE '%spot 5 companions%' OR CR.GameText LIKE '%spot 6 companions%' OR CR.GameText LIKE '%spot 7 companions%' OR CR.GameText LIKE '%spot 5 threats%' OR CR.GameText LIKE '%spot 6 threats%' OR CR.GameText LIKE '%spot 7 threats%') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 03:00, 16 April 2022
- Caradhras Has Not Forgiven Us (1R123)
- Greed (1R125)
- Savagery to Match Their Numbers (1R139)
- Uruk Fighter (1C146)
- Uruk Warrior (1C156)
- Úlairë Enquëa, Lieutenant of Morgul (1U231)
- Journey Into Danger (1R253)
- The Number Must Be Few (1U260)
- Beyond the Height of Men (2R39)
- Isengard Smith (3U60)
- Dunlending Pillager (4U13)
- On the March (4C241)
- Southron Commander (4U249)
- Southron Fighter (4R251)
- Southron Troop (4R256)
- Southron Veterans (4R257)
- Southron Wanderer (4C258)
- Battering Ram (5U44)
- Gate Veteran (5C99)
- Isengard Mechanics (6R68)
- Isengard Mechanics (6R127)
- Mûmak Commander (7R152)
- Southron Thief (7U168)
- Nazgûl Scimitar (7U203)
- Úlairë Enquëa, Faster Than Winds (7U212)
- Orc Assault Band (7U295)
- Orc Savage (7U305)
- Osgiliath Crossing (7U353)
- Pelennor Grassland (7U354)
- Hidden Even From Her (8C22)
- Morgul Squealer (8R77)
- Far Harad Mercenaries (10C42)
- Gorgoroth Swarm (10C87)
- Fletcher of Harad (11R81)
- Raging Dunlending (11S97)
- Demoralized (11U114)
- Frenzied Orc (11C122)
- Invincible Uruk (11S190)
- Úlairë Nertëa, Ninth of the Nine Riders (11S223)
- Fletcher of Harad (11RF9)
- Hemmed In (12C70)
- Great Cost (12C88)
- Broken in Defeat (12R139)
- Shingle in a Storm (12C145)
- Úlairë Cantëa, Black Assassin (12R174)
- Unending Life (12C181)
- The Angle (12U185)
- Úlairë Cantëa, Black Assassin (12RF16)
- Úlairë Cantëa, Black Assassin (12O7)
- Úlairë Enquëa, Sixth of the Nine Riders (13R182)
- Tower Troll (15R117)
- Úlairë Nelya, Fell Rider (15R186)
- Úlairë Nelya, Fell Rider (15RF17)
- Úlairë Nelya, Fell Rider (15O9)
- Saruman, Instigator of Insurrection (17R37)
- Beast of War (17U40)
- Sunland Guard (17C55)
- Lurtz, Halfling Hunter (18R118)
- Úlairë Enquëa, Dark Threat (19P36)
- Gorgoroth Swarm (0P55)
- Úlairë Enquëa, Sixth of the Nine Riders (0P113)
- Úlairë Nertëa, Ninth of the Nine Riders (0P116)
- Lurtz, Halfling Hunter (0W35)
- Saruman, Instigator of Insurrection (0W36)
- Orkish Marauder (30S38)
- Erebor (30S55)
- Wicked Spider (32S160)