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 '%wound%' AND C.Culture = 'shire' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 00:27, 25 March 2023
- Pippin, Hobbit of Some Intelligence (1R307)
- Power According to His Stature (1R308)
- Consorting With Wizards (2R97)
- Hobbit Sword-play (2U103)
- Nice Imitation (2U106)
- Orc-bane (2R109)
- Frying Pan (3C108)
- Cliffs of Emyn Muil (4R299)
- Mind Your Own Affairs (4U312)
- Swiftly and Softly (4C321)
- No Use That Way (5R113)
- Held (6R109)
- It Burns Us (6U110)
- Kept Safe (6C111)
- Pippin, Hastiest of All (6R114)
- Frodo, Wicked Masster! (7R318)
- Pippin, Wearer of Black and Silver (7R324)
- Unheeded (8R115)
- Pippin, Guard of Minas Tirith (8P122)
- Great Heart (10C107)
- Don’t Let Go (13C145)
- Hobbiton Brewer, Maker of Fine Ales (15R146)
- Little Golden Flower (15R148)
- Second Breakfast (15R154)
- The One Ring (30S48)
- An Invisible Ring (31HA39)
