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 '%heal%' AND C.Culture = 'shire' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 06:57, 28 January 2022
- Extraordinary Resilience (1C287)
- Farmer Maggot, Chaser of Rascals (1R288)
- Frodo, Old Bilbo's Heir (1R289)
- Frodo, Son of Drogo (1C290)
- The Gaffer, Sam's Father (1R291)
- Hobbit Appetite (1C294)
- Hobbit Party Guest (1C297)
- Rosie Cotton, Hobbiton Lass (1U309)
- Stout and Sturdy (1C315)
- Frodo's Pipe (3U107)
- The Shire Countryside (3R113)
- Frodo's Cloak (4R303)
- Light Shining Faintly (4U309)
- Sam's Pack (4R317)
- Store-room (4U320)
- You Must Help Us (5C117)
- Merry, Impatient Hobbit (6R113)
- Merry, Impatient Hobbit (6M3)
- Sam, Resolute Halfling (7R327)
- Goldberry, River-daughter (9R+51)
- Unharmed (11S176)
- Flotsam and Jetsam (12C121)
- Home and Hearth (12C122)
- Pippin, Hobbit of Some Intelligence (12R127)
- Simple Living (12U130)
- Faith in Friendship (13C147)
- Fates Entwined (13U148)
- The Gaffer, Master Gardener (13U151)
- New Chapter (13U154)
- Sam, Innocent Traveler (15U153)
- Prized Lagan (18U110)
- Rabbit Stew (19P31)
- Goldberry, River-daughter (0P52)
- Sam, Of Bagshot Row (V1_54)
- We're Coming, Too! (V1_56)