Template:Roster/newt: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| Line 6: | Line 6: | ||
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | |fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | ||
|where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Gryffindor" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | |where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Gryffindor" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status,Characters.surname,Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
| Line 16: | Line 16: | ||
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | |fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | ||
|where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Hufflepuff" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | |where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Hufflepuff" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status,Characters.surname,Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
| Line 26: | Line 26: | ||
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | |fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | ||
|where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Ravenclaw" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | |where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Ravenclaw" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | ||
|order by= | |order by=Characters.status,Characters.surname,Characters.given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
| Line 36: | Line 36: | ||
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | |fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | ||
|where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Slytherin" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective HOLDS "{{{2}}}" | |where=Classes.school_year="{{{1}}}" AND Characters.status<>"retired" AND Characters.house="Slytherin" AND (Classes.newt HOLDS "{{{2}}}" OR Classes.elective 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> | ||
Revision as of 00:43, 3 December 2015
