User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary Tag: Manual revert |
No edit summary |
||
| Line 4: | Line 4: | ||
,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 '%ambush%' | |where=CR.GameText LIKE '%ambush%' | ||
|order by={{ | |order by={{CultureSort}} | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul | ||
Revision as of 06:44, 14 April 2022
- Foul Horde (5R50)
- Foul Horde (5R125)
- Fearsome Dunlending (11C79)
- Warrior of Dunland (11C103)
- Enraged Southron (12C64)
- Horror of Harad (14R13)
- Desert Legion (4R218)
- Southron Commander (4U249)
- Southron Fighter (4R251)
- Southron Scout (4C252)
- Southron Soldier (4C254)
- Southron Troop (4R256)
- Southron Veterans (4R257)
- Southron Wanderer (4C258)
- Desert Stalker (5R72)
- Southron Marcher (5C74)
- Southron Runner (5C75)
- Southron Traveler (5C76)
- Strength in Numbers (5U77)
- Southron Invaders (6C81)
- Desert Runner (7C133)
- Desert Scout (7U134)
- Desert Sneak (7C135)
- Raider Bow (7C155)
- Suzerain of Harad (7R170)
- Pelennor Fields (11S253)
