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 '%artifact%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 22:59, 8 March 2022
- Gandalf's Cart (1U73)
- Gandalf's Wisdom (2C23)
- Frodo, Reluctant Adventurer (2C102)
- Frodo, Reluctant Adventurer (2M2)
- Something Draws Near (3U26)
- Roll of Thunder (4U99)
- Elrond, Elven Lord (7R21)
- Durin III, Dwarven Lord (9R+3)
- Ring of Accretion (9R6)
- Ring of Fury (9R+7)
- Ring of Guile (9R8)
- Ring of Retribution (9R9)
- Aiglos (9R+12)
- Galadriel, Bearer of Wisdom (9R+14)
- Narya, Ring of Fire (9R19)
- Nenya, Ring of Adamant (9R20)
- Vilya, Ring of Air (9R23)
- Elendil, The Tall (9R+32)
- Isildur, Bearer of Heirlooms (9R+33)
- Narsil, Blade of the Faithful (9R+34)
- Sapling of the White Tree (9R35)
- Scroll of Isildur (9R36)
- Seeing Stone of Minas Anor (9R37)
- Seeing Stone of Orthanc (9R38)
- The Red Arrow (9R46)
- Phial of Galadriel, Star-glass (10R13)
- Thrarin, Smith of Erebor (12U15)
- Déagol, Fateful Finder (13R46)
- Déagol, Fateful Finder (13RF6)
- Ring of Artifice (17R4)
- Ring of Artifice (17RF1)
- Celebring, Elven-smith (18R7)
- Frodo, Mr. Underhill (0P67)
- Thorin, Oakenshield (30S19)
- Thorin, Oakenshield (30P19)
- Gandalf, The Grey (30S27)
- Bilbo, Collector of Treasures (30S44)
- Thranduil, Elven King (31HD12)
- Thráin, Father of Thorin (32HF9)
- Thrór's Heirlooms (32HF10)
- Ring of Thrór (32HF44)
- Library of Rivendell (V1_11)
- Gilraen's Memorial (V1_22)