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 '%legolas%' AND C.Culture = 'elven' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 10:52, 26 January 2022
- Bow of the Galadhrim (1R33)
- Legolas, Greenleaf (1R50)
- Legolas, Prince of Mirkwood (1U51)
- Long-knives of Legolas (3R21)
- Legolas, Son of Thranduil (3P121)
- Final Count (4R69)
- Legolas, Elven Comrade (4C74)
- Legolas' Sword (5U12)
- Legolas, Archer of Mirkwood (5P121)
- Bow of the Galadhrim, Gift of Galadriel (7R18)
- Legolas, Elven Stalwart (8C10)
- Legolas, Companion of the Ring (11S21)
- Legolas' Bow (11R23)
- Long-knives of Legolas (12R19)
- Forth the Three Hunters! (15C60)
- Focus (15C15)
- Legolas, of the Woodland Realm (15R19)
- Legolas, of the Woodland Realm (15RF3)
- Legolas, of the Woodland Realm (15O1)
- Legolas, Skeptical Guide (19P7)
- Legolas, Greenleaf (0P13)
- Legolas, Son of Thranduil (0P15)
- Legolas, Elven Stalwart (0P24)
- Legolas, Companion of the Ring (0P87)
- Legolas, Prince of Mirkwood (31HD9)
- Legolas, Keen-eyed (V1_9)