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 = ' | |where=C.CardType = 'Possession' AND C.Side = 'Free Peoples' | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 16:45, 6 June 2023
- Dwarven Armor (1C8)
- Dwarven Axe (1C9)
- Gimli's Battle Axe (1R14)
- Gimli's Helm (1R15)
- Asfaloth (1U31)
- Bow of the Galadhrim (1R33)
- Elven Bow (1C41)
- Elven Cloak (1C42)
- Gwemegil (1R47)
- The Mirror of Galadriel (1R55)
- Gandalf's Cart (1U73)
- Gandalf’s Pipe (1U74)
- Glamdring (1R75)
- Aragorn’s Bow (1R90)
- Aragorn’s Pipe (1U91)
- Armor (1C92)
- Athelas (1U94)
- Blade of Gondor (1R95)
- Boromir's Cloak (1U98)
- Coat of Mail (1C101)
- Great Shield (1C107)
- Ranger’s Sword (1U112)
- Bilbo's Pipe (1U285)
- The Gaffer's Pipe (1U292)
- Hobbit Sword (1C299)
- Longbottom Leaf (1C300)
- Old Toby (1C305)
- Sting (1R313)
- Thrór's Map (1R318)
- Dwarven Bracers (2U3)
- Hand Axe (2C10)
- Wizard Staff (2C29)
- Flaming Brand (2R32)
- Shield of Boromir (2R38)
- Red Book of Westmarch (2R113)
- Book of Mazarbul (3R1)
- Gimli's Pipe (3U2)
- Long-knives of Legolas (3R21)
- Phial of Galadriel (3U24)
- Horn of Boromir (3R42)
- Bill the Pony (3U106)
- Frodo's Pipe (3U107)
- Frying Pan (3C108)
- Axe of Erebor (4R41)
- Elven Bow (4U62)
- Elven Brooch (4U63)
- Elven Sword (4C64)
- Lembas (4R75)
- Shadowfax (4R100)
- Boromir's Gauntlets (4C112)
- Faramir's Bow (4R118)
- Faramir's Cloak (4R119)
- Ranger's Bow (4C131)
- Ranger's Sword, Blade of Aragorn (4U132)
- Sword of Gondor (4C134)
- Brego (4U263)
- Éomer's Spear (4U268)
- Éowyn's Sword (4R272)
- Firefoot (4R274)
- Heavy Chain (4C278)
- Herugrim (4U280)
- Horse of Rohan (4C283)
- King's Mail (4R284)
- Rider's Mount (4C287)
- Rider's Spear (4C288)
- Sword of Rohan (4C291)
- Brace of Coneys (4C298)
- Frodo's Cloak (4R303)
- Hobbit Sword (4C306)
- Sam's Pack (4R317)
- Horn of Helm (5U8)
- Legolas' Sword (5U12)
- Rohirrim Bow (5C88)
- Rohirrim Helm (5R89)
- Rohirrim Shield (5C91)
- Sting, Baggins Heirloom (5R116)
- Rohirrim Helm (5R127)
- Banner of Elbereth (6U14)
- Naith Longbow (6C21)
- Glamdring, Lightning Brand (6R31)
- Banner of Westernesse (6U51)
- Banner of the Mark (6U90)
- Gimli's Armor (7U8)
- Gimli's Battle Axe, Trusted Weapon (7R9)
- Asfaloth, Elven Steed (7R17)
- Bow of the Galadhrim, Gift of Galadriel (7R18)
- Glamdring, Elven Blade (7R39)
- Wizard Staff (7C52)
- Footman's Armor (7U93)
- Gondor Bow (7U94)
- Gondorian Sword (7U98)
- Knight's Spear (7C108)
- Pippin's Armor (7R113)
- Pippin's Sword (7R114)
- Éowyn's Sword, Dernhelm's Blade (7R230)
- Firefoot, Eomer's Steed (7R232)
- Herugrim, Sword of the Mark (7R236)
- Long Spear (7C240)
- Merry's Armor (7R241)
- Merry's Sword (7R242)
- Riding Armor (7U245)
- Rohirrim Javelin (7C248)
- Snowmane (7R250)
- Swift Steed (7C253)
- Windfola (7R260)
- Hobbit Sword (7C319)
- Shadowfax, Greatheart (8R21)
- Catapult (8R32)
- Knight's Mount (8C40)
- Spectral Sword (8U46)
- Éowyn's Shield (8R88)
- Sting, Bane of the Eight Legs (8R113)
- Elven Rope (9R13)
- Knife of the Galadhrim (9R+17)
- Merry’s Dagger (9R18)
- Pippin’s Dagger (9R21)
- Strands of Elven Hair (9R22)
- Horn of the Mark (9R45)
- Orc Armor (10C113)
- Axe of Khazad-dûm (11U3)
- Gimli's Battle Axe, Vicious Weapon (11R9)
- Blade of Lindon (11U16)
- Legolas' Bow (11R23)
- The Art of Gandalf (11U28)
- Glamdring, Foe-hammer (11R35)
- Shadowfax, Unequaled Steed (11U40)
- Armor of the Citadel (11U55)
- Bow of Minas Tirith (11U58)
- Gondorian Blade (11U59)
- Riddermark Javelin (11U151)
- Rider's Spear (11S153)
- Rohirrim Mount (11U156)
- Hobbit Sword (11S166)
- Salt from the Shire (11R171)
- Sting, Weapon of Heritage (11R173)
- Glamdring, Foe-hammer (11RF4)
- Salt from the Shire (11RF14)
- Belt of Erebor (12U2)
- Dwarven Bracers (12U5)
- Hadafang (12R18)
- Long-knives of Legolas (12R19)
- Gandalf’s Hat (12R28)
- Blade of Gondor, Sword of Boromir (12R42)
- Faramir's Sword (12R48)
- Gondorian Steed (12U49)
- Coif (12R111)
- Hadafang (12RF2)
- Faramir's Sword (12RF5)
- Faramir's Sword (12O3)
- Arod, Rohirrim Steed (13R1)
- Asfaloth, Swift Blossom (13R10)
- Shadowfax, Roaring Wind (13R40)
- Fishing Boat (13R48)
- Brego, Loyal Steed (13R63)
- Kingsfoil (13C73)
- Firefoot, Mearas of the Mark (13R126)
- Rider’s Bow (13U135)
- Snowmane, Noble Mearas (13R136)
- Bill the Pony, Dearly-loved (13R143)
- Heavy Axe (15U7)
- Well-crafted Armor (15R9)
- Elven Bow (15C13)
- Sword of the Fallen (15C25)
- Aragorn’s Bow, Ranger's Longbow (15R56)
- Ithilien Blade (15C62)
- Ranger’s Cloak (15C68)
- Éomer’s Spear, Trusty Weapon (15R124)
- Horse of Great Stature (15U129)
- Rider’s Mount (15C133)
- Rohirrim Axe (15C136)
- Spear of the Mark (15U140)
- Sturdy Shield (15R141)
- Hobbit Sword (15C145)
- Well-crafted Armor (15RF2)
- Armor of Khazâd (17U1)
- Glamdring, Orc Beater (17R18)
- Shadowfax, Greatest of the Mearas (17R24)
- Faramir's Bow, Ithilien Longbow (17R29)
- Glamdring, Orc Beater (17RF2)
- Shadowfax, Greatest of the Mearas (17RF3)
- Shadowfax, Greatest of the Mearas (17O1)
- Arwen's Bow (18R4)
- Arwen's Dagger (18R5)
- Elven Armaments (18U8)
- Lembas Bread (18R15)
- Beorning Axe (18R18)
- Radagast's Herb Bag (18R26)
- Armor of the White City (18C39)
- Denethor's Sword (18R43)
- Dúnadan's Bow (18U45)
- Horn of Boromir, The Great Horn (18R53)
- Shield of the White Tree (18C57)
- Éomer's Bow (18R95)
- Erkenbrand's Horn (18R96)
- Erkenbrand's Shield (18R97)
- Gamling's Horn (18R100)
- Golden Perch Ale (18U108)
- Sting, Elven Long Knife (18R113)
- Arwen's Bow (18RF1)
- Arwen's Dagger (18RF2)
- Beorning Axe (18RF4)
- Radagast's Herb Bag (18RF5)
- Denethor's Sword (18RF8)
- Erkenbrand's Horn (18RF11)
- Erkenbrand's Shield (18RF12)
- Sting, Elven Long Knife (18RF16)
- Beorning Axe (18O1)
- Radagast's Herb Bag (18O2)
- Denethor's Sword (18O4)
- Erkenbrand's Horn (18O6)
- Erkenbrand's Shield (18O7)
- Bill the Pony (0P2)
- Horn of Boromir (0P5)
- Book of Mazarbul (0P7)
- Phial of Galadriel (0P9)
- Firefoot (0P33)
- Gimli's Helm (0P34)
- Axe of Erebor (0P40)
- Aragorn’s Bow (0P41)
- Glamdring, Lightning Brand (0P44)
- Tom Bombadil's Hat (0P60)
- Bow of Minas Tirith (0P72)
- Sting, Weapon of Heritage (0P84)
- Goblet of the White City (0SPD1)
- Green Dragon Mug (0SPD2)
- Rohirrim Stein (0SPD3)
- Dwarven Axe (31HE1)
- Great Barricade (31HE4)
- Oakenshield (31HE6)
- An Acorn from Beorn's house (31HA38)
- Burglar's Contract (31HA41)
- Dwarven Spear (32HB4)
- Thrór's Key (32HF11)
- Thrór's Map (32HF12)
- Black Arrow (32HC16)
- Iron-Forged Weapon (32HC18)