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=TRUE | ||
|order by= | |order by=CR.SiteNum | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul |
Revision as of 04:58, 14 March 2022
- Enheartened Foe (1R247)
- Aragorn, Heir to the Throne of Gondor (18R38)
- Alatar, Final Envoy (13U28)
- Argument Ready to Hand (12U1)
- Aragorn, Strider (11RF7)
- Arod, Rohirrim Steed (13R1)
- A Ranger's Versatility (1U113)
- A Clamour of Many Voices (12U3)
- Anborn, Skilled Huntsman (6C48)
- Why Shouldn't I Keep It? (3R105)
- Asfaloth, Swift Blossom (13R10)
- Better Than Nothing (31B119)
- Battering Ram (5U44)
- A Marvel (10C110)
- Axe-work (17U5)
- Aragorn, Defender of Rohan (17R93)
- Arrow From the South (4U216)
- Banner of Elbereth (6U14)
- Aragorn, Swift Hunter (15S54)
- Aragorn, King in Exile (1P365)
- Barrels (31HA40)
- Battle to the Last (11C4)
- Barren Land (10C79)
- Behold the White Rider (4U88)
- Armor of the White City (18C39)
- Arwen's Bow (18RF1)
- Bilbo, Aged Ring-bearer (13R142)
- Abandoning Reason for Madness (3C49)
- Battle Fury (30S3)
- What Did You Discover? (4R213)
- Beasts of Burden (15C97)
- Azog's Mace (32HF29)
- Assault Ladder (6U58)
- Anger (4C3)
- Athelas (1U94)
- At His Command (8C31)
- Back to the Light (18R6)
- Black Flail (8R70)
- What Are They? (1C119)
- Arwen's Dagger (18R5)
- Bilbo, Melancholy Hobbit (12R119)
- Aragorn, Isildur's Heir (13RF7)
- A Path Appointed (8U42)
- Bilbo, Aged Ring-bearer (0D8)
- Berserker Torch (12U136)
- Betrayal of Isengard (12U25)
- Best Company (4C42)
- Arwen, Elven Rider (3U7)
- Attunement (12C16)
- Beyond All Darkness (8R68)
- An Honorable Charge (4U282)
- Beyond the Height of Men (2R39)
- Blade of the White Hand (17U112)
- A Task Now to Be Done (11U175)
- Alcarin, Warrior of Lamedon (5R31)
- All Blades Perish (1U203)
- An Acorn from Beorn's house (31HA38)
- Alliance Reforged (4R58)
- All Save One (7C31)
- Aragorn, Defender of Rohan (17O4)
- A Shadow Rises (0W30)
- A Light in His Mind (10U108)
- Armory (5U79)
- Balin Avenged (17R2)
- What Are We Waiting For? (2R15)
- Beyond All Hope (4R140)
- Aragorn, Swift Hunter (0P125)
- Ancestral Knowledge (30S1)
- Blade of Gondor, Sword of Boromir (12R42)
- Axe of Erebor (0P40)
- Arwen, Maiden of Rivendell (0W16)
- Arwen, Fair Elf Maiden (0P28)
- Battle Tested (7U3)
- Aragorn, Captain of Gondor (7C81)
- Axe of Erebor (4R41)
- Baruk Khazâd (5R123)
- Bill the Pony, Dearly-loved (13R143)
- Aragorn, Well-traveled Guide (19P12)
- Bitter Hatred (1U164)
- Awkward Moment (13C2)
- Arwen's Bow (18R4)
- Away on the Wind (13U60)
- Bound By Rage (6C1)
- Aragorn, Ranger of the North (0P14)
- Boromir, Doomed Heir (13S62)
- Aragorn, Isildur's Heir (13O6)
- A Wizard Is Never Late (30S23)
- Boromir, Defender of Minas Tirith (12U43)
- Bred for Battle (1C121)
- Battle Cry (11S56)
- Border Defenses (1C32)
- Blades Drawn (4U60)
- Blood Runs Chill (8R3)
- A Blended Race (2U16)
- Aragorn, Strider (11R54)
- Bloodstained Field (12C84)
- Andúril, King's Blade (7R80)
- Boromir's Cloak (1U98)
- Belt of Erebor (12U2)
- A Defiled Charge (17R67)
- Bladed Gauntlets (11U109)
- Aragorn, Heir of Elendil (4C109)
- Aragorn, Defender of Rohan (17RF12)
- Baruk Khazâd (5R5)
- Breeding Pit (1C122)
- Burglar's Contract (31HA41)
- A Grey Ship (8U9)
- Brilliant Light (15C121)
- Bold Men and Grim (7R129)
- Abiding Evil (12R81)
- Arrows Thick in the Air (4U110)
- Between Nazgûl and Prey (8R67)
- Attack on Helm's Deep (4C137)
- Arwen, Royal Maiden (19P6)
- Aragorn, Defender of Rohan (0P127)
- Alatar Deceived (13R78)
- Arwen, Lady Undomiel (3R8)
- Boromir's Gauntlets (4C112)
- Black Shapes Crawling (5U48)
- Aragorn, Guide and Protector (11S53)
- Beorning Axe (18RF4)
- Army Long Trained (19P5)
- Blood Has Been Spilled (6U91)
- Aragorn’s Bow (0P41)
- A Wizard Is Never Late (1R87)
- Aragorn, Defender of Free Peoples (6R50)
- Arwen, Staunch Defender (0P79)
- Axe of Khazad-dûm (11U3)
- Beorn, Skin-Changer (31HH13)
- Broad-bladed Sword (4C142)
- Balglin, Elven Warrior (5U10)
- A Fool (8C14)
- Brutality (11S180)
- Aragorn, Thorongil (15RF9)
- Armor of Khazâd (17U1)
- All Life Flees (18U132)
- Aragorn, Captain of Gondor (0P23)
- Black Steed (1R208)
- Aiglos (9R+12)
- Cave Troll's Hammer (1R166)
- Balin, Brother of Dwalin (30S2)
- Bloodthirsty (11RF8)
- Can You Protect Me From Yourself? (3R50)
- Bifur, Inarticulate (30S5)
- Cave Troll's Chain (2R53)
- Bold and Cunning (11C71)
- Betrayal of Isengard (3R29)
- Armor (1C92)
- Aragorn’s Bow (1R90)
- Brought Back Alive (4U143)
- Chaotic Clash (17C68)
- Cast Out (12R108)
- Aragorn, Wingfoot (4P364)
- Burning of Westfold (4R144)
- Birchseed, Tall Statesman (5U15)
- Black Dart (8U69)
- Arwen, Staunch Defender (11U15)
- Andúril, Sword That Was Broken (17R27)
- A Dark Shape Sprang (10R19)
- Asfaloth (1U31)
- Boromir, Destined Guide (19P13)
- Called Away (8R93)
- Above the Battlement (7C262)
- Chamber of Records (15U3)
- Aldred, Eored Soldier (12C107)
- Citadel of Minas Tirith (3R40)
- Celeborn, The Wise (13O1)
- Challenging the Orc-host (12C109)
- Birthday Present (10R104)
- Brave and Loyal (10U105)
- Captured by the Ring (7C53)
- Book of Mazarbul (3R1)
- Book of Mazarbul (0P7)
- Arwen, Maiden of Rivendell (0P63)
- Arwen, Reflection of Luthien (13S9)
- Beorning Axe (18O1)
- Banner of the Eye (6C98)
- Brego (4U263)
- Beast of War (17U40)
- Ancient Blade (7U15)
- Ancient Roads (6R49)
- Bombur, Chief Cook (30S7)
- Aegnor, Elven Escort (10U4)
- Bilbo, Expert Burglar (30S43)
- Ancestral Feuds (31HD29)
- Arwen, Echo of Luthien (10U5)
- Arwen, Evenstar of Her People (6U13)
- Catapult (8R32)
- City of Men (7C83)
- Bow of Minas Tirith (11U58)
- Boromir, Lord of Gondor (1R96)
- Boromir, Bearer of Council (9R+31)
- An Able Guide (1R88)
- Change of Plans (1R99)
- Arrow-slits (5U80)
- Caravan From the South (13C83)
- Bilbo, Collector of Treasures (30S44)
- Bow of the Galadhrim (1R33)
- Boomed and Trumpeted (6U24)
- Constantly Threatening (4R6)
- Banner of Isengard (6C59)
- A Promise (12R128)
- Banished (4R139)
- Corsair Halberd (18U63)
- Break the Charge (5R124)
- Aragorn’s Bow, Ranger's Longbow (15R56)
- Charged Headlong (8U85)
- City Wall (5C33)
- Company of Archers (4R61)
- Corsair Boarding Axe (18U60)
- Concerning Hobbits (11S161)
- Celeborn, The Wise (13RF1)
- Ceorl, Weary Horseman (4U264)
- Battle Fury (1C4)
- Arwen, Queen of Elves and Men (10R6)
- Aragorn, Defender of Free Peoples (0P47)
- Battle in Earnest (8R2)
- Arwen's Dagger (18RF2)
- Covering Fire (4U147)
- Concealment (12C44)
- Cry and Panic (17C69)
- Be Gone! (15U27)
- Aragorn, Elessar Telcontar (10R25)
- Black Breath (1U207)
- A Host Avails Little (1U251)
- Corsair Grappling Hook (18U62)
- Damrod, Dunadan of Gondor (15U57)
- Cleaving Blow (1C5)
- Andúril, Flame of the West (7R79)
- Arwen, Daughter of Elrond (1R30)
- Banner of Westernesse (6U51)
- Dark Whispers (1R210)
- Crashing Cavalry (13C13)
- Dark Places (2C55)
- Aragorn, Isildur's Heir (13R59)
- Boromir, Steward's Heir (0W19)
- Brego, Loyal Steed (13R63)
- Celeborn, The Wise (13R11)
- A Shadow Fell Over Them (15R182)
- Break the Charge (5R11)
- Aragorn, Driven by Need (7P364)
- Bofur, Encouraging Fellow (30S6)
- Cliffs of Emyn Muil (4R299)
- Boromir, Steward's Heir (0P65)
- A Dragon's Tale (18C106)
- Connected By Fate (15R40)
- Bilbo's Pipe (1U285)
- Boromir, Hero of Osgiliath (11R57)
- A Fell Voice on the Air (3R52)
- Cloud of Arrows (4C145)
- Cleaved (18R114)
- Bilbo, Melancholy Hobbit (12RF12)
- Citadel of the Stars (5C32)
- Called to Mordor (15U39)
- Chance Observation (10C106)
- Dagger Strike (7C84)
- An Invisible Ring (31HA39)
- Bitter Tidings (13U122)
- Denethor, Last Ruling Steward (13R64)
- Aragorn, Thorongil (15R55)
- Blade of Lindon (11U16)
- Dark Ways (7R5)
- Defenses Long Held (18C44)
- Denethor, Wizened Steward (7C86)
- Boromir, Hero of Osgiliath (0P71)
- Defending the Keep (5C6)
- Black Arrow (32HC16)
- Ceremonial Armor (17R41)
- Called (7U174)
- Borne Far Away (10R14)
- Death They Cried (7R223)
- Axe Strike (1C3)
- Demands of the Sackville-Bagginses (2C40)
- What Is This New Devilry? (1U202)
- Bill the Pony (0P2)
- Dead Man of Dunharrow (10C27)
- Community Living (15C143)
- Conquered Halls (11S112)
- Banner of the Mark (6U90)
- A Promise (2R112)
- Caught In A Sack (31HA57)
- Dark Swooping Shadows (10R58)
- Border Patrol (11U144)
- Besieging Pike (7C265)
- Black Marshal (10U53)
- Breached (7R266)
- Coordinated Effort (15U106)
- Destroyers and Usurpers (18U78)
- Cirion (7C82)
- Agility (6C12)
- Blade Tip (1U209)
- Decorated Barricade (15R58)
- Cast It Into the Fire! (3C11)
- Where Has Gríma Stowed It? (4R214)
- Devilry of Orthanc (5R49)
- Arwen, Fair Elf Maiden (7R16)
- Arwen, She-Elf (15R11)
- Armor of the Citadel (11U55)
- Closer and Closer He Bent (8C109)
- Déagol, Fateful Finder (13RF6)
- Careful Study (7U19)
- Alive and Unspoiled (1R120)
- Anger (30S32)
- Aragorn’s Pipe (1U91)
- Celebring, Elven-smith (18R7)
- Dark Fell About Him (13R178)
- Answering the Cries (3C37)
- Down From the Hills (5R16)
- Discoveries (12R26)
- Dori, Really a Decent Fellow (30S8)
- Arwen's Fate (1R93)
- Dark Fury (4C7)
- Driven From the Plains (13C87)
- Derufin (7R87)
- Countless Companies (12U58)
- Boromir, Son of Denethor (1U97)
- Blade of Gondor (1R95)
- Drawn to Full Height (18C19)
- Courtesy of My Hall (4C44)
- Dark Fire (2U54)
- Burial Mounds (15R122)
- Duality (13C47)
- Beren and Lúthien (3U9)
- Dark Approach (12O5)
- Defiled (13U105)
- Don’t Look at Them (6R125)
- Brace of Coneys (4C298)
- Denizens Enraged (1R167)
- Always Threatening (13U103)
- Bound to its Fate (11U110)
- Broken Heirloom (12U138)
- Defiance (1C37)
- Dasron, Merchant from Dorwinion (13C29)
- Denethor, Last Ruling Steward (13RF8)
- Dervorin (7U88)
- Dain Ironfoot, King Under the Mountain (14R1)
- Dear Friends (2U98)
- Down to the Last Child (4U148)
- Denethor, Last Ruling Steward (13O7)
- Ancient Roads (6R126)
- Desperate Move (15R42)
- Curse From Mordor (1U241)
- Come Away (12R37)
- Broken in Defeat (12R139)
- Bloodthirsty (11R70)
- Delving (1C6)
- Calculated Risk (7C4)
- Beyond Dark Mountains (4C141)
- Dwarven Skill (12C6)
- Dwarven Song (31HE2)
- Aragorn, Ranger of the North (1R89)
- Come Here Lad (4U43)
- Beauty Is Fading (1R205)
- Arrow and Blade (4U59)
- Aragorn, The Dunadan (0W6)
- Controlled By The Ring (15U41)
- Duty of Two (7C89)
- Citadel to Gate (7R33)
- Drawn to its Power (11S209)
- Crown of Gondor (18O3)
- Denethor, Lord of Minas Tirith (10R28)
- Desperate Defense of the Ring (1R244)
- Dangerous Gamble (3C76)
- Bilbo, Reliable Companion (30S46)
- Crouched Down (11C162)
- Bow of Minas Tirith (0P72)
- Damrod, Ranger of Ithilien (4U114)
- Crack Into Rubble (6U25)
- Dragon-Sickness (32HI51)
- Counts But One (8U4)
- Deft in Their Movements (2C99)
- Dawn Take You All! (30S24)
- Dínendal, Mirkwood Archer (15R12)
- Elf-song (1C39)
- Armed for Battle (11U106)
- Denethor's Sword (18R43)
- Dread and Despair (11U118)
- Dwalin, Brother of Balin (30S9)
- Disposable Servants (7U176)
- Defensive Rush (15U159)
- Dúnadan's Bow (18U45)
- Banners Blowing (13U61)
- Dark Temptation (12R163)
- Dark Alliance (12R141)
- Duilin, Ranger from Blackroot Vale (14R7)
- Deep in Thought (3C30)
- Beaten Back (10C80)
- Du Bekâr! (32HF3)
- Boromir, My Brother (4R111)
- Ease the Burden (11U29)
- All Thought Bent on It (1U239)
- Elrond, Elven Lord (7R21)
- Days Growing Dark (7U55)
- Dead Marshes (5R95)
- Cursed of Erech (10U26)
- Dark Powers Strengthen (11R207)
- Don’t Let Go (13C145)
- Elessar's Edict (8R33)
- Bent on Discovery (1R206)
- Driven Back (4R149)