Club Membership – Admin – Other

Lapsed Members

Lapsed Adults

Search:
Total: 33
Date UpdatedFirst NameFamily NameFencer's First NameAdmin NotesDate JoinedDate Left
08/06/2022 William Hopkinson William Back on a posting 2014-10-28 03/22
08/06/2022 Helen McKean Helen ulez vechicle, too expensive to travel 2008-09-09 03/20
08/06/2022 Coenraad Uys Coenraad Spr19. 2018-09-11 03/20
08/06/2022 Stephen Wood Stephen Not responding to contact 2016-01-22 03/20
08/06/2022 Robert Smith Robert On going knee injury 2018-01-19 03/20
08/06/2022 Rémi Tuyaerts Rémi 2019-09-22 03/20
08/06/2022 Peter Bromley Peter Still supports, turned up 2022 agm but no attendance for a while 2007-09-01 07/16
08/06/2022 Lorenzo Rossi Lorenzo 2021-08-16 03/20
08/06/2022 Miguel Mendes Miguel Recovering+fitness post-covid 2019-10-01 03/20
08/06/2022 Jess Yoon Jess 2018-01-08 03/20
25/04/2022 Kathryn Heaton Kathryn 07/16 04/17: At Reading uni and fencing on the uni team. 09/20 enquired about returning 2009-05-04
25/04/2022 Phi-Anh Nghiem Phi-Anh S19 9wk 2019-02-11
08/02/2022 Laura La Delfa Laura 02/22 Expecting baby, will return. fencer with 10 yr break. 2018-05-01 03/22
08/02/2022 Gurbir Thethy Gurbir 02/22 Recovering from surgery 2020-01-15 02/22
08/02/2022 Kallum Nisbet Kallum 02/22 Shift pattern prevents fencing Returned jan 16, guesting Jan 18 2010-01-01 02/21
14/01/2022 Andrei Azzopardi Andrei 2021-10-25 12/21
14/01/2022 Francis Osborn 2018-05-17
14/01/2022 Samuel Samuel Samuel Promoted from Cadet as now 18 2015-09-10
03/01/2022 Richard Shannon Richard 2019-10-10
03/01/2022 Gabrielle Macaulay Gabrielle 2018-09-11 12/19
03/01/2022 Lucian Stone Lucian spr19 2019-01-08 12/19
03/01/2022 Ryan Campbell Ryan 01/18 trainee 2018-01-24 12/19
27/11/2021 Gianluca Gentile Gianluca Jan18/P1&2 Conc 2017-01-09
03/11/2021 Hector Mann Hector Promoted to adults as over18 2018-09-11 03/20
03/11/2021 Marija Todorovic Marija 2019-01-02
30/10/2021 Amy Jenkins Amy Helen Jenkins is our Welfare Officer. Promoted to Adults as turned 18. Amy took a 2 term break then returned and took Kent U16 title May17! 2013-09-10
14/10/2021 James Williamson james Student. Club Secretary from Feb13 to Sept21 Moved away 2011-09-01 0621
17/09/2021 Diana Dan dd 2018-09-11
06/09/2021 Stefano Conese 2019-04-30 06/20
25/02/2020 Mark Juniper spr19 2019-01-08 04/19
17/01/2020 Yun-Ju Lee 2018-09-13
15/08/2019 Kayleigh Hoang Trainee spr19. Gone to uni 2019-01-08 07/19
12/07/2019 Nizaar Kinsella 2018-10-02

Trainees

Search:
Total: 54
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate Left
09/05/2022 Anatoly Fedorov knee issues (ligament missing) cause pain while fencing where tennis and squash do not 2022-01-13 04/22
07/05/2022 Winnie Palmer A21 2021-08-08 03/22
10/03/2022 Alex van Vliet ? Jus workload I think 2021-09-02 01/22
14/01/2022 Collwyn Bevan 2019-02-19
14/01/2022 Ben Mulcahy Paid concession 1st term £40 2018-09-11
12/01/2022 Padraig Noone 2021-09-21
03/11/2021 Olivia Scaramuzza 2019-09-03 03/20
27/02/2020 Katie Irving 2020-01-30
24/02/2020 Roberto Cervone Took out BF membership Sept 19. Needs refresh to Jan20 2019-09-03
23/01/2020 Saleem Wadee 2020-01-14
21/01/2020 Conor Naughton 2020-01-14
16/01/2020 Adam Wilkinson 2020-01-14
16/01/2020 Tim Maynard 2020-01-14
16/01/2020 Annaleise Cooke 2020-01-14
16/01/2020 Jibran Mirza 2020-01-09
15/01/2020 Virgil-Pai Janhirat 2020-01-09
15/01/2020 Cecile Clamaron 2020-01-09
15/01/2020 Ste Clough 09/19 is still interested, just work constraints 2019-04-23
15/01/2020 Stuart Hallifax 2020-01-14
15/01/2020 Emma Bockhop 2020-01-14
10/01/2020 Witold Lukaszewski 2020-01-09
10/01/2020 Agnieszka Marciszewska 2020-01-09
04/01/2020 Claire Cooper 2020-01-09
04/01/2020 Alberto Ferreira 2019-04-25
04/01/2020 Alvaro Gomez Missed the taster and wk1.. 2019-08-07
04/01/2020 Nicola Belcher Confirmed for Sept19 (Sum19 but husband health issues so deferred until Sept19) 2019-04-26
04/01/2020 India Maddison Applying for Sept19 2019-09-03
04/01/2020 Haritha Alluri 2019-09-05
04/01/2020 Beatriz Liebe 2019-09-03
04/01/2020 Polina Wade 2019-09-05
04/01/2020 Niall Richards 2019-09-05
03/01/2020 William Morland 2020-01-14
03/01/2020 Callum McGuire 2020-01-14
02/01/2020 Jack McCormick McGuire 2020-01-14
02/01/2020 Megan Jenkins 2020-01-14
02/01/2020 Anna McCormick McGuire 2020-01-09
07/11/2019 Zena Khan Sum19 miss first session 2019-04-30
07/11/2019 Tony Baumgartner Sum19 2019-01-08
07/11/2019 Sean Drislane Summer 19 2019-04-30
07/11/2019 Joshua Mort Cannot attend summer taster. Funeral. May sign up anway 2019-04-30
07/11/2019 Kiran Perkins Sum19 2019-04-29
07/11/2019 Lucy Swarbreck 2019-04-30
04/09/2019 Sarah Bardell Sum19 2019-04-30
24/04/2019 Todd Gibson Jan19 2019-01-08
24/04/2019 Neo Negri Jan19 2019-01-08
24/04/2019 ANSI DENiZ RONA BAYILDIRAN Jan19 2019-01-01
17/01/2019 Vivian Göde 2018-09-11
17/01/2019 Phill Harris 2018-09-18
17/01/2019 Mary Martin Aut18 £50 2018-09-25
17/01/2019 Joanne Hollington 2018-09-11
17/01/2019 Bram Vanoirbeek 2018-09-11
17/01/2019 Aurelia Wong Aut18 50 2018-09-18
13/09/2018 Kola Lawal 2018-04-20
13/09/2018 Conor Sheehan Summer 18 2018-05-01

Musketeers

Search:
Total: 39
Date UpdatedFirst NameFamily NameFencer's First NameAdmin NotesDate JoinedDate Left
23/06/2022 Max Braund Max Taking at least a one term break due to activity clash. Has joined Saxon club so looks like he moved 2018-09-11 03/20
08/06/2022 Helen Oram Imogen Camp21. Claimed to have peer refereeing problem but left before we could discuss 2021-07-28 03/22
08/05/2022 Christelle Parmentier Maximilien Did not return from Covid 2017-09-19 03/22
08/05/2022 Vincenzo Brugaletta-Orlandi Lewis Camp21 Staying with Cricket 2021-08-07 03/22
30/03/2022 Claudia Hamilton Ama-Kumani Camp21 no reason 2021-08-07 1221
30/03/2022 Syreeta Robinson-Gayle Leilani no reason 2021-09-16 1221
30/03/2022 Natasha Dewani James Camp21. no explanation 2021-08-07 0322
30/03/2022 Ali Nokes Daisy Boo no explanation 2021-09-16 0322
30/03/2022 Ann DESNOS Adele 2016-09-13
21/03/2022 Dani Savage Joezinho 10/21 Balancing workload. Hopes to be back N M Savage 2015-01-01 12/21
21/03/2022 Katie Garvey Stella ex summer camp 21 Too far to travel 2021-08-07
29/01/2022 Lok Sum Ng Lok Sum Summer Camp21 2021-08-07 09/21
29/01/2022 Joshua Au Joshua Summer Camp21 2021-08-07 09/21
29/01/2022 Ziran Gao Ziran Summer Camp21 2021-08-07 09/21
26/01/2022 Nicki Aitken Cecily Taking an exam break 2017-01-01
19/01/2022 Sandesh Ravindran Sandesh Rejoined Oct 15 2015-04-14 03/20
14/01/2022 Eloise Emerson Arthur ex ZFW Mother cannot schedule Tuesdays 2021-09-21
14/01/2022 Rosana Howard Moved to USA 2019-01-08 07/19
14/01/2022 Callum Mulley Callum 2017-05-09
11/01/2022 Eloise Emerson Caspar ex ZFW. Mother cannot schedule Tuesdays 2021-09-21 12/21
12/10/2021 Tim Harris Alexander Has taken up triathlon in the lockdown 2015-09-24 0621
12/10/2021 Remi Brazzi Remi Has taken up rock climbing 2019-09-10 0621
17/09/2021 Maya Liddell Maya 2020-01-14
17/09/2021 William Bowes William Fences at Eltham College 2019-01-15
17/09/2021 Sophie Bussell Sophie Taking exam break in Summer term. Hopes to be back 9/19 2017-04-25
17/09/2021 Noah Nguyen Noah 2020-01-14
17/09/2021 Lucas de Villiers Lucas 2019-04-30
17/09/2021 Luca Parker Luca 2019-09-10
17/09/2021 Kate Penny Kate 2018-09-11
17/09/2021 Louis Briggs Louis 2019-09-01
17/09/2021 Emilia Barmby Emilia 2020-01-14
17/09/2021 Eden Jones Eden 2020-01-14
17/09/2021 Darius Dan Darius 2018-09-25
17/09/2021 Adam Chenaf Adam 2020-01-21
09/01/2020 Astrid Macer-Wright Didnt seem happy any more and didnt return. No reply from father. 2018-01-18 07/19
01/05/2019 Violet Lewis decided not to continue for summer term perhaps return sept 2018-10-24 03/19
01/05/2019 Rafi Lewis decided not to continue in summer19 term perhaps return September 2018-04-24 03/19
09/04/2019 Emily Clerkson 2018-09-11 12/18
09/04/2019 Amelia Stretch Dad was on training course but didnt make it to the end 2018-09-21 12/18

Other Reports

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

Adult members By Borough

TownCount
Barking & Dagnm2
Bexley2
Bromley4
Greenwich15
Lewisham12
Newham1
Redbridge1
Southwark6
Tower Hamlets2
United Kingdom1


Total Adults and Guests

Count
46

46

Musketeers by Boro

Musketeers By Borough

TownCount
Bromley5
Greenwich12
Lewisham10

Total Musketeers

count(town)
27

Check total Musketeers 27

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

Other Internet Search 123

Friend 21

British Fencing 18

Social Media (FB) 8
Social Media (Insta) 1

Get Active 1 (from 5/17)

Poster/Leaflet 2

Newsshopper 1

No Answer 167

Other (see below) 0

Long term member 6

Total records 358

Total: 0

Offers to Assist

Total: 53
First NameFamily NameMember StatusAdmin NotesWould you like to help at the club?
Afifa Khan Adult Member guesting Perhaps
Albert Jesupaul Adult Member spr22 Perhaps
Alexander Vandenbroucke Adult Member Perhaps
Amanda McTavish Adult Member Perhaps
Amira Abujbara Adult Member Perhaps
Andrew Nisbet Adult Member Retired. Coach. Yes
Andrew Pavaday Adult Member also Coach Perhaps
Anna Kalsi Adult Member A21 Perhaps
Arber Koci Adult Member A21 - taking sabattical 'til autumn Perhaps
Bart Miko Adult Member A21 Perhaps
Catherine Ashcroft Junior Member due to foot injury holding over fee to Summer 20 term (and could be longer...) Perhaps
Chris Birkett Junior Cadet Member 10/21Balancing school work. Hopes to be back Perhaps
Debbie Olatokun Adult Member Spr22 Perhaps
Decordoba Mitchell-Rowe Adult Member Yes
Elena Tereshchenko Junior Member Yes
Ester Balint Adult Member Perhaps
Gurlal Jagdev Adult Member Yes
Harry Gulliver Adult Member Perhaps
Helene Huille Junior Cadet Member A21 Perhaps
Henry Fazakerley Adult Member Yes
Hunter Coblentz Adult Member Yes
Iza Sasaran Adult Member Perhaps
James Cheung Adult Member Guesting Perhaps
Jeffrey Allen Adult Member Guesting Perhaps
John Chia Adult Member Spr22 Perhaps
Julia Kwon Adult Member Spr22 Yes
Julie McQuade Junior Member Perhaps
Kit Stormont Adult Member Spr22 Perhaps
Leah Cole Junior Member ex summer camp 21 Perhaps
Lenore Price Junior Member Very keen... ex summer camp 21 Perhaps
Manuel Capelo Adult Member Perhaps
Margarita Gradinar Adult Member spr22 Yes
Maria Lockhart Junior Member ex summer camp 21 Perhaps
Maria Sasaran Adult Member Perhaps
Matthew Todd Junior Member Camp2 only Perhaps
Mazlini Elvin Junior Member Perhaps
Ming Gu Junior Member Yes
Myriam Chapelin Junior Member Perhaps
Nathan Aspell Junior Member DofE interest Perhaps
Nicki Aitken Junior Member Yes
Olga Baikova Adult Member Yes
Robert Talpalaru Junior Member Yes
Sophie Standring Adult Member A21 Perhaps
Sylvie Asimus Nguyen Junior Member Perhaps
Sylvie Asimus Nguyen Junior Member Perhaps
Tania Dyson Junior Member Perhaps
Tania Dyson Junior Member Perhaps
Thomas Jolin Adult Member Perhaps
Valeria Meng Adult Member Perhaps
Vesna Susac Junior Member Noah Shah Perhaps
Vlad Stoian Adult Member Perhaps
Winnie Palmer Junior Member Mother is Winnie on adult training cse 09/21 Perhaps
Zoe Linekar Junior Member Perhaps

Ethnic origin

Adult and Junior Members. Excludes trainees

Mixed 9
Black/BlackBritish     2
Asian/Asian British 6
White/Caucasian 48
Other 5
Prefer not to say 6
Check Total= 76

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: 30
First NameFamily NameMember StatusDate Of BirthMissed
Lenore Price Junior Member 25/08/2012 New
Sylvie Asimus Nguyen Junior Member 15/06/2012 New
Tania Dyson Junior Member 13/03/2012 0
Leah Pryce Junior Member 26/10/2011 New
Zoe Linekar Junior Member 26/04/2011 New
Jasmina Haynes Junior Member 28/02/2011 New
Alison O'Neil Junior Member 07/12/2010 New
Leah Cole Junior Member 25/10/2010 New
Maria Lockhart Junior Member 23/10/2010 New
Winnie Palmer Junior Member 22/10/2010 0
Vesna Susac Junior Member 20/02/2010 New
Tania Dyson Junior Member 23/12/2009 0
Ming Gu Junior Member 29/11/2009 0
Matthew Todd Junior Member 26/08/2009 New
Elliot Vernon Junior Member 28/01/2009 0
Myriam Chapelin Junior Member 15/12/2008 0
Nathan Aspell Junior Member 22/08/2008 New
Sylvie Asimus Nguyen Junior Member 04/12/2007 New
Catherine Ashcroft Junior Member 10/09/2007 0
Sarah Kirby Junior Member 09/06/2007 0
Julie McQuade Junior Member 04/06/2007 New
Mazlini Elvin Junior Member 29/01/2007 New
Elena Tereshchenko Junior Member 27/12/2006 0
Helene Huille Junior Cadet Member 09/01/2006 0
Nicki Aitken Junior Member 31/10/2005 0
Flavia Marinoni Junior Cadet Member 18/09/2005 New
Chris Birkett Junior Cadet Member 20/02/2005 0
Robert Talpalaru Junior Member 01/01/1970 New
Stefania Bojarune Junior Member 01/01/1970 New
Alba Acanfora Junior Member 01/01/1970 New

By Surname

Total: 82
First NameFamily NameAdmin NotesDate JoinedDate LeftbudgetTerm1Term2Term3
Alba Acanfora 2019-04-30 90 0 0 0
Makir Ahmed 2018-10-14 90 0 0 0
Odunola Ajibola Summer 2020 or September? emailed in January 2019-04-23 90 0 0 0
Sonia Andrews-Okwum 2018-01-25 12/17 90 0 0 0
Ross Baker 2020-01-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
Beatriz Quintairos Suarez Beatriz Quintairos Suarez 97
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
Erin Gandia 2020-01-07 90 0 0 0
Ziran Gao duplicate? 2021-08-07 90 0 0 0
Shlomit Glaser Back pains, under doctor's orders. Hope to join summer 2020 2020-01-09 90 0
Stuart Hallifax Will attend summer taster but prob not attend until September. See Ian Deakin 2019-04-30 90 0 0 0
Sofija Hanly 2018-01-11 07/18 90 0 0 0
Daniel Hogarth Duplicate entry delete (RB 10/05/22) 2022-05-09 97
William Hopkinson retrieved old registration. address not changed 2021-06-05 0 0 0 0
Marguerite Howell 2019-09-05 90 0 0 0
Jutta Huesmann 2018-01-11 90 0 0 0
Clara Hughes unsubbed 2020-11-01 90 0 0 0
Jayne Jacob work pressure: retail 2018-01-09 07/18 90 0 0 0
Fausta Kiburyte 2018-01-18 07/18 90 0 0 0
Jesse King-Nkaronye 2021-08-07 90 0 0 0
Alexander Kirk 2019-09-05 90 0 0 0
KRISZTINA KONCZ 2018-04-19 90 0 0 0
Julia Kwon 97
Mulin Lee parent confirms Kai is no longer interested (RB 24/04/22) 90
christine leech 2018-01-18 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 Had taken out BF membership but work called... Perhaps jan20 2019-09-05 90 0 0 0
Michael Macy 2020-01-16 90 0 0 0
ANKITA MAHESHWARI 2019-09-17 90 0 0 0
ANKITA MAHESHWARI 2020-01-09 90 0 0 0
Flavia Marinoni 2022-01-25 97
Marjolaine Mauduit Duplicate record 2021-09-28 90
Chris Mccoy 2020-01-07 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
Aneta Morgiewicz unsubbed from email list 2020-08-13 90 0 0 0
William Morland 2020-01-01 90 0 0 0
Carol Nguyen 2018-05-15 07/18 0 0 0 0
William O'Prey 2019-04-30 90 0 0 0
Onome Okorodudu 2018-08-21 90 0 0 0
Debbie Olatokun Duplicate 90 97
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
Milo Peplinski 2018-01-18 07/18 90 0 0 0
marek pilar 2019-05-28 90 0 0 0
Debbie Price Duplicate registration 90
Debbie Price Wants to join in Jan 2022 with friend Anita 90
Andrew Price 2022-01-10 97
Nicole Prowd 2018-09-11 12/18 90 0 0 0
Alison Pullen 97
Elliott Quinn spr19 2018-01-10 04/19 65 0 0 0
Mike Ralph 2021-07-29 90 90 0 0
Cait Rattigan 2015-06-15 90 0 0 0
Christopher Ross 2018-01-16 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
Simon Skerratt-Williams 2018-01-18 12/17 90 0 0 0
Louise Staunton Jan18/P1&2 2018-01-09 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
Allan Taylor Jan18/P1&P2 2018-01-09 90 0 0 0
Beatrice Vincent 2018-01-11 90 0 0 0
Holly Voysey 2018-08-11 90 0 0 0
Polina Wade 2019-08-30 90 0 0 0
Artur Wilczynski Had kidney op. Hopes to attend summer 2020 2019-09-03 90 0 0 0
Lizzelle Wiltshire 2018-09-11 90 0 0 0
Olivier Zongo S18 2018-04-17 90 0 0 0

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

For Deletion by Date

Total: 82
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate LeftbudgetTerm1Term2Term3
10/05/2022 Daniel Hogarth Duplicate entry delete (RB 10/05/22) 2022-05-09 97
24/04/2022 Mulin Lee parent confirms Kai is no longer interested (RB 24/04/22) 90
21/04/2022 Jesse King-Nkaronye 2021-08-07 90 0 0 0
19/04/2022 Julia Kwon 97
10/03/2022 Flavia Marinoni 2022-01-25 97
25/02/2022 Alison Pullen 97
09/02/2022 Beatriz Quintairos Suarez Beatriz Quintairos Suarez 97
26/01/2022 Fausta Kiburyte 2018-01-18 07/18 90 0 0 0
26/01/2022 Milo Peplinski 2018-01-18 07/18 90 0 0 0
26/01/2022 Sofija Hanly 2018-01-11 07/18 90 0 0 0
26/01/2022 Allan Taylor Jan18/P1&P2 2018-01-09 90 0 0 0
26/01/2022 Christopher Ross 2018-01-16 90 0 0 0
26/01/2022 Louise Staunton Jan18/P1&2 2018-01-09 90 0 0 0
26/01/2022 Olivier Zongo S18 2018-04-17 90 0 0 0
26/01/2022 Beatrice Vincent 2018-01-11 90 0 0 0
26/01/2022 christine leech 2018-01-18 90 0 0 0
26/01/2022 Nicole Prowd 2018-09-11 12/18 90 0 0 0
26/01/2022 Carol Nguyen 2018-05-15 07/18 0 0 0 0
26/01/2022 Jayne Jacob work pressure: retail 2018-01-09 07/18 90 0 0 0
17/01/2022 Andrew Price 2022-01-10 97
14/01/2022 Maxine Sapsford 2018-10-24 90 0 0 0
14/01/2022 Elliott Quinn spr19 2018-01-10 04/19 65 0 0 0
14/01/2022 Alba Acanfora 2019-04-30 90 0 0 0
14/01/2022 Jennifer Mingo 2019-01-01 90 0 0 0
14/01/2022 Peter Evans 2019-09-05 90 0 0 0
14/01/2022 Marguerite Howell 2019-09-05 90 0 0 0
12/01/2022 Mike Ralph 2021-07-29 90 90 0 0
11/01/2022 ANKITA MAHESHWARI 2020-01-09 90 0 0 0
11/01/2022 Shlomit Glaser Back pains, under doctor's orders. Hope to join summer 2020 2020-01-09 90 0
11/01/2022 Erin Gandia 2020-01-07 90 0 0 0
11/01/2022 Chris Mccoy 2020-01-07 90 0 0 0
11/01/2022 Artur Wilczynski Had kidney op. Hopes to attend summer 2020 2019-09-03 90 0 0 0
11/01/2022 Michael Macy Had taken out BF membership but work called... Perhaps jan20 2019-09-05 90 0 0 0
11/01/2022 Odunola Ajibola Summer 2020 or September? emailed in January 2019-04-23 90 0 0 0
11/01/2022 Clara Hughes unsubbed 2020-11-01 90 0 0 0
11/01/2022 Aneta Morgiewicz unsubbed from email list 2020-08-13 90 0 0 0
09/01/2022 Debbie Olatokun Duplicate 90 97
09/01/2022 Debbie Price Wants to join in Jan 2022 with friend Anita 90
07/01/2022 Ross Baker 2020-01-14 90 0 0 0
16/11/2021 Simon Skerratt-Williams 2018-01-18 12/17 90 0 0 0
16/11/2021 Sonia Andrews-Okwum 2018-01-25 12/17 90 0 0 0
16/11/2021 Holly Voysey 2018-08-11 90 0 0 0
09/11/2021 William Hopkinson retrieved old registration. address not changed 2021-06-05 0 0 0 0
30/09/2021 Marjolaine Mauduit Duplicate record 2021-09-28 90
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 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 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
12/09/2019 Makir Ahmed 2018-10-14 90 0 0 0
12/09/2019 Meng Meng 2018-09-18 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]