Template:FoilList: Difference between revisions
From LOTR-TCG Wiki
(Adding support for German Tengwar) |
No edit summary |
||
| Line 3: | Line 3: | ||
|fields= CR.ImageFilename=ImageFile | |fields= CR.ImageFilename=ImageFile | ||
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
,CASE WHEN L.Code = 'TW' THEN 'Tengwar Foil' WHEN L.Code = 'TG' THEN 'German Tengwar Foil' ELSE 'EN Foil' 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}} | ||
Revision as of 17:55, 5 March 2022
Error: No field named "CASE WHEN L.Code = 'TW' THEN 'Tengwar Foil' WHEN L.Code = 'TG' THEN 'German Tengwar Foil' ELSE 'EN Foil' END=Suffix" found for any of the specified database tables.
