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%' | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul | ||
Revision as of 13:38, 17 March 2022
- Bred for Battle (1C121)

- Broken in Defeat (12R139)

- Brutality (11S180)

- Ferocity (4C151)

- Final Triumph (18R115)

- Furor (11S187)

- Ghastly Wound (18C117)

- Land Had Changed (17R114)

- Lurtz's Battle Cry (1R128)

- New Enemy (13U166)

- Parry (1R132)

- Quelling Force (12C143)

- Savagery to Match Their Numbers (1R139)

- Still They Came (4C175)

- Violent Hurl (15C179)

- We Are the Fighting Uruk-hai (4C210)
