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= | |where=C.CardType = 'Site' | ||
|order by= | |order by=CR.SiteNum | ||
|limit=400 | |limit=400 | ||
|format=ul | |format=ul |
Revision as of 11:21, 20 February 2022
- Breeding pit of Isengard (0D9)
- Caras Galadhon (0D2)
- Buckland Homestead (11S230)
- City Gates (15S189)
- Caras Galadhon (11S231)
- Barazinbar (11S229)
- Anduin Confluence (11S228)
- City of Kings (13U187)
- Crags of Emyn Muil (11S234)
- City of Kings (0D10)
- Anduin River (15U187)
- Chamber of Mazarbul (11S233)
- Cavern Entrance (0D3)
- Dol Guldur (17U145)
- Dammed Gate-stream (11U235)
- Abandoned Mine Shaft (13U185)
- Buckland Homestead (0D1)
- East Road (11S236)
- Crossroads of the Fallen Kings (13S189)
- East Wall of Rohan (15S190)
- Emyn Muil (12S187)
- Fangorn Glade (11S239)
- Ettenmoors (11S237)
- Caves of Aglarond (13S186)
- Breeding pit of Isengard (15S188)
- Doors of Durin (13U190)
- Falls of Rauros (0D13)
- Falls of Rauros (17U146)
- Expanding Marshland (11S238)
- Foot of Mount Doom (18U135)
- Gate of Mordor (15S191)
- Fords of Isen (13S191)
- Harrowdale (11S243)
- Green Dragon Inn (11S242)
- Helm's Gate (11S245)
- Flats of Rohan (11S240)
- Isenwash (13U193)
- Heights of Isengard (11U244)
- Hobbiton Market (12S189)
- Isengard Ruined (15U192)
- Mere of Dead Faces (11U246)
- Imladris (17U147)
- Hill of Sight (12S188)
- Morannon Plains (18U137)
- Mount Doom (15R193)
- Neekerbreekers’ Bog (0D4)
- Fortress of Orthanc (11S241)
- Moria Stairway (11S248)
- Moria Guardroom (11S247)
- Old Forest Road (11S251)
- Mount Doom (15RF18)
- North Undeep (11S250)
- Osgiliath Reclaimed (11S252)
- Pelennor Flat (11S254)
- Pinnacle of Zirakzigil (11S255)
- Pinnacle of Zirakzigil (0D11)
- Rohan Uplands (11S257)
- Nurn (17U148)
- Sirannon Ruins (18U138)
- Pelennor Fields (11S253)
- Slag Mounds (11S258)
- Stables (11S259)
- Redhorn Pass (13U194)
- Shores of Nen Hithoel (12U191)
- Slopes of Orodruin (12U192)
- Starkhorn (12U193)
- The Prancing Pony (0D12)
- Northern Pelennor (12S190)
- The Great Gates (13S192)
- The Bridge of Khazad-dûm (12U186)
- The Angle (12U185)
- The Prancing Pony (11S256)
- Watch-tower of Cirith Ungol (11S262)
- Trollshaw Forest (11S260)
- Window on the West (11S265)
- Woody-End (11S266)
- Valley of the Silverlode (11S261)
- West Gate of Moria (11S263)
- Westfold Village (15S194)
- Streets of Bree (18U140)
- Wold Battlefield (12U194)
- Westemnet Village (11S264)
- Imladris (0D14)
- Anduin Banks (11U227)
- Cavern Entrance (11S232)
- Neekerbreekers’ Bog (11S249)
- Courtyard Parapet (13U188)
- Doorway to Doom (18U134)
- Mithlond (18U136)
- Steward's Tomb (18U139)
- Rath Dínen (V0_1)
- Bilbo's Kitchen (30FP58)
- Bag End (30S49)
- Bag End (1U319)
- Dunharrow Plateau (7U329)
- Eastemnet Downs (4U324)
- East Wall of Rohan (4U323)
- Edoras Hall (7U330)
- Farmer Maggot’s Fields (1U321)
- Hobbiton Party Field (2U115)
- Horse-country (4U326)
- East Road (1U320)
- Eastemnet Gullies (4U325)
- Green Dragon Inn (1U322)
- Isengard Ruined (7U331)
- Green Hill Country (1U323)
- Hobbiton Woods (2U116)
- Rocks of Emyn Muil (6U115)
- Plains of Rohan (4U327)
- Sleeping Quarters (7U333)
- Shire Lookout Point (1U325)
- Steps of Edoras (7U334)
- The Riddermark (4U328)
- The Prancing Pony (0P1)
- Town Center (2C117)
- The Prancing Pony (1U324)
- Western Emyn Muil (4U329)
- Westfarthing (1C326)
- Westfold (6U116)
- Bag End Study (V1_57)
- Rohirrim Road (7U332)
- Bree Gate (1U327)
- Bucklebury Ferry (1U330)
- Bree Streets (1U328)
- Breeland Forest (1U329)
- Derndingle (4U330)
- Ettenmoors (1C331)
- Eastfold (4U331)
- Fangorn Forest (4U332)
- King's Tent (7U335)
- Midgewater Marshes (1U332)
- Plains of Rohan Camp (4U333)
- Rohirrim Village (4U334)
- Rohirrim Camp (7U336)
- Trollshaw Forest (30FP59)
- West Road (7U337)
- Wold of Rohan (4U336)
- Uruk Camp (4U335)
- Weathertop (1U336)
- Weatherhills (1U335)
- The Troll Hoard (30S50)
- Trollshaw Forest (1U334)
- Prancing Pony Spare Room (V1_58)
- Midgewater Moors (1U333)
- Beacon of Minas Tirith (7U338)
- Council Courtyard (0P4)
- Council Courtyard (1C337)
- Base of Mindolluin (10U117)
- Barrows of Edoras (4U337)
- Frodo's Bedroom (1U339)
- Ford of Bruinen (1U338)
- Golden Hall (4U338)
- House of Elrond (3U119)
- Hall of the Kings (7U339)
- Meduseld (6U117)
- Rivendell Waterfall (1U342)
- Rivendell Valley (1U341)
- Rivendell Terrace (1U340)
- Rhudaur (30FP60)
- Stables (4U339)
- Streets of Edoras (4U340)
- Tower of Ecthelion (7U340)
- Throne Room (4U341)
- Westemnet Plains (4U342)
- The Dimholt (8U117)
- Rivendell Gateway (V1_59)
- Balin's Tomb (1U343)
- Anduin Banks (7U341)
- Beorn's House (31HH44)
- City of the Dead (8U118)
- Dwarrowdelf Chamber (1U344)
- Eregion Hills (3U116)
- Balin's Tomb (0P6)
- Ered Nimrais (4U343)
- Great Chasm (2U118)
- Hollin (2C119)
- Goblin Town (31S34)
- Moria Lake (1C346)
- Moria Stairway (1U347)
- Osgiliath Fallen (7U342)
- Pass of Caradhras (1U348)
- Pelennor Prairie (10U118)
- Mithril Mine (1U345)
- Pelennor Plain (7U343)
- White Mountains (4U345)
- Westemnet Hills (4U344)
- White Rocks (4U346)
- Wooded Steep Cliff (32FP64)
- Underground Lake (31HA55)
- Moria Crossroads (V1_60)
- City Gates (7U344)
- Dol Guldur (32HG56)
- Crashed Gate (8U119)
- Forest River (31HD46)
- Deep of Helm (4U347)
- Deeping Wall (4U348)
- Hornburg Courtyard (4U350)
- Hornburg Parapet (4U351)
- Mirkwood (30S53)
- Helm's Gate (4U349)
- Old Forest Road (30FP62)
- Pelennor Flat (7U345)
- Steward's Tomb (10U119)
- The Bridge of Khazad-dûm (1C349)
- Caras Galadhon (3U115)
- Esgaroth (32S17)
- Dimrill Dale (1U350)
- Galadriel's Glade (1C351)
- Galadriel's Glade (0P8)
- Great Hall (4U353)
- Lake Town (30FP63)
- Minas Tirith Fifth Circle (7U346)
- Hornburg Hall (6U118)
- Minas Tirith Third Circle (7U352)
- Minas Tirith Sixth Circle (7U351)
- Lothlórien Woods (1U352)
- Minas Tirith First Circle (7U347)
- Minas Tirith Second Circle (7U349)
- Minas Tirith Fourth Circle (7U348)
- Hornburg Armory (4U354)
- Minas Tirith Seventh Circle (7U350)
- Valley of the Silverlode (2U120)
- Town Hall (32HC47)
- Lorien Throne Room (V1_61)
- Caves of Aglarond (4U352)
- Anduin Confluence (1U353)
- Anduin Wilderland (1C354)
- Cavern Entrance (4U355)
- Dale (30FP64)
- Erebor (30S55)
- Hornburg Causeway (4U356)
- King's Room (4U357)
- Hornburg Wall (5U118)
- Osgiliath Crossing (7U353)
- Osgiliath Channel (8U120)
- Pelennor Grassland (7U354)
- Silverlode Banks (1U355)
- Ruined Capitol (7U355)
- Secret Door (32HF48)
- The Great River (3C118)
- Valley of the Anduin (V1_62)
- Brown Lands (1U357)
- Cross Roads (7U356)
- Gates of Argonath (3C117)
- Anduin Banks (1C356)
- Morgul Vale (7U357)
- Morgulduin (7U358)
- Nan Curunír (5U119)
- Pillars of the Kings (1U358)
- Ring of Isengard (4U358)
- Smaug's Den (30S56)
- Shores of Nen Hithoel (1U359)
- Wizard's Vale (4U359)
- Watchers of Cirith Ungol (10U120)
- Valley of Saruman (6U119)
- Nen Hithoel (V1_63)
- Northern Ithilien (7U359)
- Battle of the Five Armies (30S57)
- Caverns of Isengard (5U120)
- Dagorlad (7U360)
- Emyn Muil (1U360)
- Fortress of Orthanc (4U360)
- Haunted Pass (7U361)
- Orthanc Library (4U362)
- Palantír Chamber (4U363)
- Narchost (7U362)
- Northern Slopes (32HB49)
- Ravenhill (30FP65)
- Orthanc Balcony (4U361)
- Slag Mounds (7U363)
- Slopes of Amon Hen (1U361)
- Saruman’s Laboratory (6U120)
- Summit of Amon Hen (1C362)
- Tol Brandir (1U363)
- Thrór's Throne (31HE47)
- Amon Hen Ruins (V1_64)
- Wastes of Emyn Muil (3U120)