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=Characters.status,Characters.surname,Characters.given_name
|order by=status,surname,given_name
|default=
|default=
|format=template
|format=template

Revision as of 00:44, 3 December 2015