User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
,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=C.CardType = 'Event' AND C.Culture = 'rohan' AND CR.GameText LIKE '%token%' AND C.Side = 'Free Peoples' AND CR.Subtitle LIKE '%thrall%' AND CR.SubTypes HOLDS 'skirmish' AND CR.TwilightCost = 3 AND C.SetNum IN (1,2,3,4,5,6,7,8,9,10) | |where=C.CardType = 'Event' AND C.Culture = 'rohan' AND CR.GameText LIKE '%token%' AND C.Side = 'Free Peoples' AND CR.Subtitle LIKE '%thrall%' AND CR.SubTypes HOLDS 'skirmish' AND CR.TwilightCost = 3 AND C.SetNum IN (1,2,3,4,5,6,7,8,9,10) | ||
|order by={{StandardSort}} | |order by={{StandardSort}} {{CultureSort}} | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul | ||
Revision as of 07:40, 14 April 2022
- Follow Sméagol (5U23)
- Poor Wretch (5C27)
- Don’t Look at Them (6R39)
- Don’t Look at Them (6R125)
- Days Growing Dark (7U55)
- The Dead City (7R56)
- Never (7C65)
- Scouting (7R68)
- Secret Paths (7R69)
- We Hates Them (7U77)
- Safe Passage (11R50)
- Come Away (12R37)
- There’s Another Way (12C40)
- Gladden Homestead (13R49)
- Called to Mordor (15U39)
- Connected By Fate (15R40)
- Herbs and Stewed Rabbit (15U44)
- Nice Fish (15C46)
- Evil-smelling Fens (5U22)
- They Stole It (6R46)
- Fat One Wants It (7R57)
- Heavy Burden (7U60)
- It's Mine (7C62)
- Let Her Deal With Them (7R63)
- Plotting (7R67)
- Hidden Even From Her (8C22)
- Promise Keeping (8R24)
- Slippery as Fishes (9R+29)
- Final Strike (10U20)
- Reclaim the Precious (10U22)
- Unabated in Malice (10C24)
- Incited (11R44)
- Not Yet Vanquished (11R48)
- Not Alone (12U39)
- Treacherous Little Toad (12U41)
- Chasm’s Edge (13R44)
- Controlled By The Ring (15U41)
- Not This Time! (15R47)
- Deceit (18R29)
- Not Easily Avoided (18R32)
- Better Than Nothing (31B119)
- Riddles in the Dark (31HA22)
