https://wiki.lotrtcgpc.net/index.php?action=history&feed=atom&title=User%3ATeltura%2Fboostersimtable 2026-05-16T19:16:37Z Revision history for this page on the wiki MediaWiki 1.41.0 https://wiki.lotrtcgpc.net/index.php?title=User:Teltura/boostersimtable&diff=122209&oldid=prev 2023-08-07T00:59:26Z

<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 00:59, 7 August 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</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('', CASE WHEN C.CardType = 'Site' THEN 'true' ELSE 'false' END) =Horiz</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('', CASE WHEN C.CardType = 'Site' THEN 'true' ELSE 'false' END) =Horiz</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;"><br></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;"><br></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>|where=CR.LanguageCode = 'EN' AND F.LanguageCode = 'EN' AND CR.Subset = 'S' AND F.Subset = 'F'</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>|where=CR.LanguageCode = 'EN' AND F.LanguageCode = 'EN' AND CR.Subset = 'S' AND F.Subset = 'F' <ins style="font-weight: bold; text-decoration: none;">AND CR.Revision = 0</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>|order by={{StandardSort}}</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>|order by={{StandardSort}}</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>|limit=4000</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>|limit=4000</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=User:Teltura/boostersimtable&diff=122208&oldid=prev 2023-08-07T00:56:29Z

<p>Created page with &quot;{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=S,CardReleases=F |join on=C.ID = CR.BaseCardID,S.ID=C.SetNum,C.ID=F.BaseCardID |fields= ,CONCAT(&#039;https://wiki.lotrtcgpc....&quot;</p> <p><b>New page</b></p><div>{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=S,CardReleases=F<br /> |join on=C.ID = CR.BaseCardID,S.ID=C.SetNum,C.ID=F.BaseCardID<br /> |fields=<br /> ,CONCAT('https://wiki.lotrtcgpc.net/wiki/', REPLACE(REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ' ', '_'))=WikiLink<br /> ,CONCAT('', CR.ImageFilename)=StandardFilename<br /> ,CONCAT('thumb/', F.ImageFilename, '/353px-', F.ImageFilename)=FoilFilename<br /> ,CONCAT(CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END)=CardName<br /> ,C.SetNum<br /> ,C.Rarity<br /> ,C.CardNum<br /> ,CONCAT('', CASE WHEN C.CardType = 'Site' THEN 'true' ELSE 'false' END) =Horiz<br /> <br /> |where=CR.LanguageCode = 'EN' AND F.LanguageCode = 'EN' AND CR.Subset = 'S' AND F.Subset = 'F'<br /> |order by={{StandardSort}}<br /> |limit=4000<br /> |format=table<br /> |columns=3<br /> }}</div>

Teltura