List of International Cards/EL - Revision history

Teltura at 02:31, 17 April 2022

2022-04-17T02:31:16Z

← Older revision		Revision as of 02:31, 17 April 2022
Line 7:		Line 7:

	== Nonfoil ==		== Nonfoil ==
	{{~~NavBar~~\|\|~~[[List of International Cards/ZH\|Chinese Card Index]]\|\|[[List of International Cards/ZH/The Fellowship of the Ring/Foil\|Chinese Set 1 - FOTR]]~~}}		{{CardList\|SetNum=0\|Lang='EL'}}

	~~{{CardList\|SetNum=0\|Lang='EL'}}~~


	== Foil ==		== Foil ==

	{{FoilList\|SetNum=0\|Lang='EL'}}		{{FoilList\|SetNum=0\|Lang='EL'}}

Teltura at 02:30, 17 April 2022

2022-04-17T02:30:55Z

← Older revision		Revision as of 02:30, 17 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 Chinese Cards]]\|[[List of International Cards/HU\|List of Hungarian Cards]]}}		{{NavBar\|List of FOTR Foils\|[[List of International Cards\|International Card List Index]]\|[[List of International Cards/ZH\|List of Chinese Cards]]\|[[List of International Cards/HU\|List of Hungarian Cards]]}}

	~~Below are~~ the ~~subpages for~~ each ~~set~~ for ~~this language~~.		'''''Use the link below each card image to see the main article for that card, or click/tap on the card image to go straight to the upload page to replace it with a new foil image.'''''

			'''If you have physical proof (i.e. a photo) of a card that is not listed below, please contact ketura on the [https://lotrtcgpc.net/discord PC Discord] ASAP.'''


	== Nonfoil ==		== Nonfoil ==
			{{NavBar\|\|[[List of International Cards/ZH\|Chinese Card Index]]\|\|[[List of International Cards/ZH/The Fellowship of the Ring/Foil\|Chinese Set 1 - FOTR]]}}

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


	== Foil ==		== Foil ==

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

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

2022-04-14T19:03:40Z

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

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

	* [[List of International Cards/EL/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('EL') AND C.SetNum = '0'}}''')		* [[List of International Cards/EL/Promotional]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('EL') AND C.SetNum = '0'}}''')
	* [[List of International Cards/EL/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S~~', 'M~~') AND CR.LanguageCode IN ('EL') AND C.SetNum = '1'}}''')		* [[List of International Cards/EL/The Fellowship of the Ring]] ('''{{CardCountTotal\|filter=CR.Subset IN ('S') AND CR.LanguageCode IN ('EL') 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 ('EL')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('EL')
	\|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 ('EL')		\|where= CR.Subset IN ('S') AND CR.LanguageCode IN ('EL')
	\|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 ('EL')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EL')
	\|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 ('EL')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EL')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura: Creating EL international card list

2022-04-14T18:41:10Z

Creating EL international card list

New page

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

Below are the subpages for each set for this language.

== Nonfoil ==

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

== Foil ==

* [[List of International Cards/EL/Promotional/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EL') AND C.SetNum = '0'}}''')
* [[List of International Cards/EL/The Fellowship of the Ring/Foil]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EL') 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 ('EL')
|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 ('EL')
|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 ('EL')
|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 ('EL')
|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 ('EL')
|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 ('EL')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}} * 100 |R
}} | 0 }} }}% COMPLETE</big>