PC Errata/Gallery: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 1 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 19: | Line 20: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 2 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 31: | Line 33: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 3 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 43: | Line 46: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 4 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 55: | Line 59: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 5 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 67: | Line 72: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 6 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 79: | Line 85: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 7 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 91: | Line 98: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 8 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 103: | Line 111: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 9 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 115: | Line 124: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 10 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 127: | Line 137: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 11 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 139: | Line 150: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 12 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 151: | Line 163: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 13 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 163: | Line 176: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 14 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 175: | Line 189: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 15 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 187: | Line 202: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 16 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 199: | Line 215: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 17 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 211: | Line 228: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 18 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
| Line 223: | Line 241: | ||
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,MAX(CONCAT(CR.Revision,':[[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('S') AND CR.ReleaseDate > '2021-01-01' AND C.SetNum = 19 | ||
|order by= {{StandardSort}} | |order by= {{StandardSort}} | ||
|group by=CR.BaseCardID | |||
|limit=400 | |limit=400 | ||
|format= list | |format= list | ||
Revision as of 17:54, 18 April 2025
Back to PC Errata |
PC Errata Simple List |
Set 1 - The Fellowship of the Ring
1:
, 2:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 3:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 2:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
Set 2 - Mines of Moria
1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 3:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
Set 3 - Realms of the Elf-lords
1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 3:
, 1:
, 1:
, 2:
, 1:
, 3:
, 1:
, 3:
, 1:
, 1:
, 2:
, 1:
, 1:
, 4:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
Set 4 - The Two Towers
1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 1:
Set 5 - Battle of Helm's Deep
1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
Set 6 - Ents of Fangorn
Set 7 - The Return of the King
Set 8 - Siege of Gondor
1:
, 1:
, 1:
, 1:
, 2:
, 2:
, 2:
, 1:
, 1:
, 1:
Set 9 - Reflections
1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
Set 10 - Mount Doom
1:
, 2:
, 3:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
Set 11 - Shadows
Set 12 - Black Rider
No results
Set 13 - Bloodlines
Set 14 - Expanded Middle-earth
No results
Set 15 - The Hunters
Set 16 - The Wraith Collection
No results
Set 17 - Rise of Saruman
Set 18 - Treachery & Deceit
1:
, 1:
, 2:
, 1:
, 1:
, 1:
, 2:
, 2:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
, 1:
Set 19 - Age's End
| Formats |
|---|
| Sets | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 10 | 9 | 11 | 12 | 13 | 14 | 15 | 17 | 18 | 16 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Historical Decipher Formats | Fellowship Block | Towers Block | King Block | War of the Ring Block | Hunters Block | ||||||||||||||
| Towers Standard | |||||||||||||||||||
| King Standard | |||||||||||||||||||
| Movie Block | |||||||||||||||||||
| War of the Ring Standard | |||||||||||||||||||
| Standard | |||||||||||||||||||
| Expanded | |||||||||||||||||||
| Open | |||||||||||||||||||
| Player's Council Formats (including PC Errata) | 1 | 2 | 3 | V1 | 4 | 5 | 6 | V2 | 7 | 8 | 9 | 10 | V3 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PC-Fellowship | ||||||||||||||||||||||
| PC-Movie | ||||||||||||||||||||||
| PC-Expanded | ||||||||||||||||||||||
| PC Errata | 2021 | X-List Errata • Yuletide 2021 |
|---|---|---|
| 2022 | Summer 2022 • Yuletide 2022 | |
| 2023 | World Championship 2023 • Yuletide 2023 | |
| 2024 | World Championship 2024 • Yuletide 2024 + V2 | |
| 2025 | Spring 2025 • World Championship 2025 • Yuletide 2025 + V3 | |
| 2026 | TBD |
| Other Variants | |||||
|---|---|---|---|---|---|
| Sealed • Booster Draft • Cube Draft • Culture Shock • Highlander • Poor Man's • PC Errata | |||||



































