Template:CardList - Revision history

Teltura at 08:14, 15 April 2022

2022-04-15T08:14:15Z

← Older revision		Revision as of 08:14, 15 April 2022
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
	,IFNULL(CR.Title,~~ECR~~.Title)=Title		,IFNULL(CR.Title,C.Title)=Title
	, IFNULL(CR.Subtitle,~~ECR~~.Subtitle)=Subtitle		, IFNULL(CR.Subtitle,C.Subtitle)=Subtitle
	, IFNULL(CR.CollInfo,C.CollInfo)=CollInfo		, IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
	,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 CONCAT({{{Lang\|'EN'}}}, ' Card') END END)=Suffix		,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 CONCAT({{{Lang\|'EN'}}}, ' Card') END END)=Suffix

Teltura at 08:13, 15 April 2022

2022-04-15T08:13:57Z

← Older revision		Revision as of 08:13, 15 April 2022
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
			,IFNULL(CR.Title,ECR.Title)=Title
			, IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle
			, IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
	,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 CONCAT({{{Lang\|'EN'}}}, ' Card') END END)=Suffix		,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 CONCAT({{{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}}}'

Teltura at 07:59, 15 April 2022

2022-04-15T07:59:58Z

← Older revision		Revision as of 07:59, 15 April 2022
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 {{{Lang\|'EN'}}} + ' Card' END END)=Suffix		,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 CONCAT({{{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

Teltura at 07:56, 15 April 2022

2022-04-15T07:56:59Z

← Older revision		Revision as of 07:56, 15 April 2022
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 ~~Foil~~' END END)=Suffix		,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

Teltura: 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..."

2022-04-15T07:32:46Z

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..."

New page

{{#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, '/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 Foil' 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}}}'
|order by={{StandardSort}}, L.Code
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}