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 '%burdens%' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 22:35, 18 January 2023
- Gandalf’s Pipe (1U74)
- Mysterious Wizard (1C78)
- Cliffs of Emyn Muil (4R299)
- Get On and Get Away (4R304)
- Sam, Samwise the Brave (4C316)
- No Help for It (5R112)
- No Use That Way (5R113)
- Not Listening (6C43)
- Frodo, Wicked Masster! (7R318)
- Slow-kindled Courage (7U328)
- 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)
- Ease the Burden (11U29)
- The More, The Merrier (11C169)
- Gandalf’s Hat (12R28)
- Járnsmid, Barding Emissary (12R30)
- Mysterious Wizard (12C31)
- Golden Glimmer (12C115)
- Diversion (12R120)
- Rosie Cotton, Barmaid (12R129)
- Gandalf, Bearer of Obligation (13R33)
- Frodo Gamgee, Son of Samwise (13U150)
- Gandalf, Bearer of Obligation (13RF4)
- Gandalf, Bearer of Obligation (13O4)
- Hobbiton Brewer, Maker of Fine Ales (15R146)
- Relaxation (15R152)
- Faramir, Bearer of Quality (17R28)
- Faramir, Bearer of Quality (17RF6)
- Tom Bombadil, The Master (0P53)
- Járnsmid, Barding Emissary (0P89)
- Sam, Lover of Trees (0W13)