Difference between revisions of "User:Fimbulvetr/Sandbox 3"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 2: | Line 2: | ||
! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupe)=count|group by=troupe|order by=count DESC|more results text=|no html|limit=1}}}}"|[[Character Hub|Characters]] | ! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupe)=count|group by=troupe|order by=count DESC|more results text=|no html|limit=1}}}}"|[[Character Hub|Characters]] | ||
|- | |- | ||
| − | |<div style="float:left;padding-right:5px;">[[File:Spring troupe.png|30px]]</div> '''Spring:''' | + | |style="width:25em"|<div style="float:left;padding-right:5px;">[[File:Spring troupe.png|30px]]</div> '''Spring:''' |
{{#cargo_query:tables=Characters | {{#cargo_query:tables=Characters | ||
|fields=firstname | |fields=firstname | ||
| − | |order by=troupeorder | + | |order by=troupeorder ASC |
|where=troupe="Spring" AND maincast=1 | |where=troupe="Spring" AND maincast=1 | ||
|more results text= | |more results text= | ||
|no html | |no html | ||
| − | |format= | + | |format=ul}} |
| − | |||
|- | |- | ||
|<div style="float:left;padding-right:5px;">[[File:Summer troupe.png|30px]]</div> '''Summer:''' | |<div style="float:left;padding-right:5px;">[[File:Summer troupe.png|30px]]</div> '''Summer:''' | ||
{{#cargo_query:tables=Characters | {{#cargo_query:tables=Characters | ||
|fields=firstname | |fields=firstname | ||
| − | |order by=troupeorder | + | |order by=troupeorder ASC |
|where=troupe="Summer" AND maincast=1 | |where=troupe="Summer" AND maincast=1 | ||
|more results text= | |more results text= | ||
| − | |no html | + | |no html}} |
| − | |||
| − | |||
|- | |- | ||
|<div style="float:left;padding-right:5px;">[[File:Autumn troupe.png|30px]]</div> '''Autumn:''' | |<div style="float:left;padding-right:5px;">[[File:Autumn troupe.png|30px]]</div> '''Autumn:''' | ||
{{#cargo_query:tables=Characters | {{#cargo_query:tables=Characters | ||
|fields=firstname | |fields=firstname | ||
| − | |order by=troupeorder | + | |order by=troupeorder ASC |
|where=troupe="Autumn" AND maincast=1 | |where=troupe="Autumn" AND maincast=1 | ||
|more results text= | |more results text= | ||
| − | |no html | + | |no html}} |
| − | |||
| − | |||
|- | |- | ||
|<div style="float:left;padding-right:5px;">[[File:Winter troupe.png|30px]]</div> '''Winter:''' | |<div style="float:left;padding-right:5px;">[[File:Winter troupe.png|30px]]</div> '''Winter:''' | ||
{{#cargo_query:tables=Characters | {{#cargo_query:tables=Characters | ||
|fields=firstname | |fields=firstname | ||
| − | |order by=troupeorder | + | |order by=troupeorder ASC |
|where=troupe="Winter" AND maincast=1 | |where=troupe="Winter" AND maincast=1 | ||
|more results text= | |more results text= | ||
| − | |no html | + | |no html}} |
| − | |||
| − | |||
|} | |} | ||
Revision as of 09:32, 8 October 2017
| Characters |
|---|
 Error: Table Characters not found.
|
 Error: Table Characters not found.
|
 Error: Table Characters not found.
|
 Error: Table Characters not found.
|
