Template:AlternateVersionTable: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 5: | Line 5: | ||
|fields=CR.ID=CardID | |fields=CR.ID=CardID | ||
,CR.CollInfo | ,CR.CollInfo | ||
,CR.GameText | ,ISNULL(CR.FormattedGameText, CR.GameText)=GameText | ||
,CR.PortraitFilename | ,CR.PortraitFilename | ||
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageName | ,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageName | ||
Line 11: | Line 11: | ||
AND '{{TitleLookup|{{{1}}}}}' = C.Title | AND '{{TitleLookup|{{{1}}}}}' = C.Title | ||
AND C.CollInfo != '{{{1}}}' | AND C.CollInfo != '{{{1}}}' | ||
|order by=C.SetNum, C.SetOrder, C.CardNum, CR._rowID | |order by=CONVERT(C.SetNum, UNSIGNED INTEGER), C.SetOrder, C.CardNum, CR._rowID | ||
|intro=<!-- | |intro=<!-- | ||
-->{{{!}} class="wikitable" style="margin:2px" | -->{{{!}} class="wikitable" style="margin:2px" |
Revision as of 10:18, 13 October 2021
This is the "AlternateVersionTable" template.
It should be called in the following format:
{{AlternateVersionTable |1= }}
Edit the page to see the template text.