Template:FoilList: 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 4: | Line 4: | ||
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
|where=(L.Code='EN' OR (L.Code = 'TW' 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') AND C.SetNum = '{{{SetNum}}}' | |where=(L.Code='EN' OR (L.Code = 'TW' 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') AND C.SetNum = '{{{SetNum}}}' | ||
|order by= | |order by={{StandardSort}} | ||
|named args= yes | |named args= yes | ||
|format=template | |format=template | ||
Revision as of 05:15, 2 March 2022
No results
