Difference between revisions of "Template:Play Cast/Cards"

From A3! Wiki
(Created page with "<includeonly>{{#cargo_query:tables=Card_Chibis,Card_Files,Cards,Charas |join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_...")
 
m
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly>{{#cargo_query:tables=Card_Chibis,Card_Files,Cards,Charas
+
<includeonly>{{#cargo_compound_query:tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon1,'|link=Cards/',Charas.firstname,IFNULL(CONCAT(' ',Charas.surname),''),'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi1="{{{chibi|}}}"
|join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number
+
|tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon2,'|link=Cards/',Charas.firstname,IFNULL(CONCAT(' ',Charas.surname),''),'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi2="{{{chibi|}}}"
|fields=CONCAT('[[File:',Card_Files.icon1,'|33px]] ', Cards.cardname)
 
|where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi1="{{{chibi|}}}" OR Card_Chibis.chibi2="{{{chibi|}}}"
 
 
|default=
 
|default=
 +
|delimiter=
 +
|order by=Cards.number ASC
 
|limit=1000}}</includeonly><noinclude>
 
|limit=1000}}</includeonly><noinclude>
  
{{Play Cast/Cards|chara=Sakuya|chibi=001}}
+
{{Play Cast/Cards|chara=Sakyo|chibi=037}}
 +
{{Play Cast/Cards|chara=Guy|chibi=005}}
  
 
</noinclude>
 
</noinclude>

Latest revision as of 12:31, 19 November 2018


(Trajectory of Blooming) Sakyo Furuichi Action SR Icon Bloomed.png (Named Color) Guy Comedy SR Icon Unbloomed.png (Premonition of Blooming) Guy Comedy SR Icon Unbloomed.png (Rehearsal) Guy Comedy R Icon Unbloomed.png (Together with a Friend's Incarnation) Guy Serious SR Icon Unbloomed.png