https://wiki.lotrtcgpc.net/index.php?action=history&feed=atom&title=User%3ATeltura%2Fallcards 2026-05-16T17:18:11Z Revision history for this page on the wiki MediaWiki 1.41.0 https://wiki.lotrtcgpc.net/index.php?title=User:Teltura/allcards&diff=121733&oldid=prev 2023-05-15T21:43:00Z

<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 21:43, 15 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l4">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</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('https://wiki.lotrtcgpc.net/wiki/', REPLACE(REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ' ', '_'))=WikiLink</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('https://wiki.lotrtcgpc.net/wiki/', REPLACE(REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ' ', '_'))=WikiLink</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(CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END)=CardName</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(CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END)=CardName</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>,<del style="font-weight: bold; text-decoration: none;">IFNULL(CR</del>.<del style="font-weight: bold; text-decoration: none;">CollInfo</del>,C.<del style="font-weight: bold; text-decoration: none;">CollInfo)=CollInfo</del></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>,<ins style="font-weight: bold; text-decoration: none;">C.SetNum</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;">,C</ins>.<ins style="font-weight: bold; text-decoration: none;">Rarity</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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>,C.<ins style="font-weight: bold; text-decoration: none;">CardNum</ins></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>,C.GEMP_ID</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>,C.GEMP_ID</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>,''=Alias ID</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>,''=Alias ID</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;">,C.Culture</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;">,C.CardType</ins></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>,''=Notes</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>,''=Notes</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>|where=CR.LanguageCode = 'EN'</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>|where=CR.LanguageCode = 'EN'</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=User:Teltura/allcards&diff=121732&oldid=prev 2023-05-15T21:37:54Z

<p>Created page with &quot;{{#cargo_query:tables=Cards=C,CardReleases=CR |join on=C.ID = CR.ID |fields= ,CONCAT(&#039;https://wiki.lotrtcgpc.net/wiki/&#039;, REPLACE(REPLACE(REPLACE(C._pageName, &#039;/Data&#039;, &#039;&#039;), &#039;Da...&quot;</p> <p><b>New page</b></p><div>{{#cargo_query:tables=Cards=C,CardReleases=CR<br /> |join on=C.ID = CR.ID<br /> |fields=<br /> ,CONCAT('https://wiki.lotrtcgpc.net/wiki/', REPLACE(REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ' ', '_'))=WikiLink<br /> ,CONCAT(CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END)=CardName<br /> ,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo<br /> ,C.GEMP_ID<br /> ,''=Alias ID<br /> ,''=Notes<br /> |where=CR.LanguageCode = 'EN'<br /> |order by={{StandardSort}}<br /> |limit=4000<br /> |format=table<br /> |columns=3<br /> }}</div>

Teltura