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.CardType = ' | |where=C.CardType = 'event' AND C.Side = 'Shadow' AND C.SetNum IN (4,5,6,7,8,9,10) AND C.Culture = 'isengard' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 08:33, 4 March 2022
- Beyond All Hope (4R140)
- Beyond Dark Mountains (4C141)
- Brought Back Alive (4U143)
- Cloud of Arrows (4C145)
- Driven Back (4R149)
- Ferocity (4C151)
- Get Back (4U152)
- Haunting Her Steps (4U155)
- Kill Them Now (4C156)
- Men Will Fall (4U161)
- New Power Rising (4R162)
- No Dawn for Men (4R163)
- Still They Came (4C175)
- Vengeance (4U208)
- Volley Fire (4R209)
- We Are the Fighting Uruk-hai (4C210)
- Where Has Gríma Stowed It? (4R214)
- Black Shapes Crawling (5U48)
- Wolf-voices (5C68)
- Fires and Foul Fumes (6R62)
- Sack of the Shire (9R40)