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 '%archery%' AND C. | |where=CR.GameText LIKE '%archery total%' AND C.Side = 'shadow' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 12:09, 19 February 2022
- Uruk-hai Armory (1C157)
- Goblin Archer (1R172)
- Goblin Wallcrawler (1C184)
- Pinned Down (1C192)
- Wreathed in Shadow (1U238)
- Orc Bowmen (1R264)
- Moria Archer Troop (2U67)
- Band of Uruk Bowmen (4U138)
- Cloud of Arrows (4C145)
- Driven Back (4R149)
- Elite Crossbowmen (4R150)
- Ranged Commander (4R169)
- Uruk Crossbowman (4C183)
- Weapons of Isengard (4R211)
- Desert Lord (4R219)
- Elite Archer (4U232)
- Rapid Fire (4R243)
- Southron Archer (4R245)
- Southron Bow (4R247)
- Southron Bowman (4C248)
- Southron Archer Legion (6R80)
- Southron Marksmen (7R167)
- Orc Archer Troop (7U294)
- Morgul Ambusher (8C74)
- Morgul Creeper (8C75)
- Morgul Lurker (8C76)
- Gorgoroth Breaker (8U97)
- Gorgoroth Servitor (8U100)
- Archer of Harad (11U67)
- Elevated Fire (11R78)
- Precision Targeting (11R96)
- Army of Uruk-hai (11R177)
- Desert Wind (13R86)
- Howdah (13U94)
- Isengard Infiltrator (13U165)
- White Hand Berserker (17R121)
- Frenzy of Arrows (18U79)
- Gothmog, Morgul Leader (18R80)
- Orkish Archer Troop (18U86)
- Gothmog, Morgul Leader (18RF10)