Template:Roster/newt: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| Line 4: | 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 14: | 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 24: | 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 34: | 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= | ||
