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=C.Culture = 'isengard' AND CR.GameText LIKE '% | |where=C.Culture = 'isengard' AND CR.GameText LIKE '%control%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 04:54, 14 April 2023
- Advance Uruk Patrol (4U136)
- Attack on Helm's Deep (4C137)
- Band of Uruk Bowmen (4U138)
- Burning of Westfold (4R144)
- Down to the Last Child (4U148)
- No Dawn for Men (4R163)
- Pillage of Rohan (4R167)
- Race Across the Mark (4R168)
- Uruk Assault Band (4R179)
- Uruk Besieger (4C180)
- Uruk Stormer (4C198)
- Uruk Trooper (4R199)
- Uruk Veteran (4U201)
- Uruk-hai Band (4U202)
- Uruk-hai Horde (4R203)
- Uruk-hai Marauder (4C204)
- Uruk-hai Mob (4U205)
- Uruk-hai Patrol (4C206)
- We Are the Fighting Uruk-hai (4C210)
- Isengard Scimitar (5U54)
- Isengard Scout Troop (5U55)
- Wolves of Isengard (5R69)
- Banner of Isengard (6C59)
- Sack of the Shire (9R40)
- Legion of Isengard (V2_27)
- Trail of Savagery (V2_31)
- Uruk Occupier (V2_34)
