Template:StandardSort - Revision history

https://wiki.lotrtcgpc.net/index.php?action=history&feed=atom&title=Template%3AStandardSort Template:StandardSort - Revision history 2026-04-17T14:54:50Z Revision history for this page on the wiki MediaWiki 1.41.0 https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=124632&oldid=prev Teltura at 17:15, 18 April 2025 2025-04-18T17:15:37Z

<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 17:15, 18 April 2025</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision <del style="font-weight: bold; text-decoration: none;">ASC</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision <ins style="font-weight: bold; text-decoration: none;">DESC</ins></div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=110585&oldid=prev Teltura at 03:32, 2 July 2022 2022-07-02T03:32:16Z

<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 03:32, 2 July 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision <del style="font-weight: bold; text-decoration: none;">DESC</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision <ins style="font-weight: bold; text-decoration: none;">ASC</ins></div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=100223&oldid=prev Teltura at 08:23, 18 January 2022 2022-01-18T08:23:47Z

<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 08:23, 18 January 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.<del style="font-weight: bold; text-decoration: none;">SETNUM REGEXP </del>'^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE <del style="font-weight: bold; text-decoration: none;">CAST(C.SetNum AS UNSIGNED INTEGER) + </del>100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.<ins style="font-weight: bold; text-decoration: none;">SetNum RLIKE </ins>'^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=100213&oldid=prev Teltura at 02:44, 18 January 2022 2022-01-18T02:44:22Z

<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:44, 18 January 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE <ins style="font-weight: bold; text-decoration: none;">CAST(C.SetNum AS UNSIGNED INTEGER) + </ins>100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=99550&oldid=prev Teltura at 04:09, 30 December 2021 2021-12-30T04:09:18Z

<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 04:09, 30 December 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE <del style="font-weight: bold; text-decoration: none;">100 </del>END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</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></noinclude>CASE WHEN C.SetNum = '0' THEN 20 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE <ins style="font-weight: bold; text-decoration: none;">20 </ins>END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=99549&oldid=prev Teltura at 04:08, 30 December 2021 2021-12-30T04:08:05Z

<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 04:08, 30 December 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>CASE WHEN C.SetNum = '0' THEN <del style="font-weight: bold; text-decoration: none;">100 </del>ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</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></noinclude>CASE WHEN C.SetNum = '0' THEN <ins style="font-weight: bold; text-decoration: none;">20 </ins>ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum, CR.Revision DESC</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=98673&oldid=prev Teltura at 05:11, 17 November 2021 2021-11-17T05:11:12Z

<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 05:11, 17 November 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>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.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum</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></noinclude>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.SetNum = '0' THEN CASE WHEN C.Subset IN ('S', 'F') THEN 1 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 END END, C.CardNum<ins style="font-weight: bold; text-decoration: none;">, CR.Revision DESC</ins></div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=90999&oldid=prev Teltura at 01:21, 10 November 2021 2021-11-10T01:21: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 01:21, 10 November 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>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.SetNum = '0' THEN CASE WHEN C.Subset <del style="font-weight: bold; text-decoration: none;">= </del>'<del style="font-weight: bold; text-decoration: none;">P</del>' THEN <del style="font-weight: bold; text-decoration: none;">0 </del>WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5, <del style="font-weight: bold; text-decoration: none;"> </del>C.CardNum</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></noinclude>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.SetNum = '0' THEN CASE WHEN C.Subset <ins style="font-weight: bold; text-decoration: none;">IN ('S</ins>'<ins style="font-weight: bold; text-decoration: none;">, </ins>'<ins style="font-weight: bold; text-decoration: none;">F') </ins>THEN <ins style="font-weight: bold; text-decoration: none;">1 </ins>WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5 <ins style="font-weight: bold; text-decoration: none;">END END</ins>, C.CardNum</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=90998&oldid=prev Teltura at 01:16, 10 November 2021 2021-11-10T01:16:30Z

<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 01:16, 10 November 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>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.<del style="font-weight: bold; text-decoration: none;">Subset </del>= '<del style="font-weight: bold; text-decoration: none;">S' THEN </del>0 <del style="font-weight: bold; text-decoration: none;">WHEN C.Subset = 'F</del>' THEN <del style="font-weight: bold; text-decoration: none;">1 </del>WHEN C.Subset = 'P' THEN 0 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END, C.CardNum</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></noinclude>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.<ins style="font-weight: bold; text-decoration: none;">SetNum </ins>= '0' THEN <ins style="font-weight: bold; text-decoration: none;">CASE </ins>WHEN C.Subset = 'P' THEN 0 WHEN C.Subset IN ('D', 'L') THEN 2 WHEN C.Subset = 'M' THEN 3 WHEN C.Subset = 'J' THEN 4 ELSE 100 END <ins style="font-weight: bold; text-decoration: none;">ELSE CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'M' THEN 2 WHEN C.Subset = 'A' THEN 3 WHEN C.Subset = 'O' THEN 4 WHEN C.Subset = 'T' THEN 5</ins>, C.CardNum</div></td></tr> </table>

Teltura https://wiki.lotrtcgpc.net/index.php?title=Template:StandardSort&diff=90989&oldid=prev Teltura at 18:58, 9 November 2021 2021-11-09T18:58:27Z

<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 18:58, 9 November 2021</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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><noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.</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></noinclude>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 <del style="font-weight: bold; text-decoration: none;">= </del>'D' <del style="font-weight: bold; text-decoration: none;">THEN 1 WHEN C.Subset = </del>'<del style="font-weight: bold; text-decoration: none;">M</del>' THEN 2 WHEN C.Subset = '<del style="font-weight: bold; text-decoration: none;">J</del>' THEN 3 WHEN C.Subset = '<del style="font-weight: bold; text-decoration: none;">L</del>' THEN 4 ELSE 100 END, C.CardNum</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></noinclude>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 <ins style="font-weight: bold; text-decoration: none;">IN (</ins>'D'<ins style="font-weight: bold; text-decoration: none;">, </ins>'<ins style="font-weight: bold; text-decoration: none;">L</ins>'<ins style="font-weight: bold; text-decoration: none;">) </ins>THEN 2 WHEN C.Subset = '<ins style="font-weight: bold; text-decoration: none;">M</ins>' THEN 3 WHEN C.Subset = '<ins style="font-weight: bold; text-decoration: none;">J</ins>' THEN 4 ELSE 100 END, C.CardNum</div></td></tr> </table>

Teltura