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 '%burden%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 02:19, 1 March 2022
- Elf-song (1C39)
- Songs of the Blessed Realm (1C61)
- Gandalf’s Pipe (1U74)
- Mysterious Wizard (1C78)
- Extraordinary Resilience (1C287)
- Pippin, Hobbit of Some Intelligence (1R307)
- Power According to His Stature (1R308)
- Sam, Son of Hamfast (1C311)
- Sorry About Everything (1C312)
- Narya (3R34)
- Melilot Brandybuck, Merry Dancer (3R110)
- The Shire Countryside (3R113)
- Brace of Coneys (4C298)
- Cliffs of Emyn Muil (4R299)
- Frodo, Tired Traveller (4C302)
- Frodo's Cloak (4R303)
- Get On and Get Away (4R304)
- Good Work (4U305)
- Impatient and Angry (4R307)
- Light Shining Faintly (4U309)
- Mind Your Own Affairs (4U312)
- Pippin, Woolly-footed Rascal (4C314)
- Sam, Samwise the Brave (4C316)
- Seven We Had (4U318)
- Sméagol, Old Noser (5C28)
- Sméagol, Slinker (5R29)
- Frodo, Master of the Precious (5U111)
- No Help for It (5R112)
- No Use That Way (5R113)
- Don’t Follow the Lights (6C38)
- Not Listening (6C43)
- Sméagol, Poor Creature (6C45)
- Held (6R109)
- Sméagol, Always Helps (7R71)
- Sméagol, Hurried Guide (7C72)
- Denethor, Steward of the City (7R85)
- Frodo, Wicked Masster! (7R318)
- Sam, Needer of Vittles (7C326)
- Slow-kindled Courage (7U328)
- Sméagol, Slippery Sneak (8R27)
- Closer and Closer He Bent (8C109)
- Gimli, Bearer of Grudges (9R+4)
- Sméagol, Bearer of Great Secrets (9R+30)
- Boromir, Bearer of Council (9R+31)
- Isildur, Bearer of Heirlooms (9R+33)
- Bilbo, Bearer of Things Burgled (9R+49)
- Tom Bombadil, The Master (9R+52)
- Birthday Present (10R104)
- A Light in His Mind (10U108)
- Nine-fingered Frodo and the Ring of Doom (10C112)
- Ease the Burden (11U29)
- Glamdring, Foe-hammer (11R35)
- New Authority (11U37)
- Shadowfax, Unequaled Steed (11U40)
- One Good Turn Deserves Another (11U49)
- Sméagol, Scout and Guide (11R51)
- The More, The Merrier (11C169)
- Salt from the Shire (11R171)
- Sting, Weapon of Heritage (11R173)
- Glamdring, Foe-hammer (11RF4)
- Sméagol, Scout and Guide (11RF6)
- Salt from the Shire (11RF14)
- Gandalf’s Hat (12R28)
- Járnsmid, Barding Emissary (12R30)
- Mysterious Wizard (12C31)
- Watch and Wait (12R35)
- Golden Glimmer (12C115)
- Diversion (12R120)
- Home and Hearth (12C122)
- Hope is Kindled (12C123)
- Pippin, Hobbit of Some Intelligence (12R127)
- Rosie Cotton, Barmaid (12R129)
- Tolman Cotton, Farmer of Bywater (12S133)
- Gandalf, Bearer of Obligation (13R33)
- The Palantír of Orthanc, Recovered Seeing Stone (13R36)
- Vapour and Steam (13U43)
- Déagol, Fateful Finder (13R46)
- Sméagol, Simple Stoor (13U55)
- Bilbo, Aged Ring-bearer (13R142)
- Daddy Twofoot, Next-door Neighbor (13U144)
- Frodo Gamgee, Son of Samwise (13U150)
- The Gaffer, Master Gardener (13U151)
- Gandalf, Bearer of Obligation (13RF4)
- Déagol, Fateful Finder (13RF6)
- Gandalf, Bearer of Obligation (13O4)
- Gandalf, Powerful Guide (15R29)
- Sméagol, Wretched and Hungry (15R49)
- Hobbiton Brewer, Maker of Fine Ales (15R146)
- Hobbiton Farmer, Lover of Pipeweed (15C147)
- Relaxation (15R152)
- Gandalf, Powerful Guide (15RF5)
- Sméagol, Wretched and Hungry (15RF8)
- Gandalf, Powerful Guide (15O2)
- Shadowfax, Greatest of the Mearas (17R24)
- Faramir, Bearer of Quality (17R28)
- Spirit of the White Tree (17U34)
- Pippin, In the Bloom of Health (17U109)
- Shadowfax, Greatest of the Mearas (17RF3)
- Faramir, Bearer of Quality (17RF6)
- Shadowfax, Greatest of the Mearas (17O1)
- One-Upsmanship (18U23)
- Denethor, On the Edge of Madness (18R42)
- Golden Perch Ale (18U108)
- Sméagol, Pitiable Guide (19P11)
- Sméagol, Old Noser (0P18)
- Tom Bombadil, The Master (0P53)
- Tom Bombadil's Hat (0P60)
- Sting, Weapon of Heritage (0P84)
- Járnsmid, Barding Emissary (0P89)
- Vapour and Steam (0P90)
- Bilbo, Aged Ring-bearer (0D8)
- Sam, Lover of Trees (0W13)
- Gandalf, Powerful Guide (0W38)
- Gilraen's Memorial (V1_22)
- Sam, Of Bagshot Row (V1_54)