Template:FoilList - Revision history

Teltura: Fixing quotes with non-English languages

2023-01-26T15:03:29Z

Fixing quotes with non-English languages

← Older revision		Revision as of 15:03, 26 January 2023
Line 7:		Line 7:
	,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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' 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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' Foil') END END)=Suffix
	\|where=(CR.LanguageCode IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND CR.LanguageCode IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND CR.LanguageCode IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(CR.LanguageCode IN ('{{{Lang\|EN}}}') OR ((('EN' IN ('{{{Lang\|EN}}}') AND CR.LanguageCode IN ('TW')) OR ('DE' IN ('{{{Lang\|EN}}}') AND CR.LanguageCode IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code
	\|named args= yes		\|named args= yes

Teltura at 21:20, 16 April 2022

2022-04-16T21:20:44Z

← Older revision		Revision as of 21:20, 16 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
	,CR.Title=Title		,IFNULL(CR.Title,C.Title)=Title
	,IFNULL(CR.Subtitle,C.Subtitle)=Subtitle		,IFNULL(CR.Subtitle,C.Subtitle)=Subtitle
	,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo		,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo

Teltura at 21:11, 16 April 2022

2022-04-16T21:11:37Z

← Older revision		Revision as of 21:11, 16 April 2022
Line 7:		Line 7:
	,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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' 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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' Foil') END END)=Suffix
	\|where=(L.~~Code~~ IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.~~Code~~ IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.~~Code~~ IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(CR.LanguageCode IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND CR.LanguageCode IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND CR.LanguageCode IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code
	\|named args= yes		\|named args= yes

Teltura at 20:33, 16 April 2022

2022-04-16T20:33:35Z

← Older revision		Revision as of 20:33, 16 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~~,C.Title)~~=Title		,CR.Title=Title
	,IFNULL(CR.Subtitle,C.Subtitle)=Subtitle		,IFNULL(CR.Subtitle,C.Subtitle)=Subtitle
	,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo		,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo

Teltura at 20:30, 16 April 2022

2022-04-16T20:30:02Z

← Older revision		Revision as of 20:30, 16 April 2022
Line 4:		Line 4:
	,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	,IFNULL(CR.Title,C.Title)=Title		,IFNULL(CR.Title,C.Title)=Title
	, IFNULL(CR.Subtitle,C.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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' 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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' Foil') END END)=Suffix
	\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'

Teltura at 20:19, 16 April 2022

2022-04-16T20:19:31Z

← Older revision		Revision as of 20:19, 16 April 2022
Line 6:		Line 6:
	, IFNULL(CR.Subtitle,C.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 '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 CONCAT(L.Code, ' Rare Foil') WHEN CR.Subset = 'O' THEN CONCAT(L.Code, ' Masterworks Foil') ELSE CONCAT(L.Code, ' Foil') END END)=Suffix
	\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code

Teltura at 20:14, 16 April 2022

2022-04-16T20:14:05Z

← Older revision		Revision as of 20:14, 16 April 2022
Line 7:		Line 7:
	, 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 '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 'EN Foil' END END)=Suffix
	\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((L.Code IN ('TW') OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((('EN' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TW')) OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code
	\|named args= yes		\|named args= yes

Teltura at 03:19, 16 April 2022

2022-04-16T03:19:18Z

← Older revision		Revision as of 03:19, 16 April 2022
Line 7:		Line 7:
	, 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 '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 'EN Foil' END END)=Suffix
	\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR (L.Code IN ('TW', 'TG') 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR ((L.Code IN ('TW') OR ('DE' IN ({{{Lang\|'EN'}}}) AND L.Code IN ('TG'))) 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code
	\|named args= yes		\|named args= yes

Teltura at 08:14, 15 April 2022

2022-04-15T08:14:48Z

← 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,C.Title)=Title
			, IFNULL(CR.Subtitle,C.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 '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 'EN Foil' END END)=Suffix
	\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR (L.Code IN ('TW', 'TG') 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR (L.Code IN ('TW', 'TG') 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'

Teltura: adding language support

2022-04-15T07:28:32Z

adding language support

← Older revision		Revision as of 07:28, 15 April 2022
Line 4:		Line 4:
	,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 'EN Foil' END END)=Suffix
	\|where=(L.Code='EN' OR (L.Code IN ('TW', 'TG') 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'		\|where=(L.Code IN ({{{Lang\|'EN'}}}) OR (L.Code IN ('TW', 'TG') 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') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}'
	\|order by={{StandardSort}}, L.Code		\|order by={{StandardSort}}, L.Code
	\|named args= yes		\|named args= yes