Club Membership – Admin – Other

Lapsed Members

Lapsed Adults

Search:
Total: 19
Date UpdatedFirst NameFamily NameFencer's First NameAdmin NotesDate JoinedDate Left
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 Hunter Coblentz Hunter
2019-11-07
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: 51
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate Left
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: 27
Date UpdatedFirst NameFamily NameFencer's First NameAdmin NotesDate JoinedDate Left
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 Zara Barmby Zara
2020-01-13
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 Max Braund Max Taking at least a one term break due to activity clash
2018-09-11
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
Greenwich11
Lewisham15
Newham2
Redbridge2
Southwark3


Total Adults and Guests

count(town)
41

41

Musketeers by Boro

Musketeers By Borough

TownCount
Bromley6
Dartford1
Greenwich15
Lewisham8
Southwark1

Total Musketeers

count(town)
31

Check total Musketeers 31

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

Other Internet Search 123

Friend 15

British Fencing 17

Hotcourses 0

WantaSport 0 (from 5/17)

Social Media 8

Get Active 1 (from 5/17)

Poster/Leaflet 2

Newsshopper 1

No Answer 35

Other (see below) 0

Long term member 5

Total records 316

Total: 0

Offers to Assist

Total: 46
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
Amira Abujbara Adult Member Perhaps
Andrew Nisbet Adult Member Retired. Coach. Vice Chair Yes
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
Claudia Hamilton Junior Member Camp21 Perhaps
Decordoba Mitchell-Rowe Adult Member Yes
Elena Tereshchenko Junior Member Yes
Ester Balint Adult Member Perhaps
Gurbir Thethy Adult Member Perhaps
Gurlal Jagdev Adult Member Yes
Harry Gulliver Adult Member Perhaps
Helen Oram Junior Member Camp21 Perhaps
Helene Huille Junior Cadet Member A21 Perhaps
Henry Fazakerley Adult Member Yes
Iza Sasaran Adult Member Perhaps
James Cheung Adult Member Guesting Perhaps
Julie McQuade Junior 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
Leah Cole Junior Member ex summer camp 21 Perhaps
Lenore Price Junior Member Very keen... ex summer camp 21 Perhaps
Lucas Dyson Junior Member Perhaps
Manuel Capelo Adult Member Perhaps
Maria Lockhart Junior Member ex summer camp 21 Perhaps
Matthew Todd Junior Member Camp2 only Perhaps
Mazlini Elvin Junior Member Perhaps
Miguel Mendes Adult Member Yes
Ming Gu Junior Member Yes
Myriam Chapelin Junior Member Perhaps
Nathan Aspell Junior Member DofE interest Perhaps
Nicki Aitken Junior Member Yes
Nicolas Dyson Junior Member Perhaps
Olga Baikova Adult Member Yes
Rémi Tuyaerts Adult Member Perhaps
Robert Smith Adult Member On going knee injury at present Perhaps
Robert Talpalaru Junior Member Yes
Syreeta Robinson-Gayle Junior Member Perhaps
Thomas Jolin Adult Member Perhaps
Valeria Meng Adult Member Perhaps
Vincenzo Brugaletta-Orlandi Junior Member Camp21 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 4
Black/BlackBritish     3
Asian/Asian British 9
White/Caucasian 49
Other 3
Prefer not to say 7
Check Total= 75

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: 34
First NameFamily NameMember StatusDate Of BirthMissed
Lenore Price Junior Member 25/08/2012 New
Ali Nokes Junior Member 30/05/2012 New
Nicolas Dyson Junior Member 13/03/2012 0
Leah Pryce Junior Member 26/10/2011 New
Katie Garvey Junior Member 30/09/2011 New
Zoe Linekar Junior Member 26/04/2011 New
Natasha Dillon Junior Member 16/02/2011 0
Leah Cole Junior Member 25/10/2010 New
Maria Lockhart Junior Member 23/10/2010 New
Winnie Palmer Junior Member 22/10/2010 0
Helen Oram Junior Member 07/07/2010 New
Claudia Hamilton Junior Member 20/06/2010 New
Lucas Dyson Junior Member 23/12/2009 0
Ming Gu Junior Member 29/11/2009 0
Syreeta Robinson-Gayle Junior Member 06/11/2009 New
Matthew Todd Junior Member 26/08/2009 New
Vincenzo Brugaletta-Orlandi Junior Member 01/02/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
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
Ann DESNOS Junior Member 25/09/2006 0
Christelle Parmentier Junior Member 24/05/2006 0
Helene Huille Junior Cadet Member 09/01/2006 0
Nicki Aitken Junior Member 31/10/2005 0
Dani Savage Junior Cadet Member 23/05/2005 0
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: 75
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
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
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
Alexander Kirk
2019-09-05
90 0 0 0
KRISZTINA KONCZ
2018-04-19
90 0 0 0
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
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
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: 75
Date UpdatedFirst NameFamily NameAdmin NotesDate JoinedDate LeftbudgetTerm1Term2Term3
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]