Template:AlternateVersionTable: Difference between revisions

From LOTR-TCG Wiki
No edit summary
(adding smarter sorting logic)
Line 11: Line 11:
AND '{{TitleLookup|{{{1}}}}}' = C.Title  
AND '{{TitleLookup|{{{1}}}}}' = C.Title  
AND C.CollInfo != '{{{1}}}'
AND C.CollInfo != '{{{1}}}'
|order by=CR.ID, C.SetOrder, C.CardNum, CR._rowID
|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum
|intro=<!--
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
-->{{{!}} class="wikitable" style="margin:2px"

Revision as of 00:27, 19 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.