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=C.CardType = 'minion' AND CR.GameText LIKE '%archer%' | |where=C.CardType = 'minion' AND CR.TwilightCost < 4 AND (CR.Strength > 8 OR CR.GameText LIKE '%strength%' OR CR.GameText LIKE '%archer%' OR CR.GameText LIKE '%wound%') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 21:16, 7 March 2022
- Uruk Lieutenant (1R148)
- Uruk Messenger (1C149)
- Uruk Warrior (1C156)
- Goblin Marksman (1C176)
- Goblin Wallcrawler (1C184)
- Guard Commander (1R186)
- Morgul Skirmisher (1U257)
- Morgul Warden (1R259)
- Orc Hunters (1U267)
- Orc Inquisitor (1C268)
- Orc Scouting Band (1U270)
- Orc Soldier (1C271)
- Uruk Captain (2R46)
- Goblin Bowman (2C60)
- Goblin Pursuer (2C62)
- Isengard Servant (3U58)
- Isengard Shaman (3C59)
- Isengard Warrior (3U61)
- Isengard Worker (3C62)
- Uruk Raider (3C74)
- Morgul Slayer (3R93)
- Orc Butcher (3C94)
- Orc Slayer (3U97)
- Orc Swordsman (3C98)
- Orc Warrior (3C101)
- Dunlending Looter (4U11)
- Dunlending Madman (4C12)
- Dunlending Pillager (4U13)
- Dunlending Ravager (4C15)
- Dunlending Robber (4C16)
- Dunlending Warrior (4C18)
- Hillman Band (4C21)
- Hillman Tribe (4C25)
- Wild Man of Dunland (4U38)
- Gríma, Son of Galmod (4C153)
- Mauhúr, Patrol Leader (4R160)
- Uruk Crossbowman (4C183)
- Uruk Foot Soldier (4C187)
- Uruk Plains Runner (4C189)
- Uruk Pursuer (4C190)
- Uruk Runner (4C193)
- Uruk Seeker (4C195)
- Uruk Stalker (4C197)
- Desert Spearman (4C221)
- Desert Warrior (4C222)
- Easterling Axeman (4C224)
- Southron Archer (4R245)
- Southron Bowman (4C248)
- Dunlending Rampager (5U1)
- Dunlending Renegade (5U2)
- Gollum, Stinker (5R25)
- Southron Traveler (5C76)
- Orc Captain (5R103)
- Orc Cutthroat (5U104)
- Orc Fighter (5U105)
- Gollum, Stinker (5M1)
- Dunlending Elder (6C2)
- Gollum, Old Villain (6C40)
- Isengard Journeyman (6C67)
- Isengard Plodder (6C69)
- Isengard Tinker (6C71)
- Rohirrim Traitor (6C72)
- Corpse Lights (6C99)
- Gate Sentry (6C102)
- Gollum, Vile Creature (7C59)
- Desert Runner (7C133)
- Desert Scout (7U134)
- Desert Sneak (7C135)
- Desert Spearman (7C137)
- Southron Thief (7U168)
- Morgul Brute (7R188)
- Morgul Cur (7C189)
- Morgul Destroyer (7U190)
- Morgul Hound (7C192)
- Morgul Lackey (7C193)
- Morgul Mongrel (7C194)
- Morgul Ruffian (7C198)
- Morgul Soldier (7C199)
- Morgul Whelp (7U202)
- Gorgoroth Attacker (7U270)
- Gorgoroth Axeman (7U271)
- Gorgoroth Engineer (7U272)
- Gorgoroth Garrison (7C273)
- Gorgoroth Sapper (7C277)
- Gorgoroth Soldier (7U278)
- Mordor Assassin (7R284)
- Mordor Guard (7C287)
- Mordor Soldier (7C290)
- Mordor Trooper (7C291)
- Mordor Veteran (7U292)
- Mordor Warrior (7U293)
- Orc Brood (7C296)
- Orc Butcher (7C297)
- Orc Chaser (7C298)
- Orc Destroyer (7C299)
- Orc Fanatic (7C300)
- Orc Officer (7U302)
- Orc Pursuer (7C303)
- Orc Rager (7C304)
- Orc Savage (7U305)
- Orc Stalker (7U307)
- Morgul Ambusher (8C74)
- Morgul Creeper (8C75)
- Morgul Lurker (8C76)
- Gorgoroth Agitator (8U94)
- Gorgoroth Breaker (8U97)
- Gorgoroth Looter (8U98)
- Gollum, Dark as Darkness (9R+28)
- Gollum, Mad Thing (10R21)
- Southron Fanatic (10C49)
- Southron Savage (10C50)
- Morgul Banner-bearer (10C62)
- Advance Captain (10R75)
- Advance Marauder (10C76)
- Advance Regular (10C77)
- Cirith Ungol Guard (10C81)
- Mordor Brute (10C90)
- Mordor Fiend (10C91)
- Mordor Pillager (10U92)
- Mordor Wretch (10U93)
- Gollum, Skulker (11R42)
- Archer of Harad (11U67)
- Column of Easterlings (11C72)
- Fearsome Dunlending (11C79)
- Fletcher of Harad (11R81)
- Man of Bree (11S90)
- Patroller of Haradrim (11C93)
- Rampaging Easterling (11C98)
- Squad of Haradrim (11U99)
- Barbarous Orc (11C107)
- Cutthroat Orc (11C113)
- Denizen of Khazad-dûm (11S115)
- Denizen of Moria (11S116)
- Entrapping Orc (11C120)
- Foraging Orc (11C121)
- Marauding Orcs (11S126)
- Mountain Orc (11C129)
- Orkish Worker (11R133)
- Prowling Orc (11C136)
- Bloodthirsty Uruk (11S178)
- Feral Uruk (11S183)
- Furious Uruk (11R186)
- Hounding Uruk (11S188)
- Lookout Uruk (11S193)
- Overpowering Uruk (11U197)
- Ruthless Uruk (11C200)
- Swarming Uruk (11C203)
- Vigilant Uruk (11R205)
- Gollum, Skulker (11RF5)
- Fletcher of Harad (11RF9)
- Crazed Hillman (12C60)
- Crooked Townsman (12C61)
- Easterling Banner-bearer (12U63)
- Harrying Hillman (12R69)
- The Mouth of Sauron, Messenger of Mordor (12S73)
- Wrathful Hillman (12C78)
- Goblin Aggressor (12C87)
- Morgul Tormentor (12U90)
- Orc Dreg (12C92)
- Orc Sapper (12U94)
- Orc Tormentor (12C98)
- Rallying Orc (12R100)
- Vile Goblin (12C106)
- The Mouth of Sauron, Lieutenant of Barad-dur (12R118)
- Advancing Uruk (12C134)
- Barbaric Uruk (12U135)
- Uruk Pikeman (12C153)
- Vicious Uruk (12U158)
- The Mouth of Sauron, Lieutenant of Barad-dur (12RF11)
- Gollum, Her Sneak (13U50)
- Merciless Dunlending (13C96)
- Southron Murderer (13U98)
- Howling Orc (13S109)
- Orc Reaper (13C116)
- Picket Denizen (13S118)
- Underdeeps Denizen (13C119)
- Cavern Denizen (13C160)
- Isengard Infiltrator (13U165)
- Gollum, Hopeless (15R43)
- Bill Ferny, Agent of Saruman (15R72)
- Easterling Scout (15C77)
- Hunting Herdsman (15C83)
- Rapt Hillman (15U90)
- Swarthy Hillman (15C93)
- Wandering Hillman (15U94)
- Battlefield Recruit (15S95)
- Black Land Commander (15C100)
- Black Land Observer (15C101)
- Black Land Spy (15C105)
- Desolation Orc (15C107)
- Isengard Marauder (15C110)
- Moria Menace (15U111)
- Scouting Orc (15C116)
- Charging Uruk (15C156)
- Mauhúr, Relentless Hunter (15S164)
- Searching Uruk (15U168)
- Seeking Uruk (15C169)
- Uruk Infantry (15U175)
- Uruk Village Rager (15U177)
- Candle Corpses (16R2)
- Saruman, Instigator of Insurrection (17R37)
- Sunland Skirmisher (17C57)
- Sunland Trooper (17C59)
- Sunland Warrior (17C60)
- Orkish Assassin (17C72)
- Orkish Cavalry (17R74)
- Orkish Dreg (17C75)
- Orkish Footman (17C78)
- Orkish Lackey (17C80)
- Orkish Rider (17R82)
- Orkish Traveler (17C85)
- White Hand Scout (17C130)
- White Hand Trooper (17C133)
- White Hand Warrior (17C136)
- Harry Goatleaf (18C68)
- Ruffian (18C72)
- Ted Sandyman, Chief's Men's Ally (18U75)
- Orkish Aggressor (18C85)
- Orkish Defender (18C88)
- Wary Orc (18U93)
- White Hand Attacker (18C124)
- White Hand Traveler (18U130)
- White Hand Uruk (18C131)
- Gollum, Threatening Guide (19P10)
- Reaching Tentacle (19P19)
- Strong Tentacle (19P20)
- Morgul Tormentor (0P92)
- The Mouth of Sauron, Messenger of Mordor (0P100)
- Isengard Marauder (0P120)
- Moria Skirmishers (0D21)
- Morgul Patrol (0D24)
- Dunlending Brawler (0W14)
- Morgul Patrol (0W24)
- Saruman, Instigator of Insurrection (0W36)
- Narzug, Orkish Assassin (30S36)
- Orkish Marauder (30S38)
- Goblin Town Archer (30S352)
- Gollum, Small Slimy Creature (31B120)
- Crazy Cob (31S149)
- Assaulting Goblin (32S227)
- Orkish Pursuer (32S242)
- Orkish Veteran (32S243)
- Wicked Spider (32S160)
- Crebain Flock (V1_25)
- Vile Tentacle (V1_36)
- Harry Goatleaf, In Thrall to the Nine (V1_38)
- Orc Ambush Troop (V1_48)