Template:CultureSort

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

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