User:Cease/Temp3: Difference between revisions

From LOTR-TCG Wiki
(test)
 
No edit summary
Line 1: Line 1:
{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS
{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID,CS.ID = C.SetNum
|join on=C.ID = CR.ID
|fields=CR.ID=CardID
|fields=
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '|', CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
,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=CR.GameText LIKE '%Aragorn%'  
|where=CR.GameText LIKE '%Aragorn%'  
|order by=CS.IsOfficial DESC, C.Culture, {{StandardSort}}
|order by={{StandardSort}}
|limit=400
|limit=400
|intro=<!--
|format=ul
-->{{{!}} class="wikitable" style="margin:2px"
|columns=3
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=&#x200B;
{{!}}}
|default=
|delimiter=
|no html
}}
}}

Revision as of 07:49, 2 January 2022

Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=User:Cease/Temp3&oldid=99684"