PC Errata/Notes - Revision history

Teltura at 06:27, 12 June 2023

2023-06-12T06:27:01Z

← Older revision		Revision as of 06:27, 12 June 2023
Line 15:		Line 15:
	,CR.Notes=Decipher Notes		,CR.Notes=Decipher Notes
	,CR.ReleaseNotes=PC Notes		,CR.ReleaseNotes=PC Notes
	\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN ('E', 'S') AND CR.ReleaseDate < '2021-05-08'		\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN ('E', 'S') AND CR.ReleaseDate BETWEEN '2020-01-01' AND '2021-05-08'
	\|order by= {{StandardSort}}		\|order by= {{StandardSort}}
	\|limit=400		\|limit=400

Teltura at 06:11, 12 June 2023

2023-06-12T06:11:38Z

← Older revision		Revision as of 06:11, 12 June 2023
Line 36:		Line 36:
	,CR.ReleaseNotes=PC Notes		,CR.ReleaseNotes=PC Notes
	\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-05-08'		\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-05-08'
	\|order by= CR.ReleaseDate ~~AND~~ {{StandardSort}}		\|order by= CR.ReleaseDate, {{StandardSort}}
	\|limit=400		\|limit=400
	\|format= dynamic table		\|format= dynamic table

Teltura at 23:42, 11 June 2023

2023-06-11T23:42:10Z

← Older revision		Revision as of 23:42, 11 June 2023
Line 19:		Line 19:
	\|limit=400		\|limit=400
	\|format= dynamic table		\|format= dynamic table
	\|rows per page=~~100~~		\|rows per page=20
	\|column widths=,,25%,25%		\|column widths=,,25%,25%
	}}		}}
Line 39:		Line 39:
	\|limit=400		\|limit=400
	\|format= dynamic table		\|format= dynamic table
	\|rows per page=~~100~~		\|rows per page=20
	}}		}}

Teltura at 23:23, 11 June 2023

2023-06-11T23:23:04Z

← Older revision		Revision as of 23:23, 11 June 2023
Line 15:		Line 15:
	,CR.Notes=Decipher Notes		,CR.Notes=Decipher Notes
	,CR.ReleaseNotes=PC Notes		,CR.ReleaseNotes=PC Notes
	\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset = 'E' AND CR.ReleaseDate < '2021-05-08'		\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN ('E', 'S') AND CR.ReleaseDate < '2021-05-08'
	\|order by= {{StandardSort}}		\|order by= {{StandardSort}}
	\|limit=400		\|limit=400

Teltura at 23:21, 11 June 2023

2023-06-11T23:21:06Z

← Older revision		Revision as of 23:21, 11 June 2023
Line 1:		Line 1:
	{{NavBar\|\|[[PC Errata\|PC Errata]]\|[[PC Errata/Table\|PC Errata Table]]\|[[PC Errata/~~Thumbs~~\|PC Errata ~~Thumbnail Browser~~]]}}		{{NavBar\|\|[[PC Errata\|PC Errata]]\|[[PC Errata/Table\|PC Errata Table Readout]]\|[[PC Errata/Gallery\|PC Errata Gallery]]}}

Teltura at 23:01, 11 June 2023

2023-06-11T23:01:34Z

← Older revision		Revision as of 23:01, 11 June 2023
Line 12:		Line 12:
	,CONCAT('{{Card{{!}}', C.ID, '}}')=Original		,CONCAT('{{Card{{!}}', C.ID, '}}')=Original
	,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata		,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata
			,CONCAT(CASE WHEN CR.Subset = 'E' THEN 'No' ELSE 'Yes' END)=Current
	,CR.Notes=Decipher Notes		,CR.Notes=Decipher Notes
	,CR.ReleaseNotes=PC Notes		,CR.ReleaseNotes=PC Notes
Line 32:		Line 33:
	,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata		,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata
	,CR.ReleaseDate=Release Date		,CR.ReleaseDate=Release Date
			,CONCAT(CASE WHEN CR.Subset = 'E' THEN 'No' ELSE 'Yes' END)=Current
	,CR.ReleaseNotes=PC Notes		,CR.ReleaseNotes=PC Notes
	\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset = 'E' AND CR.ReleaseDate > '2021-05-08'		\|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset IN('E', 'S') AND CR.ReleaseDate > '2021-05-08'
	\|order by= {{StandardSort}}		\|order by= CR.ReleaseDate AND {{StandardSort}}
	\|limit=400		\|limit=400
	\|format= dynamic table		\|format= dynamic table

Teltura: Creating as a place to see all of the PC justifications in one spot

2023-06-11T22:26:34Z

Creating as a place to see all of the PC justifications in one spot

New page

{{NavBar||[[PC Errata|PC Errata]]|[[PC Errata/Table|PC Errata Table]]|[[PC Errata/Thumbs|PC Errata Thumbnail Browser]]}}

== X-List ==

Unlike all following PC errata batches, the initial X-List batch has notes from Decipher explaining why they banned the card. Those notes are shown alongside the PC's own.

{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID
|fields=
,CONCAT('{{Card{{!}}', C.ID, '}}')=Original
,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata
,CR.Notes=Decipher Notes
,CR.ReleaseNotes=PC Notes
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset = 'E' AND CR.ReleaseDate < '2021-05-08'
|order by= {{StandardSort}}
|limit=400
|format= dynamic table
|rows per page=100
|column widths=,,25%,25%
}}

== PC Errata ==

All later PC errata were done at the PC's discretion

{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN
|join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID
|fields=
,CONCAT('{{Card{{!}}', C.ID, '}}')=Original
,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata
,CR.ReleaseDate=Release Date
,CR.ReleaseNotes=PC Notes
|where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision > 0 AND CR.Subset = 'E' AND CR.ReleaseDate > '2021-05-08'
|order by= {{StandardSort}}
|limit=400
|format= dynamic table
|rows per page=100
}}

----

{{Format Table}}