User:Teltura/cardimages: Difference between revisions
From LOTR-TCG Wiki
(Created page with "{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=EN |join on=C.ID = CR.BaseCardID, EN.ID = CR.BaseCardID, EN.BaseCardID = C.ID |fields= ,CONCAT('File:', CR.ImageFi...") |
No edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_query:tables=Cards=C,CardReleases=CR | {{#cargo_query:tables=Cards=C,CardReleases=CR | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID | ||
|fields= | |fields= | ||
,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ,CONCAT('[[File:', CR.ImageFilename, '{{!}}link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),']]')=Image | ||
|where= | |where= CR.LanguageCode = 'EN' AND CR.Subset = 'S' AND CR.Revision = 0 AND C.CollInfo IN ('3U45', '3C43', '1U267', '11S126', '11R134', '12U99', '18R47', '1C92', '3R39', '18U8', '1C43', '15C14', '1C41', '3C94', '11U16', '1C269', '9R+12', '0P58', '3C98', '1C101', '1C103', '1C107', '18R12', '13R65', '13R141', '19P27', '13R140') | ||
|order by= CR.SiteNum, CR.Title | |order by= CR.SiteNum, CR.Title | ||
|limit=400 | |limit=400 |