Template:Roster/newt: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| Line 4: | Line 4: | ||
tables=Characters,Classes | tables=Characters,Classes | ||
|join on=Characters._pageName=Classes._pageName | |join on=Characters._pageName=Classes._pageName | ||
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective | |fields=Characters._pageName=Page, Characters.status=Status, Classes.school_year=Year, Classes.newt=NEWT, Classes.elective=ELECTIVE | ||
|where= | |where=Year="{{{1}}}" AND Status<>"retired" AND Characters.house="Gryffindor" AND (NEWT HOLDS "{{{2}}}" OR ELECTIVE HOLDS "{{{2}}}" | ||
|order by= | |order by=Status,surname,given_name | ||
|default= | |default= | ||
|format=template | |format=template | ||
Revision as of 00:45, 3 December 2015
