Member selection - AFF instructors - own
Member selections
Name:
AFF instructors - own
Active:
No
Owned by system:
No
Selection SQL
| sELECT InternalNo FROM Member WHERE InternalNo IN (SELECT InternalNo FROM Memberinstruct WHERE InstructType='AFF') AND Year>=2025 AND Club='DEMO'; |
Members (45)
| Name | Member no | License info |
|---|---|---|
| Albus Dumbledore | 2125 | 2025 / DEMO / D / HM AFF |
| Ben Grimm | 2112 | 2025 / DEMO / D / HL FL |
| Bertha Jorkins | 2130 | 2025 / DEMO / D / HM AFF |
| Bill Weasley | 2143 | 2025 / DEMO / D / HM AFF |
| Black Widow | 2113 | 2025 / DEMO / D / T |
| Blaise Zabini | 2145 | 2025 / DEMO / D / HM AFF |
| Bob Ogden | 2135 | 2025 / DEMO / D / HM AFF |
| Carol Danvers | 2114 | 2025 / DEMO / D / T |
| Corban Yaxley | 2144 | 2025 / DEMO / D / HM AFF |
| Dewey Duck | 2120 | 2025 / DEMO / D / HM AFF |
| Dolores Jane Umbridge | 2141 | 2025 / DEMO / D / HM AFF |
| Fantomen Vålnad | 2106 | 2025 / DEMO / D / T |
| Gerald 'Gary' Wilson | 2103 | 2025 / DEMO / D / HM AFF |
| Guran Hövding | 2108 | 2025 / DEMO / D / HM AFF |
| Hannah Abbott | 2122 | 2025 / DEMO / D / HM AFF |
| Hermione Granger | 2128 | 2025 / DEMO / D / HM AFF |
| Huey Duck | 2119 | 2025 / DEMO / D / HM AFF |
| Irma Pince | 2136 | 2025 / DEMO / D / HM AFF |
| Jennifer Walters | 2117 | 2025 / DEMO / D / T |
| Jesper Löfberg | 770 | 2025 / DEMO / D / AFF FL HL HM T |
| Johnny Storm | 2111 | 2025 / DEMO / D / HM AFF |
| Kamala Khan | 2115 | 2025 / DEMO / D / FL T |
| Louie Duck | 2121 | 2025 / DEMO / D / HM AFF |
| Marietta Edgecombe | 2126 | 2025 / DEMO / D / HM AFF |
| Mr Crabs | 2104 | 2025 / DEMO / D / HM AFF |
| Narcissa Malfoy | 2133 | 2025 / DEMO / D / HM AFF |
| Neville Longbottom | 2132 | 2025 / DEMO / D / HM AFF |
| Patricia 'Hellcat' Walker | 2118 | 2025 / DEMO / D / HM AFF |
| Patrick Star | 2101 | 2025 / DEMO / D / HM AFF |
| Penelope Clearwater | 2124 | 2025 / DEMO / D / HM AFF |
| Quirinus Quirrell | 2137 | 2025 / DEMO / D / HM HL FL |
| Reed Richards | 2109 | 2025 / DEMO / D / HM AFF |
| Rowena Ravenclaw | 2138 | 2025 / DEMO / D / HM AFF |
| Rubeus Hagrid | 2129 | 2025 / DEMO / D / HM AFF |
| Salazar Slytherin | 2139 | 2025 / DEMO / D / HM AFF |
| Sandy Cheeks | 2105 | 2025 / DEMO / D / HM AFF |
| Scarlet Witch | <12345> | 2025 / DEMO / D / T |
| Seamus Finnigan | 2127 | 2025 / DEMO / D / HM AFF |
| Sirius Black | 2123 | 2025 / DEMO / D / HM AFF |
| SpongeBob SquarePants | 2100 | 2025 / DEMO / D / HM AFF |
| Squidward Tentacles | 2102 | 2025 / DEMO / D / HM AFF |
| Susan Storm | 2110 | 2025 / DEMO / D / HM AFF |
| Ted Tonks | 2140 | 2025 / DEMO / D / HM AFF |
| Theodore Nott | 2134 | 2025 / DEMO / D / HM AFF |
| Viktor Krum | 2131 | 2025 / DEMO / D / HM AFF |