Template:FoilList: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 5: | Line 5: | ||
,CONCAT(CASE WHEN L.Code = 'TW' THEN 'EN Tengwar Foil' WHEN L.Code = 'TG' THEN 'DE Tengwar Foil' ELSE CASE WHEN CR.Subset = 'A' THEN 'Rare Foil' WHEN CR.Subset = 'O' THEN 'Masterworks Foil' ELSE 'EN Foil' END END)=Suffix | ,CONCAT(CASE WHEN L.Code = 'TW' THEN 'EN Tengwar Foil' WHEN L.Code = 'TG' THEN 'DE Tengwar Foil' ELSE CASE WHEN CR.Subset = 'A' THEN 'Rare Foil' WHEN CR.Subset = 'O' THEN 'Masterworks Foil' ELSE 'EN Foil' END END)=Suffix | ||
|where=(L.Code='EN' OR (L.Code IN ('TW', 'TG') AND CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 0 END > 10)) AND CR.Subset IN ('F', 'G', 'A', 'O') AND C.SetNum = '{{{SetNum}}}' | |where=(L.Code='EN' OR (L.Code IN ('TW', 'TG') AND CASE WHEN C.SetNum RLIKE '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 0 END > 10)) AND CR.Subset IN ('F', 'G', 'A', 'O') AND C.SetNum = '{{{SetNum}}}' | ||
|order by={{StandardSort}} | |order by={{StandardSort}}, L.Code | ||
|named args= yes | |named args= yes | ||
|format=template | |format=template |
Revision as of 18:11, 5 March 2022
No results