List of International Cards/DE - Revision history

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

2022-04-14T19:03:07Z

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

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

	* [[List of International Cards/DE/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '0'}}''')		* [[List of International Cards/DE/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '0'}}''')
	* [[List of International Cards/DE/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '1'}}''')		* [[List of International Cards/DE/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '1'}}''')
	* [[List of International Cards/DE/Mines of Moria]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '2'}}''')		* [[List of International Cards/DE/Mines of Moria]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '2'}}''')
	* [[List of International Cards/DE/Realms of the Elf-lords]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '3'}}''')		* [[List of International Cards/DE/Realms of the Elf-lords]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '3'}}''')
	* [[List of International Cards/DE/The Two Towers]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '4'}}''')		* [[List of International Cards/DE/The Two Towers]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '4'}}''')
	* [[List of International Cards/DE/Battle of Helm's Deep]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '5'}}''')		* [[List of International Cards/DE/Battle of Helm's Deep]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '5'}}''')
	* [[List of International Cards/DE/Ents of Fangorn]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '6'}}''')		* [[List of International Cards/DE/Ents of Fangorn]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '6'}}''')
	* [[List of International Cards/DE/The Return of the King]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '7'}}''' )		* [[List of International Cards/DE/The Return of the King]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '7'}}''' )
	* [[List of International Cards/DE/Siege of Gondor]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '8'}}''' )		* [[List of International Cards/DE/Siege of Gondor]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '8'}}''' )
	* [[List of International Cards/DE/Reflections]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '9'}}''')		* [[List of International Cards/DE/Reflections]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '9'}}''')
	* [[List of International Cards/DE/Mount Doom]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '10'}}''')		* [[List of International Cards/DE/Mount Doom]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '10'}}''')
	* [[List of International Cards/DE/Shadows]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '11'}}''')		* [[List of International Cards/DE/Shadows]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '11'}}''')
	* [[List of International Cards/DE/Black Rider]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/DE/Black Rider]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/DE/Bloodlines]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/DE/Bloodlines]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/DE/Expanded Middle-earth]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')		* [[List of International Cards/DE/Expanded Middle-earth]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')

	== Foil ==		== Foil ==
Line 44:		Line 44:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 55:		Line 55:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 86:		Line 86:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 97:		Line 97:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura at 18:20, 14 April 2022

2022-04-14T18:20:14Z

← Older revision		Revision as of 18:20, 14 April 2022
Line 65:		Line 65:
	\|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',) AND CR.LanguageCode IN ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 76:		Line 76:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=COUNT(*)		\|fields=COUNT(*)
	\|where= CR.Subset IN ('F', 'O', 'A',) AND CR.LanguageCode IN ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura at 18:18, 14 April 2022

2022-04-14T18:18:36Z

← Older revision		Revision as of 18:18, 14 April 2022
Line 65:		Line 65:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A',) AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 76:		Line 76:
	\|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 ('TG', 'DE')		\|where= CR.Subset IN ('F', 'O', 'A',) AND CR.LanguageCode IN ('TG', 'DE')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura: Creating DE international card list

2022-04-14T18:16:13Z

Creating DE international card list

New page

{{NavBar|List of FOTR Foils|[[List of International Cards|International Card List Index]]||[[List of International Cards/FR|List of French Cards]]}}

Below are the subpages for each set for this language.

== Nonfoil ==

* [[List of International Cards/DE/Promotional]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '0'}}''')
* [[List of International Cards/DE/The Fellowship of the Ring]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '1'}}''')
* [[List of International Cards/DE/Mines of Moria]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '2'}}''')
* [[List of International Cards/DE/Realms of the Elf-lords]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '3'}}''')
* [[List of International Cards/DE/The Two Towers]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '4'}}''')
* [[List of International Cards/DE/Battle of Helm's Deep]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '5'}}''')
* [[List of International Cards/DE/Ents of Fangorn]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '6'}}''')
* [[List of International Cards/DE/The Return of the King]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '7'}}''' )
* [[List of International Cards/DE/Siege of Gondor]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '8'}}''' )
* [[List of International Cards/DE/Reflections]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '9'}}''')
* [[List of International Cards/DE/Mount Doom]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '10'}}''')
* [[List of International Cards/DE/Shadows]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '11'}}''')
* [[List of International Cards/DE/Black Rider]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')
* [[List of International Cards/DE/Bloodlines]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')
* [[List of International Cards/DE/Expanded Middle-earth]] ('''{{CardCountTotal|filter=CR.Subset IN ('S', 'M') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')

== Foil ==

* [[List of International Cards/DE/Promotional/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '0'}}''')
* [[List of International Cards/DE/The Fellowship of the Ring/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '1'}}''')
* [[List of International Cards/DE/Mines of Moria/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '2'}}''')
* [[List of International Cards/DE/Realms of the Elf-lords/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '3'}}''')
* [[List of International Cards/DE/The Two Towers/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '4'}}''')
* [[List of International Cards/DE/Battle of Helm's Deep/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '5'}}''')
* [[List of International Cards/DE/Ents of Fangorn/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '6'}}''')
* [[List of International Cards/DE/The Return of the King/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '7'}}''' )
* [[List of International Cards/DE/Siege of Gondor/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '8'}}''' )
* [[List of International Cards/DE/Reflections/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '9'}}''')
* [[List of International Cards/DE/Mount Doom/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '10'}}''')
* [[List of International Cards/DE/Shadows/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '11'}}''')
* [[List of International Cards/DE/Black Rider/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')
* [[List of International Cards/DE/Bloodlines/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')
* [[List of International Cards/DE/Expanded Middle-earth/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')

== 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 ('TG', 'DE')
|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 ('TG', 'DE')
|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 ('S', 'M') AND CR.LanguageCode IN ('TG', 'DE')
|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 ('TG', 'DE')
|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 ('TG', 'DE')
|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 ('TG', 'DE')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}} * 100 |R
}} | 0 }} }}% COMPLETE</big>