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 '%place%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 08:08, 27 March 2023
- Gimli, Dwarf of Erebor (1U12)
- Mallorn-trees (1U54)
- The Mirror of Galadriel (1R55)
- Strength of Spirit (1C85)
- Hobbit Farmer (1C295)
- Hugin, Emissary from Laketown (2C24)
- Dear Friends (2U98)
- My Axe Is Notched (4R52)
- Stout and Strong (4U57)
- Final Count (4R69)
- Strength of Arms (4U82)
- Behold the White Rider (4U88)
- Into Dark Tunnels (4R95)
- Ithilien Trap (4U126)
- Fortress Never Fallen (4U276)
- Supplies of the Mark (4R290)
- Good Work (4U305)
- Sméagol, Old Noser (5C28)
- Suspended Palaces (6C10)
- Toss Me (6R11)
- Agility (6C12)
- Garrison of Osgiliath (6C52)
- We Left None Alive (6C97)
- Kept Safe (6C111)
- Into the West (7C23)
- Still Needed (7C29)
- Gandalf, Manager of Wizards (7R37)
- Gondor Still Stands (7R95)
- Hidden Knowledge (7R104)
- Noble Leaders (7R112)
- Support of the City (7U123)
- Grimbold, Marshal of Rohan (7R233)
- His Golden Shield (7C237)
- Knights of His House (7U238)
- Morning Came (7C243)
- Seeking New Foes (7R249)
- Wind in His Face (7C259)
- Battle in Earnest (8R2)
- Counts But One (8U4)
- Mighty Steed (8U17)
- On Your Doorstep (8U19)
- Saved From the Fire (8R20)
- Closer and Closer He Bent (8C109)
- We Shall Meet Again Soon (8C116)
- Nenya, Ring of Adamant (9R20)
- Sent Back (9R27)
- Sméagol, Bearer of Great Secrets (9R+30)
- Fleet-footed (10C10)
- Brave and Loyal (10U105)
- Uncertain Future (11U26)
- Pippin, Brave Decoy (11R170)
- Attunement (12C16)
- Elrond, Witness to History (12R17)
- Discoveries (12R26)
- Gandalf, The White Rider (12R27)
- Traveled Leader (12C34)
- There’s Another Way (12C40)
- Blade of Gondor, Sword of Boromir (12R42)
- Guardian (12U50)
- Elrond, Witness to History (12RF1)
- Gandalf, The White Rider (12RF3)
- Gandalf, The White Rider (12O1)
- Many Miles (13C21)
- Shrouded Elf (13C23)
- Gladden Homestead (13R49)
- Sméagol, Simple Stoor (13U55)
- Away on the Wind (13U60)
- Isildur, Heir of Elendil (13U71)
- Riddermark Tactician (13C133)
- Frodo, Frenzied Fighter (13R149)
- Frodo, Frenzied Fighter (13RF15)
- Chamber of Records (15U3)
- Glóin, Son of Groin (15R6)
- Elven Warrior (15C14)
- Gift of the Evenstar, Blessed Light (15U16)
- The Mirror of Galadriel, Dangerous Guide (15R22)
- Quickbeam, Hastiest of All Ents (15R34)
- Shadow of the Wood (15U35)
- Skinbark, Elder Ent (15U37)
- Nice Fish (15C46)
- Something Slimy (15U50)
- The Mirror of Galadriel, Dangerous Guide (15RF4)
- Quickbeam, Hastiest of All Ents (15RF7)
- Quickbeam, Hastiest of All Ents (15O3)
- Long-stemmed Pipe (17U21)
- Merry, In the Bloom of Health (17U107)
- Run Until Found (18U2)
- Back to the Light (18R6)
- Sméagol, Old Noser (0P18)
- Pippin, Brave Decoy (0P86)
- Isildur, Heir of Elendil (0P119)
- Thorin, Oakenshield (30S19)
- Thorin, Oakenshield (30P19)
- Wise Advice (32HK62)
- Three for the Elven-Kings (V1_12)