Club Membership – Admin – Other

Lapsed Members

Lapsed Adults

Search:
Total: 11
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate Leftbudget
17/09/2021 Diana Dan
2018-09-11
90
06/09/2021 Stefano Conese
2019-04-30
06/20 20
25/02/2020 Elliott Quinn spr19
2018-01-10
04/19 65
25/02/2020 Mark Juniper spr19
2019-01-08
04/19 90
17/01/2020 Yun-Ju Lee
2018-09-13
90
15/08/2019 Kayleigh Hoang Trainee spr19. Gone to uni
2019-01-08
07/19 65
12/07/2019 Nicole Prowd
2018-09-11
12/18 90
12/07/2019 Nizaar Kinsella
2018-10-02
90
03/04/2019 Carol Nguyen
2018-05-15
07/18 0
28/09/2018 Jayne Jacob work pressure: retail
2018-01-09
07/18 90
17/09/2018 Francis Osborn
2018-05-17
90

Trainees

Search:
Total: 58
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate Leftbudget
27/02/2020 Katie Irving
2020-01-30
90
24/02/2020 Roberto Cervone Took out BF membership Sept 19. Needs refresh to Jan20
2019-09-03
90
23/01/2020 Saleem Wadee
2020-01-14
90
21/01/2020 Conor Naughton
2020-01-14
90
16/01/2020 Adam Wilkinson
2020-01-14
90
16/01/2020 Tim Maynard
2020-01-14
90
16/01/2020 Annaleise Cooke
2020-01-14
90
16/01/2020 Jibran Mirza
2020-01-09
90
15/01/2020 Virgil-Pai Janhirat
2020-01-09
90
15/01/2020 Cecile Clamaron
2020-01-09
90
15/01/2020 Ste Clough 09/19 is still interested, just work constraints
2019-04-23
90
15/01/2020 Stuart Hallifax
2020-01-14
90
15/01/2020 Emma Bockhop
2020-01-14
90
10/01/2020 Witold Lukaszewski
2020-01-09
90
10/01/2020 Agnieszka Marciszewska
2020-01-09
90
04/01/2020 Claire Cooper
2020-01-09
90
04/01/2020 Alberto Ferreira
2019-04-25
90
04/01/2020 Alvaro Gomez Missed the taster and wk1..
2019-08-07
90
04/01/2020 Nicola Belcher Confirmed for Sept19 (Sum19 but husband health issues so deferred until Sept19)
2019-04-26
90
04/01/2020 India Maddison Applying for Sept19
2019-09-03
90
04/01/2020 Haritha Alluri
2019-09-05
90
04/01/2020 Beatriz Liebe
2019-09-03
65
04/01/2020 Polina Wade
2019-09-05
90
04/01/2020 Niall Richards
2019-09-05
90
03/01/2020 William Morland
2020-01-14
90
03/01/2020 Callum McGuire
2020-01-14
90
02/01/2020 Jack McCormick McGuire
2020-01-14
90
02/01/2020 Megan Jenkins
2020-01-14
90
02/01/2020 Anna McCormick McGuire
2020-01-09
90
07/11/2019 Zena Khan Sum19 miss first session
2019-04-30
90
07/11/2019 Tony Baumgartner Sum19
2019-01-08
90
07/11/2019 Sean Drislane Summer 19
2019-04-30
90
07/11/2019 Joshua Mort Cannot attend summer taster. Funeral. May sign up anway
2019-04-30
90
07/11/2019 Kiran Perkins Sum19
2019-04-29
90
07/11/2019 Lucy Swarbreck
2019-04-30
90
07/11/2019 Collwyn Bevan
2019-02-19
60
04/09/2019 Sarah Bardell Sum19
2019-04-30
90
24/04/2019 Todd Gibson Jan19
2019-01-08
90
24/04/2019 Neo Negri Jan19
2019-01-08
90
24/04/2019 ANSI DENiZ RONA BAYILDIRAN Jan19
2019-01-01
90
17/01/2019 Vivian Göde
2018-09-11
90
17/01/2019 Phill Harris
2018-09-18
90
17/01/2019 Mary Martin Aut18 £50
2018-09-25
90
17/01/2019 Joanne Hollington
2018-09-11
90
17/01/2019 Holly Voysey
2018-08-11
90
17/01/2019 Bram Vanoirbeek
2018-09-11
90
17/01/2019 Ben Mulcahy Paid concession 1st term £40
2018-09-11
65
17/01/2019 Aurelia Wong Aut18 50
2018-09-18
90
13/09/2018 Kola Lawal
2018-04-20
50
13/09/2018 Conor Sheehan Summer 18
2018-05-01
90
13/09/2018 christine leech
2018-01-18
90
13/09/2018 Beatrice Vincent
2018-01-11
90
13/09/2018 Olivier Zongo S18
2018-04-17
90
13/09/2018 Louise Staunton Jan18/P1&2
2018-01-09
90
13/09/2018 Christopher Ross
2018-01-16
90
13/09/2018 Allan Taylor Jan18/P1&P2
2018-01-09
90
30/04/2018 Sonia Andrews-Okwum
2018-01-25
12/17 90
30/04/2018 Simon Skerratt-Williams
2018-01-18
12/17 90

Musketeers

Search:
Total: 27
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate Leftbudget
17/09/2021 Maya Liddell
2020-01-14
90
17/09/2021 Zara Barmby
2020-01-13
90
17/09/2021 William Bowes Fences at Eltham College
2019-01-15
90
17/09/2021 Sophie Bussell Taking exam break in Summer term. Hopes to be back 9/19
2017-04-25
0
17/09/2021 Noah Nguyen
2020-01-14
90
17/09/2021 Nicolas Dyson
2019-05-01
77
17/09/2021 Max Braund Taking at least a one term break due to activity clash
2018-09-11
90
17/09/2021 Lucas Dyson
2019-05-01
77
17/09/2021 Lucas de Villiers
2019-04-30
90
17/09/2021 Luca Parker
2019-09-10
90
17/09/2021 Kate Penny
2018-09-11
90
17/09/2021 Louis Briggs
2019-09-01
90
17/09/2021 Emilia Barmby
2020-01-14
90
17/09/2021 Eden Jones
2020-01-14
90
17/09/2021 Dominic Steele
2020-01-14
90
17/09/2021 Darius Dan
2018-09-25
65
17/09/2021 Adam Chenaf
2020-01-21
90
16/09/2021 Callum Mulley
2017-05-09
90
09/01/2020 Astrid Macer-Wright Didnt seem happy any more and didnt return. No reply from father.
2018-01-18
07/19 90
14/08/2019 Rosana Howard Moved to USA
2019-01-08
07/19 90
01/05/2019 Violet Lewis decided not to continue for summer term perhaps return sept
2018-10-24
03/19 90
01/05/2019 Rafi Lewis decided not to continue in summer19 term perhaps return September
2018-04-24
03/19 90
09/04/2019 Emily Clerkson
2018-09-11
12/18 90
09/04/2019 Amelia Stretch Dad was on training course but didnt make it to the end
2018-09-21
12/18 90
02/10/2018 Sofija Hanly
2018-01-11
07/18 90
02/10/2018 Milo Peplinski
2018-01-18
07/18 90
02/10/2018 Fausta Kiburyte
2018-01-18
07/18 90

Other Reports

Just for Interest… NB these stats use a different plug in to extract the data from PDB

Adult members By Borough

TownCount
Barking1
Barking & Dagnm1
Bexley2
Bromley5
Greenwich15
Ilford1
Lewisham21
Newham1
Redbridge1
Southwark2
Waverley1


Total Adults and Guests

count(town)
51

51

Musketeers by Boro

Musketeers By Borough

TownCount
Bromley2
Dartford1
Greenwich8
Lewisham4
London1
Southwark1

Total Musketeers

count(town)
17

Check total Musketeers 17

How People Found Us. Analysis of all records in the database including lapsed

Other Internet Search 123

Friend 7

British Fencing 8

Hotcourses 0

WantaSport 0 (from 5/17)

Social Media 9

Get Active 2 (from 5/17)

Poster/Leaflet 2

Newsshopper 0

No Answer 35

Other (see below) 1

Long term member 5

Total records 266

Total: 1
First NameFamily NameHow did you find the Club?
Simon Skerratt-Williams Personal recommendation

Offers to Assist

Total: 36
First NameFamily NameMember StatusAdmin NotesWould you like to help at the club?
Alexander Vandenbroucke Adult Member Perhaps
Ali Nokes Junior Member Perhaps
Amanda McTavish Adult Member Perhaps
Andrew Nisbet Adult Member Retired. Coach. Vice Chair Yes
Brooke Palmer Junior Member Mother is Winnie on adult training cse 09/21 Perhaps
Catherine Ashcroft Junior Member due to foot injury holding over fee to Summer 20 term (and could be longer...) Perhaps
Decordoba Mitchell-Rowe Adult Member Yes
Douglas Birkett Junior Cadet Member Yes
Elena Tereshchenko Junior Member Yes
Eloise Emerson Junior Member Perhaps
Eloise Emerson Junior Member Perhaps
Ester Balint Adult Member Perhaps
Gurbir Thethy Adult Member Perhaps
Gurlal Jagdev Adult Member Yes
Harry Gulliver Adult Member Perhaps
Hector Mann Adult Member Promoted to adults as over18 Perhaps
Henry Fazakerley Adult Member Yes
Hunter Coblentz Adult Member Yes
Iza Sasaran Adult Member Perhaps
Kathryn Heaton Adult Member 07/16 04/17: At Reading uni and fencing on the uni team. 09/20 enquired about returning Yes
Laura La Delfa Adult Member fencer with 10 yr break Perhaps
Lucian Stone Adult Member spr19 Perhaps
Maddie (Madeleine) Aitken Junior Cadet Member Yes
Manuel Capelo Adult Member Perhaps
Marija Todorovic Adult Member Perhaps
Marjolaine Mauduit Junior Member Yes
Miguel Mendes Adult Member Yes
Ming Gu Junior Member Yes
Nicki Aitken Junior Member Taking an exam break Perhaps
Olga Baykova Adult Member Yes
Remi Brazzi Junior Cadet Member Perhaps
Rémi Tuyaerts Adult Member Perhaps
Robert Smith Adult Member On going knee injury at present Perhaps
Robert Talpalaru Junior Member Yes
Thomas Jolin Adult Member Perhaps
Valeria Meng Adult Member Perhaps

Ethnic origin

Adult and Junior Members. Excludes trainees

Mixed 2
Black/BlackBritish     1
Asian/Asian British 10
White/Caucasian 54
Other 2
Prefer not to say 5
Check Total= 74

xmas meal

Total: 0

If used, delete these records in the Participants Database through the WordPress Admin interface

Maintenance

Used to test queries or for special purposes… Developer use only. Currently shows all ‘members’

Total: 23
First NameFamily NameMember StatusDate Of BirthMissed
Alba Acanfora Junior Member 25/08/2004 New
Joezinho Savage Junior Cadet Member 23/05/2005 0
Douglas Birkett Junior Cadet Member 20/02/2005 0
Marjolaine Mauduit Junior Member 15/12/2008 New
Sandesh Ravindran Junior Cadet Member 15/05/2004 0
Eloise Emerson Junior Member 20/03/2013 New
Ali Nokes Junior Member 30/05/2012 New
Eloise Emerson Junior Member 27/07/2011 New
Natasha Dillon Junior Member 16/02/2011 New
Brooke Palmer Junior Member 22/10/2010 New
Ming Gu Junior Member 29/11/2009 0
Edmund Vernon Junior Member 28/01/2009 0
Nicki Aitken Junior Member 05/11/2007 1
Catherine Ashcroft Junior Member 10/09/2007 0
Sarah Kirby Junior Member 09/06/2007 0
Elena Tereshchenko Junior Member 27/12/2006 New
Ann DESNOS Junior Member 25/09/2006 0
Maximilien Briggs Junior Member 24/05/2006 0
Maddie (Madeleine) Aitken Junior Cadet Member 31/10/2005 0
Stefania Bojarune Junior Member 07/11/2009 New
Robert Talpalaru Junior Member 07/08/2006 New
Alexander Harris Montero Junior Cadet Member 06/08/2005 0
Remi Brazzi Junior Cadet Member 03/07/2005 0

By Surname

Total: 45
First NameFamily NameAdmin NotesDate JoinedDate LeftbudgetTerm1Term2Term3
Alba Acanfora
2019-04-30
90 0 0 0
Makir Ahmed
2018-10-14
90 0 0 0
Katarina Baresic Attended taster but no further contact from her
2222-01-01
90 0 0 0
Simon Barlow
2018-04-17
90 0 0 0
Orla Barnewell Jan18/P1 Missed 1st night. No show on Thurs
2018-01-04
50 0 0 0
Hannah Blackburn existing fencer? (HF - Yes, at Durham with me)
2019-01-15
90 0 0 0
Jacobus Blankendaal
2019-04-30
90 0 0 0
Stefania Bojarune
2019-09-10
90 0 0 0
Ian Deakin Not able to attend summer taster due to 'pulled chest nerve'. Hopes to attend in future. Retain on Enquirers list.
2019-04-30
90 0 0 0
Will Dixon
2018-09-11
90 0 0 0
Sanja Kristin Dudek
2018-04-24
90 0 0 0
Daniel Elford
2019-10-02
90 0 0 0
Peter Evans
2019-09-05
90 0 0 0
Yulia Fungard Apr18 P1Tuesdays
2018-01-11
90 0 0 0
Ziran Gao duplicate?
2021-08-07
90 0 0 0
Stuart Hallifax Will attend summer taster but prob not attend until September. See Ian Deakin
2019-04-30
90 0 0 0
William Hopkinson retrieved old registration. address not changed
2021-06-05
90 54 0 0
Marguerite Howell
2019-09-05
90 0 0 0
Jutta Huesmann
2018-01-11
90 0 0 0
Alexander Kirk
2019-09-05
90 0 0 0
KRISZTINA KONCZ
2018-04-19
90 0 0 0
Jiaqi Li
2019-09-05
90 0 0 0
Zuzanna Łuczak too late for jan
2019-01-15
90 0 0 0
Michael Macy
2020-01-16
90 0 0 0
ANKITA MAHESHWARI
2019-09-17
90 0 0 0
Marjolaine Mauduit
2018-01-15
90 0 0 0
Meng Meng
2018-09-18
90 0 0 0
Jennifer Mingo
2019-01-01
90 0 0 0
Gauthier Monnier
2019-01-21
90 0 0 0
William Morland
2020-01-01
90 0 0 0
William O'Prey
2019-04-30
90 0 0 0
Onome Okorodudu
2018-08-21
90 0 0 0
Stephanie Parkes did not attend jan or apr taster. Perhaps Sept
2019-01-08
90 0 0 0
Stephanie Parkes
2020-01-07
90 0 0 0
Stephanie Parkes Registered again in 2021
2019-12-17
90 0 0 0
marek pilar
2019-05-28
90 0 0 0
Debbie Price Duplicate registration 90
Cait Rattigan
2015-06-15
90 0 0 0
FABIOLA RUIZ Registered again Sept20
2020-04-23
90 0 0 0
Maxine Sapsford
2018-10-24
90 0 0 0
Dominic Steele
2020-01-14
90 0 0 0
Yin Su
2018-06-21
90 0 0 0
Robert Talpalaru
2019-04-30
90 0 0 0
Polina Wade
2019-08-30
90 0 0 0
Lizzelle Wiltshire
2018-09-11
90 0 0 0

Delete these records through the Membership Payment Admin page (Maintenance)

For Deletion by Date

Total: 45
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate LeftbudgetTerm1Term2Term3
17/09/2021 William Hopkinson retrieved old registration. address not changed
2021-06-05
90 54 0 0
15/09/2021 Stephanie Parkes Registered again in 2021
2019-12-17
90 0 0 0
15/09/2021 Debbie Price Duplicate registration 90
11/09/2021 Ziran Gao duplicate?
2021-08-07
90 0 0 0
24/09/2020 FABIOLA RUIZ Registered again Sept20
2020-04-23
90 0 0 0
17/01/2020 Dominic Steele
2020-01-14
90 0 0 0
17/01/2020 Michael Macy
2020-01-16
90 0 0 0
15/01/2020 Daniel Elford
2019-10-02
90 0 0 0
15/01/2020 Ian Deakin Not able to attend summer taster due to 'pulled chest nerve'. Hopes to attend in future. Retain on Enquirers list.
2019-04-30
90 0 0 0
15/01/2020 Marguerite Howell
2019-09-05
90 0 0 0
15/01/2020 Peter Evans
2019-09-05
90 0 0 0
15/01/2020 Alexander Kirk
2019-09-05
90 0 0 0
15/01/2020 Jiaqi Li
2019-09-05
90 0 0 0
15/01/2020 marek pilar
2019-05-28
90 0 0 0
15/01/2020 Jacobus Blankendaal
2019-04-30
90 0 0 0
15/01/2020 William O'Prey
2019-04-30
90 0 0 0
15/01/2020 Gauthier Monnier
2019-01-21
90 0 0 0
15/01/2020 Zuzanna Łuczak too late for jan
2019-01-15
90 0 0 0
15/01/2020 Stuart Hallifax Will attend summer taster but prob not attend until September. See Ian Deakin
2019-04-30
90 0 0 0
03/01/2020 ANKITA MAHESHWARI
2019-09-17
90 0 0 0
30/12/2019 Robert Talpalaru
2019-04-30
90 0 0 0
30/12/2019 Marjolaine Mauduit
2018-01-15
90 0 0 0
30/12/2019 Alba Acanfora
2019-04-30
90 0 0 0
30/12/2019 Stefania Bojarune
2019-09-10
90 0 0 0
30/12/2019 William Morland
2020-01-01
90 0 0 0
28/12/2019 Stephanie Parkes
2020-01-07
90 0 0 0
07/11/2019 Hannah Blackburn existing fencer? (HF - Yes, at Durham with me)
2019-01-15
90 0 0 0
07/11/2019 Stephanie Parkes did not attend jan or apr taster. Perhaps Sept
2019-01-08
90 0 0 0
07/11/2019 Maxine Sapsford
2018-10-24
90 0 0 0
12/09/2019 Makir Ahmed
2018-10-14
90 0 0 0
12/09/2019 Meng Meng
2018-09-18
90 0 0 0
12/09/2019 Jennifer Mingo
2019-01-01
90 0 0 0
17/06/2019 Cait Rattigan
2015-06-15
90 0 0 0
17/06/2019 Polina Wade
2019-08-30
90 0 0 0
19/01/2019 Katarina Baresic Attended taster but no further contact from her
2222-01-01
90 0 0 0
12/01/2019 Will Dixon
2018-09-11
90 0 0 0
12/01/2019 Onome Okorodudu
2018-08-21
90 0 0 0
12/01/2019 Lizzelle Wiltshire
2018-09-11
90 0 0 0
28/09/2018 Yin Su
2018-06-21
90 0 0 0
28/09/2018 Orla Barnewell Jan18/P1 Missed 1st night. No show on Thurs
2018-01-04
50 0 0 0
12/09/2018 Sanja Kristin Dudek
2018-04-24
90 0 0 0
12/09/2018 Simon Barlow
2018-04-17
90 0 0 0
12/09/2018 KRISZTINA KONCZ
2018-04-19
90 0 0 0
12/09/2018 Jutta Huesmann
2018-01-11
90 0 0 0
12/09/2018 Yulia Fungard Apr18 P1Tuesdays
2018-01-11
90 0 0 0

Delete these records through the Other Reports/Maintenance page

Maintenance Routines

Just copy and paste the required SQL code in bold below including the semi-colon. After successful execution it will tell you how many rows (records) were updated.

NB If you get an ‘execution error near N’ you may have to edit the double quotes to ” from those that appear when pasted for queries 1 and 3

1.Set ‘Paid’ to No (run at beginning of each term)

UPDATE wp_participants_database SET term_paid=”N”;

2. Set amounts paid for each term to zero (run annually prior to new season in September)

UPDATE wp_participants_database SET fees_paid=0,fees_paid2=0,fees_paid3=0;

3. Delete members marked for deletion on the Members Record (run as required). Use this to delete Enquirers who never made it to training. Or any other long lapsed trainee or member but it will affect statistics.

DELETE FROM wp_participants_database WHERE delete_flag=”Y”

4. Annually, Remove personal data from records for all ex members and trainees after three years (to be written) [retain, name, borough, membership status, ex trainee dates joined and left. – to be finalised]