Template:Roster/newt: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly> | ||
|{{#cargo_query: | |{{#cargo_query: | ||
| Line 5: | Line 4: | ||
|join on=Classes._pageName = Characters._pageName | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where=Characters.house="Gryffindor" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND | |where=Characters.house="Gryffindor" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by=Characters.status, Characters.surname, Characters.given_name | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
| Line 15: | Line 14: | ||
|join on=Classes._pageName = Characters._pageName | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where=Characters.house="Hufflepuff" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND | |where=Characters.house="Hufflepuff" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by=Characters.status, Characters.surname, Characters.given_name | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
| Line 25: | Line 24: | ||
|join on=Classes._pageName = Characters._pageName | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where=Characters.house="Ravenclaw" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND | |where=Characters.house="Ravenclaw" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by=Characters.status, Characters.surname, Characters.given_name | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
| Line 35: | Line 34: | ||
|join on=Classes._pageName = Characters._pageName | |join on=Classes._pageName = Characters._pageName | ||
|fields=Characters._pageName, Characters.status | |fields=Characters._pageName, Characters.status | ||
|where=Characters.house="Slytherin" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND | |where=Characters.house="Slytherin" AND Characters.school_year="{{{1}}}" AND Characters.status<>"retired" AND Classes.newt HOLDS "{{{2}}}" | ||
|order by=Characters.status, Characters.surname, Characters.given_name | |order by=Characters.status, Characters.surname, Characters.given_name | ||
|default= | |default= | ||
