Template:Roster/newt: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly> | ||
|{{#cargo_query: | |{{#cargo_query: | ||
tables=Characters | tables=Classes,Characters | ||
|join on= | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where= | |where=Characters.house="Gryffindor" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
| Line 12: | Line 11: | ||
}} | }} | ||
|{{#cargo_query: | |{{#cargo_query: | ||
tables=Characters | tables=Classes,Characters | ||
|join on= | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where= | |where=Characters.house="Hufflepuff" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
|template=Roster/format | |template=Roster/format | ||
}} | }} | ||
|{{#cargo_query: | |||
tables=Characters | tables=Classes,Characters | ||
|join on= | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where= | |where=Characters.house="Ravenclaw" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
| Line 32: | Line 31: | ||
}} | }} | ||
|{{#cargo_query: | |{{#cargo_query: | ||
tables=Characters | tables=Classes,Characters | ||
|join on= | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where= | |where=Characters.house="Slytherin" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
|template=Roster/format | |template=Roster/format | ||
}}</includeonly> | }}</includeonly> | ||
