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'), ']]</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'), ']]</span></span>')=CardName | ||
|where=CR.GameText LIKE '% | |where=CR.GameText LIKE '%archer%' AND C.Culture = 'elven' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Revision as of 00:54, 20 February 2022
- Border Defenses (1C32)
- Double Shot (1R38)
- Elven Bow (1C41)
- Elven Cloak (1C42)
- Legolas, Greenleaf (1R50)
- Legolas, Prince of Mirkwood (1U51)
- Lightfootedness (1C52)
- Orophin, Lorien Bowman (1U56)
- Rúmil, Elven Protector (1U57)
- The Splendor of Their Banners (1R62)
- Support of the Last Homely House (1U64)
- Swan-ship of the Galadhrim (1U65)
- The White Arrows of Lórien (1C68)
- Dismay Our Enemies (2U17)
- Hosts of the Last Alliance (2U18)
- Calaglin, Elf of Lorien (3U10)
- Dínendal, Silent Scout (3U12)
- Legolas, Son of Thranduil (3P121)
- Company of Archers (4R61)
- Elven Bow (4U62)
- Erethón, Naith Lieutenant (4R65)
- Legolas, Dauntless Hunter (4R73)
- Legolas, Elven Comrade (4C74)
- Pengedhel, Naith Warrior (4U81)
- Thónnas, Naith Captain (4U86)
- Legolas, Dauntless Hunter (4M2)
- Break the Charge (5R11)
- Taurnil, Sharp-eyed Bowman (5U13)
- Legolas, Archer of Mirkwood (5P121)
- Break the Charge (5R124)
- Naith Longbow (6C21)
- Naith Warband (6R23)
- Legolas, Fearless Marksman (7R25)
- Legolas, Nimble Warrior (7C26)
- Mirkwood Bowman (7R27)
- A Grey Ship (8U9)
- Legolas, Elven Stalwart (8C10)
- Reckless We Rode (8R12)
- Shake Off the Shadow (8U13)
- Aegnor, Elven Escort (10U4)
- Elven Marksmanship (11R17)
- Legolas, Woodland Emissary (11R22)
- Legolas' Bow (11R23)
- Elven Marksmanship (11RF2)
- Legolas, Woodland Emissary (11RF3)
- Orophin, Brother of Haldir (12C20)
- Rúmil, Brother of Haldir (12C22)
- Taking the High Ground (12U24)
- Legolas, of the Grey Company (13R18)
- Many Miles (13C21)
- Standing Tall (13C25)
- Take Up the Bow (13R26)
- Legolas, of the Grey Company (13RF3)
- Legolas, of the Grey Company (13O3)
- Gildor Inglorion, of the House of Finrod (14R4)
- Forth the Three Hunters! (15C60)
- Dínendal, Mirkwood Archer (15R12)
- Elven Bow (15C13)
- Haldir, Sentry of the Golden Wood (15U17)
- Legolas, of the Woodland Realm (15R19)
- Lórien’s Blessing (15U20)
- Mighty Shot (15U21)
- Point Blank Range (15C23)
- Spied From Afar (15R24)
- Legolas, of the Woodland Realm (15RF3)
- Legolas, of the Woodland Realm (15O1)
- Orophin, Silvan Elf (17S11)
- Rúmil, Silvan Elf (17S12)
- Weapons of Lothlórien (17U14)
- Arwen's Bow (18R4)
- Elven Armaments (18U8)
- Arwen's Bow (18RF1)
- Army Long Trained (19P5)
- Legolas, Skeptical Guide (19P7)
- Legolas, Greenleaf (0P13)
- Legolas, Son of Thranduil (0P15)
- Legolas, Elven Stalwart (0P24)
- Orophin, Brother of Haldir (0P101)
- Haldir, Sentry of the Golden Wood (0P122)
- Legolas, Nimble Elf (0W3)
- Rivendell Scout (30HK51)
- Elf Army (31HD8)
- Legolas, Prince of Mirkwood (31HD9)
- Tauriel, Staunch Defender (31HD10)
- The Evil Becomes Stronger (31HD11)
- Haldir, Naith Commander (V2_8)
- Legolas, Keen-eyed (V1_9)
- Let Fly the Darts of Lindon (V1_10)
