Latest revision |
Your text |
Line 22: |
Line 22: |
| ,CR.SiteNum | | ,CR.SiteNum |
| ,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo | | ,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo |
| |where= C.SetNum = 30 AND C.Rarity <> 'P' | | |where= C.SetNum = 30 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
| |
| }}
| |
| | |
| | |
| = Championship Prizes =
| |
| | |
| {{#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 = 30 AND C.Rarity = 'P'
| |
| |order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID | | |order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID |
| |limit=400 | | |limit=400 |