Difference between revisions of "User:Fimbulvetr/Sandbox 3"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 1: | Line 1: | ||
{| cellpadding="10" style="text-align:center; background-color: #fff; margin: auto;" class="wikitable" | {| cellpadding="10" style="text-align:center; background-color: #fff; margin: auto;" class="wikitable" | ||
| − | ! 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}}}}"|[[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]] |
|- | |- | ||
|style="width:25em"|<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= | + | |fields=firstname |
| − | |order by= | + | |order by=firstname ASC |
| − | |where=troupe="Spring" | + | |where=troupe="Spring" AND maintroupe=1 |
|more results text= | |more results text= | ||
|no html | |no html | ||
| Line 13: | Line 13: | ||
|<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= | + | |fields=firstname |
| − | |order by= | + | |order by=firstname ASC |
| − | |where=troupe="Summer" | + | |where=troupe="Summer" AND maintroupe=1 |
|more results text= | |more results text= | ||
|no html}} | |no html}} | ||
| Line 21: | Line 21: | ||
|<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= | + | |fields=firstname |
| − | |order by= | + | |order by=firstname ASC |
| − | |where=troupe="Autumn" | + | |where=troupe="Autumn" AND maintroupe=1 |
|more results text= | |more results text= | ||
|no html}} | |no html}} | ||
| Line 29: | Line 29: | ||
|<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= | + | |fields=firstname |
| − | |order by= | + | |order by=firstname ASC |
| − | |where=troupe="Winter" | + | |where=troupe="Winter" AND maintroupe=1 |
|more results text= | |more results text= | ||
|no html}} | |no html}} | ||
|} | |} | ||
Revision as of 08: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.
|
