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 '%shadow number%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 11:57, 14 March 2022
- No Stranger to the Shadows (1U108)
- A Talent for Not Being Seen (1U316)
- Deft in Their Movements (2C99)
- Gimli, Dwarf of the Mountain-race (2P121)
- Gimli, Dwarf of the Mountain-race (2M4)
- Bill the Pony (3U106)
- No Refuge (4R29)
- White Rocks (4U346)
- Hornburg Courtyard (4U350)
- Fortress of Orthanc (4U360)
- I’d Make You Squeak (5U101)
- West Road (7U337)
- Still Far Ahead (8U29)
- Come Away (12R37)
- Orkish Scout (17R84)
- White Hand Enforcer (17C125)
- Bill the Pony (0P2)
- Secret Door (32HF48)
