Template:FoilList: Difference between revisions

From LOTR-TCG Wiki
No edit summary
(Fixing quotes with non-English languages)
 
Line 7: Line 7:
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
,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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' 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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' Foil') END END)=Suffix
|where=(CR.LanguageCode IN ({{{Lang|'EN'}}}) OR ((('EN' IN ({{{Lang|'EN'}}}) AND CR.LanguageCode IN ('TW')) OR ('DE' IN ({{{Lang|'EN'}}}) AND CR.LanguageCode IN ('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', 'A', 'O') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
|where=(CR.LanguageCode IN ('{{{Lang|EN}}}') OR ((('EN' IN ('{{{Lang|EN}}}') AND CR.LanguageCode IN ('TW')) OR ('DE' IN ('{{{Lang|EN}}}') AND CR.LanguageCode IN ('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', 'A', 'O') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
|order by={{StandardSort}}, L.Code
|order by={{StandardSort}}, L.Code
|named args= yes
|named args= yes

Latest revision as of 15:03, 26 January 2023

No results