Template:CultureSort - Revision history

Teltura at 08:42, 25 September 2022

2022-09-25T08:42:28Z

← Older revision		Revision as of 08:42, 25 September 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN CASE WHEN C.Culture = 'The One Ring' THEN 0 ELSE 3 END ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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

Teltura at 08:12, 25 September 2022

2022-09-25T08:12:46Z

← Older revision		Revision as of 08:12, 25 September 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN ~~CASE WHEN C.Culture = 'The One Ring' THEN 0 ELSE~~ 3 ~~END~~ ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 ~~DESC~~		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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

Teltura at 06:11, 25 September 2022

2022-09-25T06:11:30Z

← Older revision		Revision as of 06:11, 25 September 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN CASE WHEN C.Culture = 'The One Ring' THEN 0 ELSE 3 END ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 DESC

Teltura at 05:51, 25 September 2022

2022-09-25T05:51:22Z

← Older revision		Revision as of 05:51, 25 September 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) ~~> 19~~ THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(C.SetNum, 1) = 'V' THEN 1 ELSE 2 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 DESC

Teltura at 22:15, 24 September 2022

2022-09-24T22:15:49Z

← Older revision		Revision as of 22:15, 24 September 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, C.Culture, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, CASE WHEN C.Culture = 'The One Ring' THEN 'AAA' WHEN C.Culture = 'Site' THEN 'ZZZ' ELSE C.Culture END, 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 DESC

Teltura at 21:51, 29 January 2022

2022-01-29T21:51:37Z

← Older revision		Revision as of 21:51, 29 January 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow, C.Culture, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN 3 ELSE 4 END, C.Culture, 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 DESC

Teltura: Fixed side sorting putting sites between freeps and shadow

2022-01-29T21:49:39Z

Fixed side sorting putting sites between freeps and shadow

← Older revision		Revision as of 21:49, 29 January 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, C.Side, C.Culture, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, CASE C.Side WHEN 'Free Peoples' THEN 1 WHEN 'Shadow, C.Culture, 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 DESC

Teltura: Adding a sorting clause by side to split up smeagol/gollum

2022-01-29T21:18:16Z

Adding a sorting clause by side to split up smeagol/gollum

← Older revision		Revision as of 21:18, 29 January 2022
Line 1:		Line 1:
	<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.		<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

	</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, C.Culture, 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 DESC		</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, C.Side, C.Culture, 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 DESC

Teltura: Creating to have a standardized culture-grouped sorting that still puts Decipher cards before unofficial ones

2022-01-18T08:28:46Z

Creating to have a standardized culture-grouped sorting that still puts Decipher cards before unofficial ones

New page

<noinclude>This is used in various cargo queries to ensure a sensible, generalized ordering of cards.

</noinclude>CASE WHEN CAST(C.SetNum AS UNSIGNED INTEGER) > 19 THEN 1 ELSE 0 END, C.Culture, 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 DESC