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.Culture = 'shire' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 13:24, 26 February 2022
- Extraordinary Resilience (1C287)
- Pippin, Hobbit of Some Intelligence (1R307)
- Power According to His Stature (1R308)
- Sam, Son of Hamfast (1C311)
- Sorry About Everything (1C312)
- 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)
- Frodo, Master of the Precious (5U111)
- No Help for It (5R112)
- No Use That Way (5R113)
- Held (6R109)
- Frodo, Wicked Masster! (7R318)
- Sam, Needer of Vittles (7C326)
- Slow-kindled Courage (7U328)
- Closer and Closer He Bent (8C109)
- 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)
- The More, The Merrier (11C169)
- Salt from the Shire (11R171)
- Sting, Weapon of Heritage (11R173)
- Salt from the Shire (11RF14)
- 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)
- Bilbo, Aged Ring-bearer (13R142)
- Daddy Twofoot, Next-door Neighbor (13U144)
- Frodo Gamgee, Son of Samwise (13U150)
- The Gaffer, Master Gardener (13U151)
- Hobbiton Brewer, Maker of Fine Ales (15R146)
- Hobbiton Farmer, Lover of Pipeweed (15C147)
- Relaxation (15R152)
- Pippin, In the Bloom of Health (17U109)
- Golden Perch Ale (18U108)
- Tom Bombadil, The Master (0P53)
- Tom Bombadil's Hat (0P60)
- Sting, Weapon of Heritage (0P84)
- Bilbo, Aged Ring-bearer (0D8)
- Sam, Lover of Trees (0W13)
- Sam, Of Bagshot Row (V1_54)