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=CR.GameText LIKE '% | |where=CR.GameText LIKE '%to prevent%' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 21:58, 7 December 2022
- Gimli's Helm (1R15)
- Intimidate (1C76)
- Uruk Guard (1R147)
- Goblin Armory (1R173)
- Bounder (1C286)
- Shores of Nen Hithoel (1U359)
- Dwarven Bracers (2U3)
- Tidings of Erebor (2U13)
- Dismay Our Enemies (2U17)
- Hosts of the Last Alliance (2U18)
- Wielder of the Flame (2U28)
- You Cannot Pass! (2U30)
- Flee in Terror (2U33)
- Gondor Will See It Done (2U34)
- His Terrible Servants (2R77)
- Hobbit Sword-play (2U103)
- Nice Imitation (2U106)
- Arwen, Elven Rider (3U7)
- Erestor, Chief Advisor to Elrond (3C14)
- Depart Silently (3C31)
- Unknown Perils (3C36)
- Can You Protect Me From Yourself? (3R50)
- Isengard Shaman (3C59)
- Saruman, Keeper of Isengard (3R68)
- Saruman, Servant of the Eye (3C69)
- Such a Little Thing (3R80)
- Too Great and Terrible (3R85)
- Terrible as the Dawn (3R103)
- Why Shouldn't I Keep It? (3R105)
- Melilot Brandybuck, Merry Dancer (3R110)
- Three Monstrous Trolls (3C114)
- Arwen, Elven Rider (3M1)
- Hides (4R19)
- From the Armory (4U47)
- Keep Your Forked Tongue (4U96)
- Long I Fell (4C97)
- Boromir's Gauntlets (4C112)
- Brought Back Alive (4U143)
- Many Riddles (4U159)
- Mauhúr, Patrol Leader (4R160)
- Orthanc Champion (4R164)
- New Fear (4R240)
- Southron Commander (4U249)
- Southron Troop (4R256)
- Southron Wanderer (4C258)
- Vision From Afar (4R259)
- Ceorl, Weary Horseman (4U264)
- Éowyn, Lady of Rohan (4C270)
- Éowyn, Sister-daughter of Theoden (4R271)
- Escape (4R300)
- Merry, Learned Guide (4C310)
- Pippin, Woolly-footed Rascal (4C314)
- Sam, Samwise the Brave (4C316)
- Eastfold (4U331)
- Leaping Blaze (5R3)
- Turn of the Tide (5U20)
- Be Back Soon (5R21)
- Siege Engine (5U60)
- Southron Traveler (5C76)
- Rohirrim Helm (5R89)
- Grishnákh, Orc Captain (5R100)
- Nan Curunír (5U119)
- Rohirrim Helm (5R127)
- Bound By Rage (6C1)
- Dunlending Headman (6C4)
- Skinbark, Fladrif (6R35)
- Berserk Butcher (6R60)
- Scaffolding (6U73)
- Trample (6R82)
- Blood Has Been Spilled (6U91)
- Kept Safe (6C111)
- Saruman’s Laboratory (6U120)
- Skinbark, Fladrif (AI) (6R124)
- Gimli, Feared Axeman (7R7)
- Gimli's Armor (7U8)
- Gandalf, Manager of Wizards (7R37)
- Intimidate (7C41)
- Scouting (7R68)
- Sweeter Meats (7C75)
- Faramir, Wizard's Pupil (7R91)
- Strong and Old (7R122)
- Southron Bandit (7U160)
- Surging Up (7R169)
- Morgul Brute (7R188)
- Morgul Destroyer (7U190)
- Firefoot, Eomer's Steed (7R232)
- Herugrim, Sword of the Mark (7R236)
- Riding Armor (7U245)
- Snowmane (7R250)
- Gorgoroth Soldier (7U278)
- King of the Dead, Oathbreaker (8R38)
- Winged Mount (8U83)
- Song of the Shire (8U112)
- Merry’s Dagger (9R18)
- Pippin’s Dagger (9R21)
- Huorn (9R25)
- Narsil, Blade of the Faithful (9R+34)
- Sapling of the White Tree (9R35)
- Reclaim the Precious (10U22)
- Mordor Pillager (10U92)
- Ruinous Hail (10U98)
- Grimir, Dwarven Emissary (11R10)
- Shadowfax, Unequaled Steed (11U40)
- Easterling Shield Wall (11C76)
- Beastly Olog-hai (11R108)
- Dread and Despair (11U118)
- Hrothlac, Man of Rohan (11C148)
- Rush of Steeds (11C157)
- Salt from the Shire (11R171)
- Fortitude (11U185)
- Sentinel Uruk (11C201)
- Shapes Slowly Advancing (11R217)
- Salt from the Shire (11RF14)
- Dwarven Bracers (12U5)
- Salve (12C32)
- Messenger’s Mount (12R72)
- Orc Sapper (12U94)
- Coif (12R111)
- Golden Glimmer (12C115)
- Tolman Cotton, Farmer of Bywater (12S133)
- Dark Alliance (12R141)
- Uruk-hai Guard (12R156)
- Shores of Nen Hithoel (12U191)
- Arod, Rohirrim Steed (13R1)
- Away on the Wind (13U60)
- Stewards’ Legacy (13U75)
- Picket Denizen (13S118)
- Bitter Tidings (13U122)
- Desperate Move (15R42)
- Release Them (15C48)
- Swear by the Precious (15U52)
- Rapt Hillman (15U90)
- Tower Troll (15R117)
- Unreasonable Choice (15R119)
- Éowyn, Willing Fighter (15C125)
- Hobbiton Brewer, Maker of Fine Ales (15R146)
- Relaxation (15R152)
- They Feel The Precious (15U183)
- Armor of Khazâd (17U1)
- Glamdring, Orc Beater (17R18)
- Saruman, Instigator of Insurrection (17R37)
- Ceremonial Armor (17R41)
- Throne of the Golden Hall (17R98)
- Southlinch Leaf (17U111)
- Glamdring, Orc Beater (17RF2)
- Throne of the Golden Hall (17RF13)
- Throne of the Golden Hall (17O5)
- Perspective (18U25)
- Deceit (18R29)
- Erkenbrand's Shield (18R97)
- Scouring of the Shire (18R112)
- Lurtz, Halfling Hunter (18R118)
- White Hand Mystic (18C128)
- Erkenbrand's Shield (18RF12)
- Erkenbrand's Shield (18O7)
- Gríma, Servant of Another Master (19P16)
- Pit Troll (19P22)
- Lurtz, Resilient Captain (19P33)
- Saruman, Servant of the Eye (0P11)
- Éowyn, Lady of Rohan (0P17)
- Gimli's Helm (0P34)
- Éowyn, Sister-daughter of Theoden (0P39)
- Lurtz, Halfling Hunter (0W35)
- Saruman, Instigator of Insurrection (0W36)
- Bofur, Encouraging Fellow (30S6)
- Fili, Brother of Kili (30P10)
- Fili, Brother of Kili (30S10)
- Goblin Town Archer (30S352)
- Oakenshield (31HE6)
- Riddles in the Dark (31HA22)
- Great Goblin's Power (31S135)
- Beorn's House (31HH44)
- Forest River (31HD46)
- Percy, Bard's Lieutenant (32HC19)
- Narya (32HG23)
- Assaulting Goblin (32S227)
- Dark Bats (32HB30)
- Jail (32HG39)
- Orkish Bow (32S241)
- Sauron, The Necromancer (32B245)
- My Heart Tells Me (V1_16)
- Guided by One Purpose (V1_31)
- Out of Dark Waters (V1_34)
- Ringwraith in Twilight (V1_40)
- Fell to Its Power (V1_44)
- Gaze of the Eye (V1_45)
- Merry, Of Buckland (V1_52)
- Pippin, Of Tuckborough (V1_53)