User:Teltura/cardimages: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
|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= 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') | |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', '1U274', '3U100', '1R272', '15C120', '2R93', '12C93', '11C120', '1C266', '2C90', '11U114', '1R246', '3U96', '3C95', '11R141', '11U118', '13C107', '1R247', '11C122', '18C91', '3R99', '1R250', '13C107', '11C140', '1U249', '1R240', '1C255', '1U241', '12C84', '1U257', '2C95', '1C248', '1R265', '11U139', '1R256', '1U63', '1R62', '9R+15', '1R66', '11R17' ) | ||
|order by= CR.SiteNum, CR.Title | |order by= CR.SiteNum, CR.Title | ||
|limit=400 | |limit=400 | ||
Latest revision as of 17:25, 18 August 2023
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
, 
