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= | |where=C.CardType = 'Condition' AND C.Culture = 'men' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 13:14, 21 May 2022
- Láthspell (11U87)
- Oath Sworn (11R91)
- Wielding the Ring (11U105)
- Countless Companies (12U58)
- Goaded to War (12C67)
- Hemmed In (12C70)
- Last Days (12U71)
- Trail of Terror (12U76)
- Caravan From the South (13C83)
- Driven From the Plains (13C87)
- Harmless (13R93)
- Howdah (13U94)
- Lying in Wait (13U95)
- Stragglers (13S99)
- Destroyed Homestead (15R76)
- Grieving the Fallen (15U81)
- Pursuing Horde (15U88)
- Rapid Reload (15U89)
- Whisper in the Dark (18C77)
