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= | |where=CR.GameText LIKE '%archery%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 22:56, 18 August 2022
- Thrarin, Dwarven Smith (1U27)
- Double Shot (1R38)
- Elven Cloak (1C42)
- Legolas, Greenleaf (1R50)
- 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)
- Aragorn’s Bow (1R90)
- Great Shield (1C107)
- One Whom Men Would Follow (1U109)
- Spies of Saruman (1R140)
- Uruk-hai Armory (1C157)
- Bitter Hatred (1U164)
- Goblin Archer (1R172)
- Goblin Wallcrawler (1C184)
- Pinned Down (1C192)
- Wreathed in Shadow (1U238)
- Orc Bowmen (1R264)
- Anduin Wilderland (1C354)
- Anduin Banks (1C356)
- Brown Lands (1U357)
- Hand Axe (2C10)
- Hosts of the Last Alliance (2U18)
- Blood of Númenor (2U31)
- Natural Cover (2C35)
- Shield of Boromir (2R38)
- The Balrog, Durin's Bane (2C51)
- Cave Troll's Chain (2R53)
- Fill With Fear (2U56)
- Moria Archer Troop (2U67)
- Consorting With Wizards (2R97)
- Mithril-coat (2R105)
- Gondor Bowmen (3R41)
- Horn of Boromir (3R42)
- Isengard Warrior (3U61)
- Saruman, Keeper of Isengard (3R68)
- Saruman, Servant of the Eye (3C69)
- Malice (3U79)
- Legolas, Son of Thranduil (3P121)
- Hillman Horde (4R22)
- Company of Archers (4R61)
- Erethón, Naith Lieutenant (4R65)
- Pengedhel, Naith Warrior (4U81)
- Thónnas, Naith Captain (4U86)
- Stump and Bramble (4U101)
- Arrows Thick in the Air (4U110)
- Band of Uruk Bowmen (4U138)
- Cloud of Arrows (4C145)
- Come Down (4R146)
- Covering Fire (4U147)
- Driven Back (4R149)
- Elite Crossbowmen (4R150)
- Ranged Commander (4R169)
- Saruman, Black Traitor (4R173)
- Uruk Crossbowman (4C183)
- Volley Fire (4R209)
- Weapons of Isengard (4R211)
- Arrow From the South (4U216)
- Desert Lord (4R219)
- Elite Archer (4U232)
- Rapid Fire (4R243)
- Southron Archer (4R245)
- Southron Bow (4R247)
- Southron Bowman (4C248)
- Aldor, Soldier of Edoras (4R262)
- Rohirrim Village (4U334)
- Streets of Edoras (4U340)
- Westemnet Plains (4U342)
- Hornburg Parapet (4U351)
- Great Hall (4U353)
- Hornburg Causeway (4U356)
- Break the Charge (5R11)
- Taurnil, Sharp-eyed Bowman (5U13)
- Saruman, Master of Foul Folk (5R56)
- Parapet (5U87)
- Rohirrim Bow (5C88)
- Rohirrim Shield (5C91)
- Break the Charge (5R124)
- Naith Longbow (6C21)
- Naith Warband (6R23)
- Southron Archer Legion (6R80)
- Gimli's Battle Axe, Trusted Weapon (7R9)
- Legolas, Fearless Marksman (7R25)
- Legolas, Nimble Warrior (7C26)
- Mirkwood Bowman (7R27)
- Greatest Stronghold (7R100)
- Southron Leader (7R166)
- Southron Marksmen (7R167)
- Southron Thief (7U168)
- Suzerain of Harad (7R170)
- Rohirrim Javelin (7C248)
- Orc Archer Troop (7U294)
- Pelennor Plain (7U343)
- A Grey Ship (8U9)
- Reckless We Rode (8R12)
- Shake Off the Shadow (8U13)
- Haradrim Marksman (8U60)
- Black Dart (8U69)
- Morgul Ambusher (8C74)
- Morgul Creeper (8C75)
- Morgul Lurker (8C76)
- Éowyn's Shield (8R88)
- Gorgoroth Breaker (8U97)
- Gorgoroth Servitor (8U100)
- Final Strike (10U20)
- Elven Marksmanship (11R17)
- Legolas, Woodland Emissary (11R22)
- Bow of Minas Tirith (11U58)
- Archer of Harad (11U67)
- Elevated Fire (11R78)
- Precision Targeting (11R96)
- Riddermark Javelin (11U151)
- Army of Uruk-hai (11R177)
- Anduin Banks (11U227)
- North Undeep (11S250)
- Rohan Uplands (11S257)
- Elven Marksmanship (11RF2)
- Legolas, Woodland Emissary (11RF3)
- Taking the High Ground (12U24)
- Legolas, of the Grey Company (13R18)
- Many Miles (13C21)
- Take Up the Bow (13R26)
- Desert Wind (13R86)
- Howdah (13U94)
- Riddermark Tactician (13C133)
- Isengard Infiltrator (13U165)
- Legolas, of the Grey Company (13RF3)
- Legolas, of the Grey Company (13O3)
- Gildor Inglorion, of the House of Finrod (14R4)
- Brand, King of Dale (14R5)
- Forth the Three Hunters! (15C60)
- Forth the Three Hunters! (15C60)
- Legolas, of the Woodland Realm (15R19)
- Lórien’s Blessing (15U20)
- Mighty Shot (15U21)
- Aragorn’s Bow, Ranger's Longbow (15R56)
- Forth the Three Hunters! (15C60)
- Grieving the Fallen (15U81)
- Rapid Reload (15U89)
- Anduin River (15U187)
- Legolas, of the Woodland Realm (15RF3)
- Legolas, of the Woodland Realm (15O1)
- Orophin, Silvan Elf (17S11)
- Rúmil, Silvan Elf (17S12)
- White Hand Berserker (17R121)
- Arwen's Bow (18R4)
- Elven Armaments (18U8)
- Dúnadan's Bow (18U45)
- Shield of the White Tree (18C57)
- Corsair Bow (18U61)
- Frenzy of Arrows (18U79)
- Gothmog, Morgul Leader (18R80)
- Orkish Archer Troop (18U86)
- Orkish Defender (18C88)
- Éomer's Bow (18R95)
- Erkenbrand's Shield (18R97)
- Cleaved (18R114)
- Lurtz's Bow, Black-fletch Bow (18R119)
- Pikes Upon Pikes (18U121)
- Arwen's Bow (18RF1)
- Gothmog, Morgul Leader (18RF10)
- Erkenbrand's Shield (18RF12)
- Erkenbrand's Shield (18O7)
- Army Long Trained (19P5)
- Legolas, Skeptical Guide (19P7)
- The Balrog, Demon of Might (19P18)
- Horn of Boromir (0P5)
- The Balrog, Durin's Bane (0P10)
- Saruman, Servant of the Eye (0P11)
- Legolas, Greenleaf (0P13)
- Legolas, Son of Thranduil (0P15)
- Aragorn’s Bow (0P41)
- Bow of Minas Tirith (0P72)
- Legolas, Nimble Elf (0W3)
- Kili, Brother of Fili (30P12)
- Kili, Brother of Fili (30S12)
- Esgaroth Volunteers (30HC54)
- Mithril Coat (31HE5)
- Elf Army (31HD8)
- Legolas, Prince of Mirkwood (31HD9)
- The Evil Becomes Stronger (31HD11)
- Skillful negociator (31HA43)
- Baïn, Son of Bard (32HC15)
- Black Arrow (32HC16)
- Percy, Bard's Lieutenant (32HC19)
- Former Herald (32HG21)
- Legolas, Keen-eyed (V1_9)
- Let Fly the Darts of Lindon (V1_10)
- Saruman, Fell Voice (V1_30)