https://wiki.lotrtcgpc.net/index.php?action=history&feed=atom&title=PC_Errata%2FTable 2026-05-23T23:50:26Z Revision history for this page on the wiki MediaWiki 1.41.0 https://wiki.lotrtcgpc.net/index.php?title=PC_Errata/Table&diff=121823&oldid=prev 2023-06-12T02:47:07Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:47, 12 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{Card{{!}}', C.ID, '}}')=Original</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{Card{{!}}', C.ID, '}}')=Original</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT(CASE WHEN CR.Subset = 'E' THEN 'No' ELSE 'Yes' END)=Current</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT(CASE WHEN CR.Subset = 'E' THEN <ins style="font-weight: bold; text-decoration: none;">''''''</ins>'No<ins style="font-weight: bold; text-decoration: none;">''''''</ins>' ELSE 'Yes' END)=Current</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{C{{!}}', C.Culture, '}}')=Culture</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,CONCAT('{{C{{!}}', C.Culture, '}}')=Culture</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,IFNULL(IFNULL(IFNULL(IFNULL(CR.FormattedGameText, CR.GameText), EN.FormattedGameText), EN.GameText),'')=Game Text</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>,IFNULL(IFNULL(IFNULL(IFNULL(CR.FormattedGameText, CR.GameText), EN.FormattedGameText), EN.GameText),'')=Game Text</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=PC_Errata/Table&diff=121784&oldid=prev 2023-06-11T23:41:13Z

<p>Created page with &quot;{{NavBar||<a href="/wiki/PC_Errata" title="PC Errata">PC Errata</a>|<a href="/wiki/PC_Errata/List" title="PC Errata/List">PC Errata Simple List</a>|<a href="/wiki/PC_Errata/Notes" title="PC Errata/Notes">PC Errata Notes</a>}} Remember that the below table doesn&#039;t show certain commonly e...&quot;</p> <p><b>New page</b></p><div>{{NavBar||[[PC Errata|PC Errata]]|[[PC Errata/List|PC Errata Simple List]]|[[PC Errata/Notes|PC Errata Notes]]}}<br /> <br /> Remember that the below table doesn't show certain commonly errata'd stats, such as whether the card is unique or twilight cost, etc. Hover over the card name to see the full card image for all such changes.<br /> <br /> {{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN<br /> |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID<br /> |fields=<br /> CONCAT('[[File:', EN.PortraitFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Portrait<br /> ,CONCAT('{{Card{{!}}', C.ID, '}}')=Original<br /> ,CONCAT('{{Card{{!}}', CR.ID, '}}')=Errata<br /> ,CONCAT(CASE WHEN CR.Subset = 'E' THEN 'No' ELSE 'Yes' END)=Current<br /> ,CONCAT('{{C{{!}}', C.Culture, '}}')=Culture<br /> ,IFNULL(IFNULL(IFNULL(IFNULL(CR.FormattedGameText, CR.GameText), EN.FormattedGameText), EN.GameText),'')=Game Text<br /> |where= EN.LanguageCode = 'EN' AND EN.Revision = 0 AND CR.Revision &gt; 0 AND CR.Subset IN ('E', 'S') AND CR.ReleaseDate &gt; '2021-01-01'<br /> |order by= {{StandardSort}}<br /> |limit=400<br /> |format= dynamic table<br /> |rows per page=20<br /> |column widths=100px,,,,,,50%<br /> }}<br /> <br /> <br /> <br /> ----<br /> <br /> <br /> {{Format Table}}</div>

Teltura