Template:FoilList: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 4: | Line 4: | ||
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
,IFNULL(CR.Title,C.Title)=Title | ,IFNULL(CR.Title,C.Title)=Title | ||
, IFNULL(CR.Subtitle,C.Subtitle)=Subtitle | ,IFNULL(CR.Subtitle,C.Subtitle)=Subtitle | ||
, 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=(L.Code IN ({{{Lang|'EN'}}}) OR ((('EN' IN ({{{Lang|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang|'EN'}}}) AND L.Code 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=(L.Code IN ({{{Lang|'EN'}}}) OR ((('EN' IN ({{{Lang|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang|'EN'}}}) AND L.Code 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}}}' |
Revision as of 20:30, 16 April 2022
No results