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'), ']]</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'), ']]</span></span>')=CardName | ||
|where=CR.GameText LIKE '% | |where=CR.GameText LIKE '%initiative%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 05:33, 20 February 2022
- Gimli, Faithful Companion (7C6)
- Gimli's Armor (7U8)
- Legolas, Fearless Marksman (7R25)
- All Save One (7C31)
- Light the Beacons (7R43)
- Sméagol, Hurried Guide (7C72)
- Where Shall We Go (7U78)
- Gondorian Merchant (7R97)
- I Will Go (7C105)
- Madril, Faramir's Aide (7U110)
- Stand to Arms (7U120)
- Targon (7C124)
- Déor (7C222)
- Guarded Fastness (7U234)
- Léowyn (7R239)
- Riding Armor (7U245)
- Sam, Resolute Halfling (7R327)
- Éomer, Valiant Warchief (7P365)
- Aggression (8C1)
- Swept Away (8C48)
- Charged Headlong (8U85)
- So Fair, So Desperate (8C111)
- Memories of Darkness (10U2)
- Glimpse of Fate (10U12)
- Brooding on Tomorrow (10U15)
- Hardy Garrison (10U33)
- Fell Deeds Awake (10U73)
- A Light in His Mind (10U108)