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 '%condition%' AND C.Culture = 'gondor' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 20:20, 14 March 2022
- Athelas (1U94)
- Boromir's Cloak (1U98)
- The Saga of Elendil (1R114)
- Blood of Númenor (2U31)
- Gondor Bowmen (3R41)
- Forbidden Pool (4R120)
- Forests of Ithilien (4R121)
- Henneth Annûn (4R125)
- Ithilien Trap (4U126)
- Ruins of Osgiliath (4R133)
- Citadel of the Stars (5C32)
- City Wall (5C33)
- Knight of Gondor (5C36)
- Stone Tower (5R39)
- Garrison of Osgiliath (6C52)
- First Level (7C92)
- Gondor Still Stands (7R95)
- Guarded (7R101)
- Hidden Knowledge (7R104)
- Iorlas (7U107)
- Long Prepared (7U109)
- Noble Leaders (7R112)
- Second Level (7C118)
- Seventh Level (7R119)
- Support of the City (7U123)
- Third Level (7U125)
- Unexpected Visitor (7U126)
- Fourth Level (8C35)
- Swept Away (8C48)
- Fifth Level (10U32)
- Houses of Healing (11U61)
- Guardian (12U50)
- Invigorated (12U51)
- Tireless (12C52)
- Valorous Leader (12C53)
- Away on the Wind (13U60)
- Guard of the White Tree (13U67)
- Kingsfoil (13C73)
- Storied Homestead (13R76)
- Decorated Barricade (15R58)
- No Quicker Path (15C65)
- Portico (15U67)
- Tremendous Wall (15R70)
- Andúril, Sword That Was Broken (17R27)
- Madril, Loyal Lieutenant (17S30)
- Spirit of the White Tree (17U34)
- Andúril, Sword That Was Broken (17RF5)
- Disarmed (18U46)
- Soldier's Cache (18U58)
- Not Bound to His Fate (19P14)
- Guard of the White Tree (0P107)
- You Have My Sword (V1_24)