Template:CardList: Difference between revisions
From LOTR-TCG Wiki
(Created page with "{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L |join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code |fields= CR.ImageFilename=ImageFile ,REPLACE(REPLACE(C._pageName...") |
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 | ||
,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 | ,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 {{{Lang|'EN'}}} + ' Card' END END)=Suffix | ||
|where=(L.Code IN ({{{Lang|'EN'}}})) AND (CR.Subset IN ('S') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}' | |where=(L.Code IN ({{{Lang|'EN'}}})) AND (CR.Subset IN ('S') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}' | ||
|order by={{StandardSort}}, L.Code | |order by={{StandardSort}}, L.Code |
Revision as of 07:56, 15 April 2022
No results