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. | |where=C.Culture = 'ringwraith' AND (CR.GameText LIKE '%orc%' OR CR.SubTypes HOLDS 'orc') | ||
|order by={{StandardSort}} | |order by={{StandardSort}} | ||
|limit=400 | |limit=400 |
Revision as of 06:05, 6 March 2022
- Gorbag, Lieutenant of Cirith Ungol (7R180)
- Morgul Axe (7C186)
- Morgul Brawler (7U187)
- Morgul Brute (7R188)
- Morgul Cur (7C189)
- Morgul Destroyer (7U190)
- Morgul Detachment (7R191)
- Morgul Hound (7C192)
- Morgul Lackey (7C193)
- Morgul Mongrel (7C194)
- Morgul Predator (7C196)
- Morgul Regiment (7R197)
- Morgul Ruffian (7C198)
- Morgul Soldier (7C199)
- Morgul Spawn (7C200)
- Morgul Spearman (7C201)
- Morgul Whelp (7U202)
- War Long Planned (7C220)
- Gothmog, Morgul Commander (8R72)
- Morgul Ambusher (8C74)
- Morgul Creeper (8C75)
- Morgul Lurker (8C76)
- Morgul Squealer (8R77)
- Streaming to the Field (8U78)
- Cirith Ungol Scavenger (10U54)
- Cirith Ungol Soldier (10C55)
- Cirith Ungol Warrior (10C56)
- Cirith Ungol Watchman (10U57)
- Gorbag, Covetous Captain (10R59)
- Gorbag's Sword (10R60)
- Morgul Banner-bearer (10C62)
- Morgul Vanguard (10R63)
- Swarming Like Beetles (10C65)
- Ten Times Outnumbered (10C66)
- Dol Guldur Blade (32B246)
- He Is Summoning His Servants (32B258)