9yqvca_
9yqvca_
Replacing all instances of database prefix with mixed case letters
Number of rows = 10527
Correcting group memberships for members
User 12436farnborough-ac-uk is in club Juniors, new role = juniorsclub
User andy-chatterton is in club Men, new role = mensclub
User Maggie Wilks is in club Ladies, new role = ladiesclub
User alan-wilks is in club Men, new role = mensclub
User adam-brash is in club Men, new role = mensclub
User aisling-naylor is in club Ladies, new role = ladiesclub
User alan-humble is in club Men, new role = mensclub
User alanalandmills-co-uk is in club Men, new role = mensclub
User alex-lewicka is in club Ladies, new role = ladiesclub
User alex-cram is in club Ladies, new role = ladiesclub
User alexgulliver is in club Juniors, new role = juniorsclub
User ali-cannon is in club Ladies, new role = ladiesclub
User alisdhair-beckingham is in club Men, new role = mensclub
User alison-sant is in club Ladies, new role = ladiesclub
User marcus-longfield is in club Men, new role = mensclub
User alison-tinsley is in club Ladies, new role = ladiesclub
User allan-bushell is in club Men, new role = mensclub
User alison-woolley is in club Ladies, new role = ladiesclub
User amit-dasgupta is in club Men, new role = mensclub
User amrit is in club Juniors, new role = juniorsclub
User andrew_john_lloydyahoo-de is in club Men, new role = mensclub
User andrew-sansom is in club Men, new role = mensclub
User andrewdigiparks-com is in club Men, new role = mensclub
User andrew-osment is in club Men, new role = mensclub
User andrew-strongolos is in club Men, new role = mensclub
User andyreid100hotmail-com is in club Men, new role = mensclub
User anita-lake is in club Ladies, new role = ladiesclub
User Ann Boakes is in club Ladies, new role = ladiesclub
User anne-johansen is in club Ladies, new role = ladiesclub
User anne-butcher is in club Ladies, new role = ladiesclub
User antonio-reginaldo is in club Men, new role = mensclub
User arbphicloud-com is in club Men, new role = mensclub
User avtar-mudhar is in club Men, new role = mensclub
User athornton is in club Juniors, new role = juniorsclub
User brian-feedam is in club Men, new role = mensclub
User barbara-thain is in club Ladies, new role = ladiesclub
User b-hudson-reed is in club Ladies, new role = ladiesclub
User barney-hall is in club Men, new role = mensclub
User barry-shackleton is in club Men, new role = mensclub
User bela-hegedus is in club Men, new role = mensclub
User belinda-paulkrpconsulting-co-uk is in club Juniors, new role = juniorsclub
User Ben Muller is in club Men, new role = mensclub
User clive-humphries is in club Men, new role = mensclub
User ketan-bharania is in club Men, new role = mensclub
User bill-witkowski is in club Men, new role = mensclub
User billy-ap-iolo is in club Men, new role = mensclub
User billyboyfrostgooglemail-com is in club Men, new role = mensclub
User gary-bishop is in club Men, new role = mensclub
User blackmoremattyahoo-com is in club Men, new role = mensclub
User yani-chocalingum is in club Men, new role = mensclub
User blaise-murphy is in club Men, new role = mensclub
User jenny-blewett is in club Ladies, new role = ladiesclub
User bob-billers is in club Men, new role = mensclub
User bobbymurden1gmail-com is in club Men, new role = mensclub
User bhogilal-hirani-bp is in club Men, new role = mensclub
User brian-cooper is in club Men, new role = mensclub
User brian-smith is in club Men, new role = mensclub
User richard-butler is in club Men, new role = mensclub
User button-pfgmail-com is in club Men, new role = mensclub
User carson_nenaoutlook-com is in club Juniors, new role = juniorsclub
User dolores-hillen is in club Ladies, new role = ladiesclub
User charlotte-williams is in club Ladies, new role = ladiesclub
User Christine McAuliffe is in club Ladies, new role = ladiesclub
User chris-white83hotmail-co-uk is in club Men, new role = mensclub
User chrisdavidparkerhotmail-com is in club Men, new role = mensclub
User chrishartneyntlworld-com is in club Men, new role = mensclub
User christopher-joseph is in club Men, new role = mensclub
User chris-osment is in club Men, new role = mensclub
User christine-smith is in club Ladies, new role = ladiesclub
User colin-deadfield is in club Men, new role = mensclub
User andrew-clack-for-riley-clack is in club Men, new role = mensclub
User clare-kemp is in club Ladies, new role = ladiesclub
User clarkey76 is in club Men, new role = mensclub
User cleve-vine is in club Men, new role = mensclub
User clive-calam is in club Men, new role = mensclub
User Connor Whiteside is in club Men, new role = mensclub
User cswood8hotmail-com is in club Ladies, new role = ladiesclub
User darren-joyce is in club Men, new role = mensclub
User dale-williams is in club Men, new role = mensclub
User dan-djs35gmail-com is in club Men, new role = mensclub
User daniel-penfold is in club Men, new role = mensclub
User dave-ireland is in club Men, new role = mensclub
User david-loveday is in club Men, new role = mensclub
User david-ward is in club Men, new role = mensclub
User david_nickihotmail-com is in club Ladies, new role = ladiesclub
User david_rayhotmail-co-uk is in club Men, new role = mensclub
User david-gillham is in club Men, new role = mensclub
User dawn-ledgard is in club Ladies, new role = ladiesclub
User dan-blackbrough is in club Men, new role = mensclub
User dean-farrer is in club Men, new role = mensclub
User Michael Hunt is in club Men, new role = mensclub
User denice-lowen is in club Ladies, new role = ladiesclub
User denise_halletthotmail-com is in club Juniors, new role = juniorsclub
User dermot-kavanagh is in club Men, new role = mensclub
User derrick-miles is in club Men, new role = mensclub
User nick-saunders is in club Men, new role = mensclub
User doconnor1hotmail-co-uk is in club Men, new role = mensclub
User dean-pullen is in club Men, new role = mensclub
User duncan-kim is in club Men, new role = mensclub
User Dusty Kemp is in club Men, new role = mensclub
User dylanjames33rocketmail-com is in club Juniors, new role = juniorsclub
User ed-lyons is in club Men, new role = mensclub
User edgulliver7 is in club Juniors, new role = juniorsclub
User edmeemurray69gmail-com is in club Ladies, new role = ladiesclub
User stephen-eddy is in club Men, new role = mensclub
User elise-hunt is in club Ladies, new role = ladiesclub
User ellis-styles is in club Men, new role = mensclub
User emma-webbygmail-com is in club Juniors, new role = juniorsclub
User eric-finch is in club Men, new role = mensclub
User lynda-atherton is in club Ladies, new role = ladiesclub
User Lucy Bamford is in club Ladies, new role = ladiesclub
User Fiona Hobbs is in club Ladies, new role = ladiesclub
User flahertyhomesaol-co-uk is in club Men, new role = mensclub
User fssslhotmail-com is in club Men, new role = mensclub
User Gail Brown is in club Ladies, new role = ladiesclub
User gareth-smith is in club Men, new role = mensclub
User garry-white is in club Men, new role = mensclub
User richard-gater is in club Men, new role = mensclub
User geoff-blewett is in club Men, new role = mensclub
User george-friedman is in club Men, new role = mensclub
User george-richardson is in club Men, new role = mensclub
User gilberttonylive-co-uk is in club Men, new role = mensclub
User gillian-cain is in club Ladies, new role = ladiesclub
User globetrotter1978hotmail-co-uk is in club Men, new role = mensclub
User gloria-cooper is in club Ladies, new role = ladiesclub
User graemeclark1986gmail-com is in club Men, new role = mensclub
User graham-dibley is in club Men, new role = mensclub
User greg_crouch2003yahoo-co-uk is in club Men, new role = mensclub
User grogers is in club Men, new role = mensclub
User gvgareth72gmail-com is in club Men, new role = mensclub
User gwen-williams is in club Men, new role = mensclub
User bibi-lindsay is in club Ladies, new role = ladiesclub
User peter-harris is in club Men, new role = mensclub
User hazel-rogers is in club Ladies, new role = ladiesclub
User harjinder-chana is in club Men, new role = mensclub
User heather_hamerhotmail-com is in club Juniors, new role = juniorsclub
User hedda-witkowski is in club Ladies, new role = ladiesclub
User ian-goodall is in club Men, new role = mensclub
User iain-wilson is in club Men, new role = mensclub
User ian-holder is in club Men, new role = mensclub
User ian-kershaw is in club Men, new role = mensclub
User isla_priceicloud-com is in club Juniors, new role = juniorsclub
User john-whiteway is in club Men, new role = mensclub
User jeremy-kivell is in club Men, new role = mensclub
User james-gibbs is in club Men, new role = mensclub
User dave-saunders is in club Men, new role = mensclub
User jadavme-com is in club Juniors, new role = juniorsclub
User jadavsky-com is in club Men, new role = mensclub
User jamacia9hotmail-com is in club Men, new role = mensclub
User james-ewartnats-co-uk is in club Juniors, new role = juniorsclub
User james-treweek is in club Men, new role = mensclub
User jamestslive-co-uk is in club Juniors, new role = juniorsclub
User jamied195hotmail-co-uk is in club Men, new role = mensclub
User jamie-mills is in club Men, new role = mensclub
User jamietsheehanhotmail-com is in club Men, new role = mensclub
User john-carpmail is in club Men, new role = mensclub
User jeffdmclellangmail-com is in club Men, new role = mensclub
User jenn-clarke is in club Ladies, new role = ladiesclub
User jim-saunders is in club Men, new role = mensclub
User john-ibbotson is in club Men, new role = mensclub
User jeff-retallic is in club Men, new role = mensclub
User oliver-mosses is in club Men, new role = mensclub
User jo-lawton-davies is in club Ladies, new role = ladiesclub
User Jo Martin is in club Ladies, new role = ladiesclub
User joe-saunders is in club Men, new role = mensclub
User johnledgard47gmail-com is in club Men, new role = mensclub
User jon-piper is in club Men, new role = mensclub
User jon-charlton is in club Men, new role = mensclub
User jonesdave42yahoo-com is in club Men, new role = mensclub
User jpenfold is in club Men, new role = mensclub
User jrmultalktalk-net is in club Men, new role = mensclub
User Mrs Julia Weston is in club Ladies, new role = ladiesclub
User julian-david is in club Men, new role = mensclub
User kevin-maguire is in club Men, new role = mensclub
User keith-mcgroary is in club Men, new role = mensclub
User kathryn-price is in club Ladies, new role = ladiesclub
User kenneth-paul is in club Men, new role = mensclub
User ken-robinson is in club Men, new role = mensclub
User kevin_kinghotmail-co-uk is in club Men, new role = mensclub
User kevin-lowen is in club Men, new role = mensclub
User kevin-lee is in club Men, new role = mensclub
User karen-foan is in club Ladies, new role = ladiesclub
User Kim O'leary is in club Ladies, new role = ladiesclub
User kirrill-bates is in club Men, new role = mensclub
User Bobby David is in club Men, new role = mensclub
User Louise Birley is in club Ladies, new role = ladiesclub
User leefurneaux76outlook-com is in club Men, new role = mensclub
User leehaslem91gmail-com is in club Men, new role = mensclub
User les-smith is in club Men, new role = mensclub
User lisa-keightleyecb-co-uk is in club Ladies, new role = ladiesclub
User linda-mcleod is in club Ladies, new role = ladiesclub
User lloydjhs is in club Men, new role = mensclub
User lynda-moore is in club Ladies, new role = ladiesclub
User lowey5364gmail-com is in club Men, new role = mensclub
User lucybamfyahoo-com is in club Ladies, new role = ladiesclub
User luke-dozier is in club Men, new role = mensclub
User luke-wicks is in club Men, new role = mensclub
User lynda-hammond is in club Ladies, new role = ladiesclub
User lynnewhatsithotmail-com is in club Juniors, new role = juniorsclub
User maureen-barnville is in club Ladies, new role = ladiesclub
User martyn-osment is in club Men, new role = mensclub
User mackey-james is in club Men, new role = mensclub
User Don Magill is in club Men, new role = mensclub
User mally is in club Men, new role = mensclub
User mandy-creed is in club Ladies, new role = ladiesclub
User manwaringsacrispins-co-uk is in club Juniors, new role = juniorsclub
User Margit Demiriz is in club Ladies, new role = ladiesclub
User Margot Mccann is in club Ladies, new role = ladiesclub
User Maria Thorpe is in club Ladies, new role = ladiesclub
User mark-norris is in club Men, new role = mensclub
User mark-pearson is in club Men, new role = mensclub
User mark-read is in club Men, new role = mensclub
User mark-atherton is in club Men, new role = mensclub
User mark-ingram is in club Men, new role = mensclub
User marleysgennacegmail-com is in club Juniors, new role = juniorsclub
User martin-gigg is in club Men, new role = mensclub
User martin-shimmen is in club Men, new role = mensclub
User martin-dozier is in club Men, new role = mensclub
User martinriches is in club Men, new role = mensclub
User martin-newport is in club Men, new role = mensclub
User martyn_vinehotmail-com is in club Men, new role = mensclub
User martyn-billers is in club Men, new role = mensclub
User matt-whiddett is in club Men, new role = mensclub
User Maureen Webb is in club Ladies, new role = ladiesclub
User george-mccormack is in club Men, new role = mensclub
User Mia Hynes is in club Ladies, new role = ladiesclub
User michael-storey is in club Men, new role = mensclub
User michael-mortensen is in club Men, new role = mensclub
User mike-frawley is in club Men, new role = mensclub
User mikerees47hotmail-co-uk is in club Men, new role = mensclub
User terry-mitchell is in club Men, new role = mensclub
User matthew-storey is in club Men, new role = mensclub
User jon-morley is in club Men, new role = mensclub
User stuart-morrant is in club Men, new role = mensclub
User matthew-irving is in club Men, new role = mensclub
User mthornton is in club Juniors, new role = juniorsclub
User john-allen is in club Men, new role = mensclub
User nathan-lake is in club Men, new role = mensclub
User neil-docherty is in club Men, new role = mensclub
User Nelina Ladak is in club Ladies, new role = ladiesclub
User ian-nicholson is in club Men, new role = mensclub
User nick-mcconnachie is in club Men, new role = mensclub
User nicholas-murtagh is in club Men, new role = mensclub
User nina-taylor is in club Ladies, new role = ladiesclub
User nigel-nutsford is in club Men, new role = mensclub
User michael-moran is in club Men, new role = mensclub
User norma-moran is in club Ladies, new role = ladiesclub
User orlaniamhfrawley1outlook-com is in club Juniors, new role = juniorsclub
User panda_bear5hotmail-co-uk is in club Juniors, new role = juniorsclub
User Pamela King is in club Ladies, new role = ladiesclub
User patricia-bayle is in club Ladies, new role = ladiesclub
User patbikerukhotmail-com is in club Juniors, new role = juniorsclub
User patel_neenahotmail-com is in club Ladies, new role = ladiesclub
User paul-kinton is in club Men, new role = mensclub
User paul-stephens is in club Men, new role = mensclub
User paul-raine is in club Men, new role = mensclub
User pccarpentry84gmail-com is in club Men, new role = mensclub
User penny-gillham is in club Ladies, new role = ladiesclub
User pete-toomey is in club Men, new role = mensclub
User peter-frost is in club Men, new role = mensclub
User peter-dhesi is in club Men, new role = mensclub
User peter-strange4btinternet-com is in club Men, new role = mensclub
User mark-pettitt is in club Men, new role = mensclub
User phil-barriballbtinternet-com is in club Men, new role = mensclub
User phillcarpmailuwclub-net is in club Men, new role = mensclub
User Pili Belgrano is in club Ladies, new role = ladiesclub
User pippalongfieldicloud-com is in club Juniors, new role = juniorsclub
User andrew-powell is in club Men, new role = mensclub
User Peter Collins is in club Men, new role = mensclub
User qinchengukgmail-com is in club Men, new role = mensclub
User richard-powell is in club Men, new role = mensclub
User ranjeev-singh is in club Men, new role = mensclub
User ray-williams is in club Men, new role = mensclub
User Suzanne Richards is in club Ladies, new role = ladiesclub
User Reg Todd is in club Men, new role = mensclub
User reynold-serrant is in club Men, new role = mensclub
User riaan-matthysen2gmail-com is in club Men, new role = mensclub
User rian_nobeshotmail-co-uk is in club Men, new role = mensclub
User richard-lansley123live-com is in club Men, new role = mensclub
User katy-lansley is in club Ladies, new role = ladiesclub
User richard-serrano is in club Men, new role = mensclub
User richardpaylergmail-com is in club Men, new role = mensclub
User matthew-richards is in club Men, new role = mensclub
User ritva-dean is in club Ladies, new role = ladiesclub
User richard-langley is in club Men, new role = mensclub
User rob-price is in club Men, new role = mensclub
User robschulz50hotmail-com is in club Men, new role = mensclub
User rod-clay is in club Men, new role = mensclub
User roger-newportyahoo-co-uk is in club Men, new role = mensclub
User Ros Weir is in club Ladies, new role = ladiesclub
User rrpbkupgmail-com is in club Men, new role = mensclub
User ronnie-turner is in club Men, new role = mensclub
User Samantha Cook is in club Ladies, new role = ladiesclub
User samuk1me-com is in club juniors, new role = subscriber
User sandra-cook is in club Ladies, new role = ladiesclub
User sandra-hall is in club Ladies, new role = ladiesclub
User Sandy Kinch is in club Ladies, new role = ladiesclub
User sara_and_yveshotmail-com is in club Juniors, new role = juniorsclub
User james-r-saunders is in club Men, new role = mensclub
User bill-furlong is in club Men, new role = mensclub
User sbrooker22 is in club Men, new role = mensclub
User Stephen Gadd is in club Men, new role = mensclub
User scottbailey19hotmail-com is in club Men, new role = mensclub
User scottsiggeryyahoo-com is in club Men, new role = mensclub
User sally-cushing is in club Ladies, new role = ladiesclub
User steve-cross is in club Men, new role = mensclub
User sean-wheatley is in club Men, new role = mensclub
User selectroofingukgmail-com is in club Men, new role = mensclub
User simon-gwyn-griffiths is in club Men, new role = mensclub
User simon-stephens is in club Men, new role = mensclub
User Simon Trevena is in club Men, new role = mensclub
User sonoko-gauci is in club Ladies, new role = ladiesclub
User jim-spencer is in club Men, new role = mensclub
User steve_eaton21hotmail-com is in club Men, new role = mensclub
User steve-hambly is in club Men, new role = mensclub
User steve-wallace is in club Men, new role = mensclub
User stevejshawhotmail-co-uk is in club Men, new role = mensclub
User Steven Jones is in club Men, new role = mensclub
User stuart-snelling is in club Men, new role = mensclub
User Sue French is in club Ladies, new role = ladiesclub
User Sue Collins is in club Ladies, new role = ladiesclub
User susan-lucas is in club Ladies, new role = ladiesclub
User sungsun74 is in club Men, new role = mensclub
User tagtheeagle2919gmail-com is in club Men, new role = mensclub
User tim-challender is in club Men, new role = mensclub
User tom-considine is in club Men, new role = mensclub
User ted-rogers is in club Men, new role = mensclub
User terry-kennewell is in club Men, new role = mensclub
User terrytwosipsyahoo-com is in club Men, new role = mensclub
User tested is in club , new role = subscriber
User texpatbritgmail-com is in club Ladies, new role = ladiesclub
User the_golf_tee_junctionhotmail-com is in club Men, new role = mensclub
User neil-davies is in club Men, new role = mensclub
User graham-champion is in club Men, new role = mensclub
User millie-millar is in club Ladies, new role = ladiesclub
User Lorraine Sharpe is in club Ladies, new role = ladiesclub
User ish-thomson is in club Ladies, new role = ladiesclub
User tim-grover is in club Men, new role = mensclub
User tony-spiller is in club Men, new role = mensclub
User topdanil is in club Juniors, new role = juniorsclub
User tom-evans is in club Men, new role = mensclub
User trevor-knight is in club Men, new role = mensclub
User tysterryme-com is in club Men, new role = mensclub
User reiko-bennett is in club Ladies, new role = ladiesclub
User Vicki Doran is in club Ladies, new role = ladiesclub
User vivrlovellgmail-com is in club Ladies, new role = ladiesclub
User warren-williams is in club Men, new role = mensclub
User will-everard is in club Men, new role = mensclub
User woods-leehotmail-co-uk is in club Men, new role = mensclub
User martin-king is in club Men, new role = mensclub