User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
|join on=C.ID = CR.ID | |join on=C.ID = CR.ID | ||
|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'), '|500x500px]]</span></span>')=CardName | ||
|where=C.CardType = 'companion' AND C.Culture = 'gondor' AND CR.GameText LIKE '%ranger%' | |where=C.CardType = 'companion' AND C.Culture = 'gondor' AND CR.GameText LIKE '%ranger%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
Line 14: | Line 14: | ||
|join on=C.ID = CR.ID | |join on=C.ID = CR.ID | ||
|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'), '|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 | |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 | ||
|order by={{StandardSort}} | |order by={{StandardSort}} |
Revision as of 06:45, 4 March 2022
- Aragorn, Ranger of the North (1R89)
- Boromir, Lord of Gondor (1R96)
- Aragorn, King in Exile (1P365)
- Aragorn, Heir to the White City (3R38)
- Boromir, Defender of Minas Tirith (3P122)
- Damrod, Ranger of Ithilien (4U114)
- Faramir, Captain of Gondor (4R116)
- Faramir, Son of Denethor (4C117)
- Gondorian Ranger (4C122)
- Mablung, Soldier of Gondor (4U127)
- Ranger of Ithilien (4C130)
- Aragorn, Wingfoot (4P364)
- Anborn, Skilled Huntsman (6C48)
- Faramir, Ithilien Ranger (6P121)
- Faramir, Stout Captain (7C90)
- Faramir, Wizard's Pupil (7R91)
- Madril, Faramir's Aide (7U110)
- Ranger of Minas Tirith (7C115)
- Ranger of Osgiliath (7C116)
- Targon (7C124)
- Aragorn, Guide and Protector (11S53)
- Aragorn, Strider (11R54)
- Madril, Ranger of Ithilien (11C62)
- Ranger of Westernesse (11S65)
- Aragorn, Strider (11RF7)
- Boromir, Defender of Minas Tirith (12U43)
- Faramir, Dunadan of Gondor (12R47)
- Faramir, Dunadan of Gondor (12RF4)
- Faramir, Dunadan of Gondor (12O2)
- Duilin, Ranger from Blackroot Vale (14R7)
- Halbarad, Ranger of the North (14R9)
- Aragorn, Swift Hunter (15S54)
- Aragorn, Thorongil (15R55)
- Damrod, Dunadan of Gondor (15U57)
- Dúnedain of the South (15C59)
- Gondorian Prowler (15U61)
- Mablung, Ranger of Ithilien (15U63)
- Madril, Defender of Osgiliath (15R64)
- Silent Traveler (15C69)
- Unyielding Ranger (15C71)
- Aragorn, Thorongil (15RF9)
- Madril, Defender of Osgiliath (15RF10)
- Aragorn, Thorongil (15O4)
- Madril, Defender of Osgiliath (15O5)
- Madril, Loyal Lieutenant (17S30)
- Ranger of the White Tree (17S33)
- Boromir, Proud and Noble Man (18R40)
- Faramir, Captain of Ithilien (18R48)
- Ranger of the South (18C56)
- Watcher at Sarn Ford, Ranger of the North (18R59)
- Watcher at Sarn Ford, Ranger of the North (18RF9)
- Watcher at Sarn Ford, Ranger of the North (18O5)
- Aragorn, Well-traveled Guide (19P12)
- Boromir, Destined Guide (19P13)
- Aragorn, Ranger of the North (0P14)
- Faramir, Son of Denethor (0P16)
- Faramir, Captain of Gondor (0P35)
- Boromir, Steward's Heir (0P65)
- Aragorn, Swift Hunter (0P125)
- Watcher at Sarn Ford, Ranger of the North (0P129)
- Faramir, Captain of Ithilien (AFD) ()
- Aragorn, The Dunadan (0W6)