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

From A3! Wiki
m
m
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,' ',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,' ',Charas.surname,'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi2="{{{chibi|}}}"
|fields=CONCAT('[[File:',Card_Files.icon1,'|link=Cards/',Charas.firstname,' ',Charas.surname,'/',Cards.cardname,'|50px]] ')
 
|where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi1="{{{chibi|}}}" OR Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi2="{{{chibi|}}}"
 
 
|default=
 
|default=
 
|delimiter=
 
|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=027}}
  
 
</noinclude>
 
</noinclude>

Revision as of 04:08, 29 August 2018


(Banquet of Blooming) Sakyo Furuichi Serious SR Icon Unbloomed.png (MANKAI Encore) Sakyo Furuichi Serious SSR Icon Unbloomed.png (Tales of Chivalry Ginji the Wanderer) Sakyo Furuichi Comedy N Icon Unbloomed.png (Trajectory of Blooming) Sakyo Furuichi Action SR Icon Unbloomed.png (Heart Drenched in the Night Rain) Sakyo Furuichi Serious SSR Icon Bloomed.png