9yqvca_

9yqvca_

Replacing all instances of database prefix with mixed case letters

Number of rows = 9550

Correcting group memberships for members

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 alistair-smith is in club Men, new role = mensclub

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 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 chris-corbett is in club Men, new role = mensclub

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 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 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_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-2 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 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 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 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 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 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 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 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-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 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 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 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 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 penny-gillham is in club Ladies, new role = ladiesclub

User pete-toomey is in club Men, new role = mensclub

User Daniel Murray 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 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 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 david-smith is in club Men, new role = mensclub

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 sally-cushing is in club Ladies, new role = ladiesclub

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-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 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