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 '%support area%' | |where=(CR.GameText LIKE '%support area%' OR CR.SubTypes HOLDS 'support area') AND C.CardType = 'Possession' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 05:55, 9 March 2022
- The Mirror of Galadriel (1R55)
- Gandalf's Cart (1U73)
- Morgul Blade (1R216)
- Longbottom Leaf (1C300)
- Old Toby (1C305)
- Thrór's Map (1R318)
- Red Book of Westmarch (2R113)
- Hides (4R19)
- Horn of Helm (5U8)
- Scaffolding (6U73)
- Larder (8U23)
- Spider Poison (8C28)
- Web (8C30)
- Catapult (8R32)
- Black Sails of Umbar (8C50)
- Corsair War Galley (8U59)
- Ships of Great Draught (8R65)
- Grond, Hammer of the Underworld (8R103)
- Strands of Elven Hair (9R22)
- The Art of Gandalf (11U28)
- Ceremonial Armor (17R41)
- Primitive Brand (17C47)
- Wildman's Oath (17C66)
- Vile Pit (17C118)
- Fleet of Corsair Ships (18R66)
- Grond, Forged With Black Steel (18R82)
- Golden Perch Ale (18U108)
- Tom Bombadil's Hat (0P60)
- Primitive Brand (0P128)
- Great Barricade (31HE4)