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 '%strength%' AND C.CardType = 'Event' AND (CR.GameText LIKE '%uruk%' OR C.Culture = 'isengard') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 18:56, 18 March 2022
- Bred for Battle (1C121)
- Lurtz's Battle Cry (1R128)
- Parry (1R132)
- Savagery to Match Their Numbers (1R139)
- Servants to Saruman (3C70)
- Ferocity (4C151)
- Kill Them Now (4C156)
- Men Will Fall (4U161)
- Still They Came (4C175)
- Vengeance (4U208)
- We Are the Fighting Uruk-hai (4C210)
- Wolf-voices (5C68)
- Sack of the Shire (9R40)
- Brutality (11S180)
- Furor (11S187)
- Broken in Defeat (12R139)
- Quelling Force (12C143)
- New Enemy (13U166)
- Violent Hurl (15C179)
- Land Had Changed (17R114)
- Final Triumph (18R115)
- Ghastly Wound (18C117)