Editing PC Errata/Gallery
From LOTR-TCG Wiki
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 8: | Line 8: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 1 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 1 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 20: | Line 20: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 2 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 2 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 32: | Line 32: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 3 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 3 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 44: | Line 44: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 4 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 4 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 56: | Line 56: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 5 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 5 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 68: | Line 68: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 6 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 6 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 80: | Line 80: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 7 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 7 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 92: | Line 92: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 8 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 8 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 104: | Line 104: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 9 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 9 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 116: | Line 116: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 10 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 10 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 128: | Line 128: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 11 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 11 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 140: | Line 140: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 12 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 12 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 152: | Line 152: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 13 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 13 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 164: | Line 164: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 14 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 14 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 176: | Line 176: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 15 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 15 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 188: | Line 188: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 16 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 16 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 200: | Line 200: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 17 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 17 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 212: | Line 212: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 18 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 18 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 | ||
Line 224: | Line 224: | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 19 | |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 19 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|limit=400 | |limit=400 |