The Fellowship of the Ring/Thumbs - Revision history

Teltura at 08:49, 12 February 2022

2022-02-12T08:49:33Z

@@ Line 7: / Line 7: @@
 = Standard Cards =
-{{#cargo_query:tables=Cards=C,CardReleases=CR
+{{ThumbnailTable
-|join on=C.ID = CR.ID
+|filter= C.SetNum = 1  AND C.Subset = 'S'
-|fields=CR.ID=CardID
+|sort= C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
 }}
 = Oversized Cards =
-{{#cargo_query:tables=Cards=C,CardReleases=CR
+{{ThumbnailTable
-|join on=C.ID = CR.ID
+|filter= C.SetNum = 1 AND C.Subset = 'M'
-|fields=CR.ID=CardID
+|sort=CR.ID, C.CardNum, CR._rowID
 }}
 = Tengwar Anthology =
-{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=ECR
+{{TranslationThumbnailTable
-|join on=C.ID = CR.BaseCardID,C.ID = ECR.ID
+|langcode= TW
-|fields=CR.ID=CardID
+|filter= C.SetNum = 1 AND CR.LanguageCode = 'TW'
-,IFNULL(IFNULL(ECR.FormattedGameText, ECR.GameText),'')=GameText
+|sort=CR.ID, C.CardNum, CR._rowID
 }}

Teltura at 06:04, 12 November 2021

2021-11-12T06:04:23Z

← Older revision		Revision as of 06:04, 12 November 2021
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{NavBar\|Fellowship of the Ring ~~Index~~\| [[Main Page]]\|[[Promotional ~~Index~~/~~Full~~\|Promotional ~~Index~~]]\|[[Mines of Moria ~~Index~~/~~Full~~\|Mines of Moria ~~Index~~]]}}		{{NavBar\|Fellowship of the Ring/Thumbs\| [[Main Page]]\|[[Promotional/Thumbs\|Promotional]]\|[[Mines of Moria/Thumbs\|Mines of Moria]]}}
	{{SetTabs}}		{{SetTabs}}

	~~Here you will find every card in the [[Fellowship of the Ring]] set. Please see that page for additional information.~~

	= Standard Cards =		= Standard Cards =

Teltura: Teltura moved page The Fellowship of the Ring Index/Thumbs to The Fellowship of the Ring/Thumbs without leaving a redirect

2021-11-12T05:04:20Z

Teltura moved page The Fellowship of the Ring Index/Thumbs to The Fellowship of the Ring/Thumbs without leaving a redirect

← Older revision		Revision as of 05:04, 12 November 2021
(No difference)

Teltura: Teltura moved page Fellowship of the Ring Index/Thumb to The Fellowship of the Ring Index/Thumbs without leaving a redirect

2021-11-12T05:03:01Z

Teltura moved page Fellowship of the Ring Index/Thumb to The Fellowship of the Ring Index/Thumbs without leaving a redirect

← Older revision		Revision as of 05:03, 12 November 2021
(No difference)

Teltura: Teltura moved page Fellowship of the Ring Index/Full to Fellowship of the Ring Index/Thumb

2021-11-12T04:32:46Z

Teltura moved page Fellowship of the Ring Index/Full to Fellowship of the Ring Index/Thumb

← Older revision	Revision as of 04:32, 12 November 2021
(No difference)

Teltura at 01:54, 10 November 2021

2021-11-10T01:54:38Z

← Older revision		Revision as of 01:54, 10 November 2021
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{NavBar\|Fellowship of the Ring Index\| [[Main Page]]\|[[Promotional Index]]\|[[Mines of Moria Index]]}}		{{NavBar\|Fellowship of the Ring Index\| [[Main Page]]\|[[Promotional Index/Full\|Promotional Index]]\|[[Mines of Moria Index/Full\|Mines of Moria Index]]}}
	{{SetTabs}}		{{SetTabs}}

Teltura: Created page with "NOTOC {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

2021-11-10T01:53:33Z

Created page with "__NOTOC__ {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

New page

__NOTOC__
{{NavBar|Fellowship of the Ring Index| [[Main Page]]|[[Promotional Index]]|[[Mines of Moria Index]]}}
{{SetTabs}}

Here you will find every card in the [[Fellowship of the Ring]] set. Please see that page for additional information.

= Standard Cards =

{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'S'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}

= Oversized Cards =

{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'M'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}

= Tengwar Anthology =

{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=ECR
|join on=C.ID = CR.BaseCardID,C.ID = ECR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(ECR.FormattedGameText, ECR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,''=CardSubtype
,ECR.Title=Title
,ECR.Subtitle=Subtitle
,ECR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND CR.LanguageCode = 'TW'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}