Template:Roster/newt: Difference between revisions

From Absit Omen Lexicon
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly>|{{#ask: [[Category:Gryffindor {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
 
|{{#ask: [[Category:Hufflepuff {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
<includeonly>
|{{#ask: [[Category:Ravenclaw {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
|{{#cargo_query:
|{{#ask: [[Category:Slytherin {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
tables=Characters,Classes
|{{#ask: [[Category:Beauxbatons Academy {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
|join on=Characters._pageName=Classes._pageName
|{{#ask: [[Category:Durmstrang Institute {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}
|fields=Characters._pageName, Characters.status, Classes.school_year, Classes.newt, Classes.elective
|{{#ask: [[Category:Salem Witches Institute {{{year}}} Year]] [[status::active||inactive||secondary||npc]] [[enrolled in::{{{class}}}]]|? status|sort=status, |order=ascending, ascending|format=template|template=activity|introtemplate=activity/before|outrotemplate=activity/after}}</includeonly>
|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=Character.status,Character.surname,Character.given_name
|default=
|format=template
|template=Roster/format
}}
|{{#cargo_query:
tables=Characters,Classes
|join on=Characters._pageName=Classes._pageName
|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}}}"
|order by=Character.status,Character.surname,Character.given_name
|default=
|format=template
|template=Roster/format
}}
||{{#cargo_query:
tables=Characters,Classes
|join on=Characters._pageName=Classes._pageName
|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}}}"
|order by=Character.status,Character.surname,Character.given_name
|default=
|format=template
|template=Roster/format
}}
|{{#cargo_query:
tables=Characters,Classes
|join on=Characters._pageName=Classes._pageName
|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}}}"
|order by=Character.status,Character.surname,Character.given_name
|default=
|format=template
|template=Roster/format
}}</includeonly>

Revision as of 00:40, 3 December 2015


Retrieved from "https://absitomen.com/wiki/index.php?title=Template:Roster/newt&oldid=47274"