Promotional/Thumbs: Difference between revisions

From LOTR-TCG Wiki
No edit summary
(Converting to use new set tables)
Line 3: Line 3:
{{SetTabs}}
{{SetTabs}}


= Standard Promo Series =


 
{{ListTable
{{#cargo_query:tables=Cards=C,CardReleases=CR
|filter= C.SetNum = 0 AND C.Rarity = 'P'
|join on=C.ID = CR.ID
|sort= {{StandardSort}}
|fields=CR.ID=CardID
|columns=3
,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 = 0 AND C.Rarity = 'P'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}


= Oversized Cards =
= Oversized Cards =


{{#cargo_query:tables=Cards=C,CardReleases=CR
{{ListTable
|join on=C.ID = CR.ID
|filter= C.SetNum = 0 AND C.Subset = 'M'
|fields=CR.ID=CardID
|sort= {{StandardSort}}
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|columns=3
,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 = 0 AND C.Subset = 'M'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}


Line 71: Line 22:
= Joke Cards =
= Joke Cards =


{{#cargo_query:tables=Cards=C,CardReleases=CR
{{ListTable
|join on=C.ID = CR.ID
|filter= C.SetNum = 0 AND C.Subset = 'J'
|fields=CR.ID=CardID
|sort= {{StandardSort}}
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|columns=3
,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 = 0 AND C.Subset = 'J'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}


= DGMA Tournament Prizes =
= DGMA Tournament Prizes =


{{#cargo_query:tables=Cards=C,CardReleases=CR
{{ListTable
|join on=C.ID = CR.ID
|filter= C.SetNum = 0 AND C.Subset = 'D'
|fields=CR.ID=CardID
|sort= {{StandardSort}}
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|columns=3
,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 = 0 AND C.Subset = 'D'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}


Line 136: Line 39:
= LOTRO Digital League Cards =
= LOTRO Digital League Cards =


{{#cargo_query:tables=Cards=C,CardReleases=CR
{{ListTable
|join on=C.ID = CR.ID
|filter= C.SetNum = 0 AND C.Subset = 'L'
|fields=CR.ID=CardID
|sort= {{StandardSort}}
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|columns=3
,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 = 0 AND C.Subset = 'L'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}


Line 169: Line 48:
= World's Apart LOTRO Digital Cards =
= World's Apart LOTRO Digital Cards =


{{#cargo_query:tables=Cards=C,CardReleases=CR
{{ListTable
|join on=C.ID = CR.ID
|filter= C.SetNum = 0 AND C.Subset = 'W'
|fields=CR.ID=CardID
|sort= {{StandardSort}}
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|columns=3
,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 = 0 AND C.Subset = 'W'
|order by={{StandardSort}}
|limit=400
|intro=<!--
-->{{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
}}
}}

Revision as of 09:30, 9 January 2022


Back to Main_Page 		The Fellowship of the Ring
Set Info
Index
Thumbs
Product

Standard Promo Series


Oversized Cards



Joke Cards


DGMA Tournament Prizes



LOTRO Digital League Cards



World's Apart LOTRO Digital Cards


Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=Promotional/Thumbs&oldid=99992"