Template:Roster/newt: Difference between revisions

@@ Line 2: / Line 2: @@
 <includeonly>
 |{{#cargo_query:
-tables=Characters,Classes
+tables=Classes
-|join on=Characters._pageName=Classes._pageName
+|fields=_pageName
-|fields=Characters._pageName=Page, Characters.status=Status, Classes.school_year=Year, Classes.newt=NEWT, Classes.elective=ELECTIVE
+|where=school_year="{{{1}}}" AND Status<>"retired" AND (newt HOLDS "{{{2}}}" OR elective HOLDS "{{{2}}}"
-|where=Year="{{{1}}}" AND Status<>"retired" AND Characters.house="Gryffindor" AND (NEWT HOLDS "{{{2}}}" OR ELECTIVE HOLDS "{{{2}}}"
 |order by=Status,surname,given_name
 |default=

Anonymous