List of International Cards/ZH - Revision history

Teltura: Text replacement - ", 'M'" to ""

2022-04-14T19:02:43Z

Text replacement - ", 'M'" to ""

← Older revision		Revision as of 19:02, 14 April 2022
Line 6:		Line 6:
	== Nonfoil ==		== Nonfoil ==

	* [[List of International Cards/ZH/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '0'}}''')		* [[List of International Cards/ZH/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '0'}}''')
	* [[List of International Cards/ZH/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '1'}}''')		* [[List of International Cards/ZH/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '1'}}''')


Line 20:		Line 20:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename
	\|where= CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('ZH')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('ZH')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 31:		Line 31:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=COUNT(*)		\|fields=COUNT(*)
	\|where= CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('ZH')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('ZH')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 62:		Line 62:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('ZH')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('ZH')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 73:		Line 73:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=COUNT(*)		\|fields=COUNT(*)
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('ZH')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('ZH')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura at 18:40, 14 April 2022

2022-04-14T18:40:43Z

← Older revision		Revision as of 18:40, 14 April 2022
Line 1:		Line 1:
	{{NavBar\|List of FOTR Foils\|[[List of International Cards\|International Card List Index]]\|[[List of International Cards/PT\|List of Portuguese Cards]]\|[[List of International Cards/ZH\|List of ~~Chinese~~ Cards]]}}		{{NavBar\|List of FOTR Foils\|[[List of International Cards\|International Card List Index]]\|[[List of International Cards/PT\|List of Portuguese Cards]]\|[[List of International Cards/EL\|List of Greek Cards]]}}

	Below are the subpages for each set for this language.		Below are the subpages for each set for this language.

Teltura at 18:40, 14 April 2022

2022-04-14T18:40:16Z

← Older revision		Revision as of 18:40, 14 April 2022
Line 1:		Line 1:
	{{NavBar\|List of FOTR Foils\|[[List of International Cards\|International Card List Index]]\|[[List of International Cards/ZH\|List of Portuguese Cards]]\|[[List of International Cards/ZH\|List of Chinese Cards]]}}		{{NavBar\|List of FOTR Foils\|[[List of International Cards\|International Card List Index]]\|[[List of International Cards/PT\|List of Portuguese Cards]]\|[[List of International Cards/ZH\|List of Chinese Cards]]}}

	Below are the subpages for each set for this language.		Below are the subpages for each set for this language.

Teltura: Created page with "{{NavBar|List of FOTR Foils|International Card List Index|List of Portuguese Cards|List of International C..."

2022-04-14T18:39:21Z

Created page with "{{NavBar|List of FOTR Foils|International Card List Index|List of Portuguese Cards|List of International C..."

New page

{{NavBar|List of FOTR Foils|[[List of International Cards|International Card List Index]]|[[List of International Cards/ZH|List of Portuguese Cards]]|[[List of International Cards/ZH|List of Chinese Cards]]}}

Below are the subpages for each set for this language.

== Nonfoil ==

* [[List of International Cards/ZH/Promotional]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '0'}}''')
* [[List of International Cards/ZH/The Fellowship of the Ring]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '1'}}''')

== Foil ==

* [[List of International Cards/ZH/Promotional/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '0'}}''')
* [[List of International Cards/ZH/The Fellowship of the Ring/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('ZH') AND C.SetNum = '1'}}''')

== TOTALS ==
'''Non-Foil''': {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=CR.ImageFilename
|where= CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
|format=template
|template=ImageExistCount
|limit=3000
}}|,}} / {{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=COUNT(*)
|where= CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}}

'''Foil''': {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=CR.ImageFilename
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
|format=template
|template=ImageExistCount
|limit=3000
}}|,}} / {{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=COUNT(*)
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}}

<big>'''Total''': {{#number_format: {{#expr: {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=CR.ImageFilename
|where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
|format=template
|template=ImageExistCount
|limit=3000
}}|,}} / {{formatnum:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=COUNT(*)
|where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('ZH')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}} * 100 |R
}} | 0 }} }}% COMPLETE</big>