INSERT INTO `wlcj_rg_lead_detail` VALUES (447007, 28970, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447008, 28970, 8, '15', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447009, 28970, 8, '16', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447010, 28970, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447011, 28970, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447012, 28970, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447013, 28970, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447014, 28971, 8, '1', 'Mr D.H.JOHNSON'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447015, 28971, 8, '2', 'davijon@gmx.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447016, 28971, 8, '3', 'PO11 0EX'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447017, 28971, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447018, 28971, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447019, 28971, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447020, 28971, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447021, 28971, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447022, 28971, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447023, 28971, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447024, 28971, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447025, 28971, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447026, 28971, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447027, 28971, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447028, 28971, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447029, 28971, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447030, 28971, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447031, 28971, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447032, 28972, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447033, 28972, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447034, 28972, 1, '1', 'Alex'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447035, 28972, 1, '27', 'Stypulkowski'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447036, 28972, 1, '2', '1986-09-17'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447037, 28972, 1, '10', '9246390001'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447038, 28972, 1, '3', '07727259611'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447039, 28972, 1, '4', 'stypulkowski@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447040, 28972, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447041, 28972, 1, '8', '25 The Scimitars, Stubbington, Fareham.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447042, 28972, 1, '9', 'PO14 3RW'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447043, 28972, 1, '12', '2018-04-20'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447044, 28972, 1, '13', 'Zoe Secret'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447045, 28972, 1, '16', '1 Cowdray Park, Stubbington, Fareham'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447046, 28972, 1, '17', 'PO14 3SA'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447047, 28972, 1, '33', '4'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447048, 28972, 1, '34', '3'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447049, 28972, 1, '19', '2018-04-20'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447050, 28972, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447051, 28973, 8, '1', 'Joshua Smith'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447052, 28973, 8, '2', 'joshuasmith991@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447053, 28973, 8, '3', 'PO5 3JR'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447054, 28973, 8, '6', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447055, 28973, 8, '7', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447056, 28973, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447057, 28973, 8, '9', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447058, 28973, 8, '10', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447059, 28973, 8, '11', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447060, 28973, 8, '12', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447061, 28973, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447062, 28973, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447063, 28973, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447064, 28973, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447065, 28973, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447066, 28973, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447067, 28973, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447068, 28973, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447069, 28974, 8, '1', 'Christopher Allwood'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447070, 28974, 8, '2', 'chr.allwood@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447071, 28974, 8, '3', 'PO22 8FA'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447072, 28974, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447073, 28974, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447074, 28974, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447075, 28974, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447076, 28974, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447077, 28974, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447078, 28974, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447079, 28974, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447080, 28974, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447081, 28974, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447082, 28974, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447083, 28974, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447084, 28974, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447085, 28974, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447086, 28974, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447087, 28974, 8, '21', 'No that\'s fine thanks'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447088, 28975, 8, '1', 'Brian Wilmers'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447089, 28975, 8, '2', 'brian.wilmers@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447090, 28975, 8, '3', 'PO22 6BH'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447091, 28975, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447092, 28975, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447093, 28975, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447094, 28975, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447095, 28975, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447096, 28975, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447097, 28975, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447098, 28975, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447099, 28975, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447100, 28975, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447101, 28975, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447102, 28975, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447103, 28975, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447104, 28975, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447105, 28975, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447106, 28976, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447107, 28976, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447108, 28976, 1, '1', 'David'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447109, 28976, 1, '27', 'Seager'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447110, 28976, 1, '2', '1958-04-10'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447111, 28976, 1, '3', '07733412404'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447112, 28976, 1, '4', 'seagernicola@yahoo.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447113, 28976, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447114, 28976, 1, '8', 'Waterloolville'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447115, 28976, 1, '9', 'PO8 8RH'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447116, 28976, 1, '11', 'Hampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447117, 28976, 1, '35', 'Hampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447118, 28976, 1, '12', '2018-05-01'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447119, 28976, 1, '16', '17 Fernlea Avenue, Oswaldwistle, Accrington, BB5 3TJ'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447120, 28976, 1, '17', 'BB5 3TJ'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447121, 28976, 1, '33', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447122, 28976, 1, '34', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447123, 28976, 1, '19', '2018-05-01'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447124, 28976, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447125, 28977, 8, '1', 'Samantha Brown'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447126, 28977, 8, '2', 'sb00279@googlemail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447127, 28977, 8, '3', 'PO4 9AD'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447128, 28977, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447129, 28977, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447130, 28977, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447131, 28977, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447132, 28977, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447133, 28977, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447134, 28977, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447135, 28977, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447136, 28977, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447137, 28977, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447138, 28977, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447139, 28977, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447140, 28977, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447141, 28977, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447142, 28977, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447143, 28978, 1, '5', 'New Customer'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447144, 28978, 1, '7', 'Miss'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447145, 28978, 1, '1', 'Tamsin Isabella'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447146, 28978, 1, '27', 'McCorkell'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447147, 28978, 1, '2', '1987-09-12'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447148, 28978, 1, '3', '07884440881'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447149, 28978, 1, '4', 'tamsin.mccorkell@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447150, 28978, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447151, 28978, 1, '16', '214A London Road,\r\nPortsmouth \r\nHampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447152, 28978, 1, '17', 'PO2 9JE'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447153, 28978, 1, '33', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447154, 28978, 1, '34', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447155, 28978, 1, '19', '2018-04-14'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447156, 28978, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447157, 28979, 8, '1', 'John Halliday'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447158, 28979, 8, '2', 'johnandalice@halliday.org.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447159, 28979, 8, '3', 'PO19 5PX'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447160, 28979, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447161, 28979, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447162, 28979, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447163, 28979, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447164, 28979, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447165, 28979, 8, '11', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447166, 28979, 8, '12', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447167, 28979, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447168, 28979, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447169, 28979, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447170, 28979, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447171, 28979, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447172, 28979, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447173, 28979, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447174, 28979, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447175, 28980, 8, '1', 'Sophie Clifford'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447176, 28980, 8, '2', 'sophieclifford21@aol.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447177, 28980, 8, '3', 'PO3 5AA'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447178, 28980, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447179, 28980, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447180, 28980, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447181, 28980, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447182, 28980, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447183, 28980, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447184, 28980, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447185, 28980, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447186, 28980, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447187, 28980, 8, '15', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447188, 28980, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447189, 28980, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447190, 28980, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447191, 28980, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447192, 28980, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447193, 28981, 8, '1', 'Trevor Sawyer'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447194, 28981, 8, '2', 'greensontour@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447195, 28981, 8, '3', 'SO32 1SF'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447196, 28981, 8, '6', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447197, 28981, 8, '7', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447198, 28981, 8, '8', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447199, 28981, 8, '9', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447200, 28981, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447201, 28981, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447202, 28981, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447203, 28981, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447204, 28981, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447205, 28981, 8, '15', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447206, 28981, 8, '16', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447207, 28981, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447208, 28981, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447209, 28981, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447210, 28981, 8, '20', 'Website'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447211, 28981, 8, '21', 'Would like to know more about reservoir construction, especially it\'s impact on nature and wildlife.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447212, 28982, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447213, 28982, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447214, 28982, 1, '1', 'Alexander'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447215, 28982, 1, '27', 'Kao'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447216, 28982, 1, '2', '1988-10-01'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447217, 28982, 1, '10', '9437795202'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447218, 28982, 1, '3', '07592134959'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447219, 28982, 1, '4', 'alex.p.kao@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447220, 28982, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447221, 28982, 1, '8', 'Flat 10 Warrior Court\r\nMumby Road\r\nGosport'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447222, 28982, 1, '9', 'PO12 1BS'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447223, 28982, 1, '12', '2018-04-27'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447224, 28982, 1, '16', '18 The Malthouse Apartments\r\nSalt Meat Lane\r\nGosport'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447225, 28982, 1, '17', 'PO12 1GJ'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447226, 28982, 1, '33', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447227, 28982, 1, '34', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447228, 28982, 1, '19', '2018-04-27'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447229, 28982, 1, '20', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447230, 28982, 1, '22', 'Current Landlord'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447231, 28982, 1, '23', 'Unknown'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447232, 28982, 1, '25', 'Existing landlord is responsible for the water rates at the new address.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447233, 28983, 8, '1', 'Ben Swarbrick'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447234, 28983, 8, '2', 'benswarb@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447235, 28983, 8, '3', 'po5 1ns'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447236, 28983, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447237, 28983, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447238, 28983, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447239, 28983, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447240, 28983, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447241, 28983, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447242, 28983, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447243, 28983, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447244, 28983, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447245, 28983, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447246, 28983, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447247, 28983, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447248, 28983, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447249, 28983, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447250, 28983, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447251, 28984, 8, '1', 'Misha Soper'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447252, 28984, 8, '2', 'mishapovey8@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447253, 28984, 8, '3', 'Po12 3jd'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447254, 28984, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447255, 28984, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447256, 28984, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447257, 28984, 8, '9', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447258, 28984, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447259, 28984, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447260, 28984, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447261, 28984, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447262, 28984, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447263, 28984, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447264, 28984, 8, '16', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447265, 28984, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447266, 28984, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447267, 28984, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447268, 28984, 8, '20', 'Website'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447269, 28985, 8, '1', 'Clive Williams'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447270, 28985, 8, '2', 'clives.williams@yahoo.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447271, 28985, 8, '3', 'PO4 9PR'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447272, 28985, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447273, 28985, 8, '7', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447274, 28985, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447275, 28985, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447276, 28985, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447277, 28985, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447278, 28985, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447279, 28985, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447280, 28985, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447281, 28985, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447282, 28985, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447283, 28985, 8, '17', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447284, 28985, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447285, 28985, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447286, 28985, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447287, 28986, 8, '1', 'Sarah Bayliss'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447288, 28986, 8, '2', 'sarahlouisebayliss@yahoo.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447289, 28986, 8, '3', 'PO12 4AR'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447290, 28986, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447291, 28986, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447292, 28986, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447293, 28986, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447294, 28986, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447295, 28986, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447296, 28986, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447297, 28986, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447298, 28986, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447299, 28986, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447300, 28986, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447301, 28986, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447302, 28986, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447303, 28986, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447304, 28986, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447305, 28986, 8, '21', 'I think more information about water meters needs to be available. I recently moved to a house where a meter  was already installed and at first I saw that as a bad thing but not only has it saved us money, it is also encouraging us to be more careful with the water we use. I think better education is needed so that people don\'t take water for granted.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447306, 28987, 8, '1', 'Sean Whitear'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447307, 28987, 8, '2', 'sswhitear@btinternet.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447308, 28987, 8, '3', 'PO16 7TL'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447309, 28987, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447310, 28987, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447311, 28987, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447312, 28987, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447313, 28987, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447314, 28987, 8, '11', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447315, 28987, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447316, 28987, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447317, 28987, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447318, 28987, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447319, 28987, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447320, 28987, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447321, 28987, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447322, 28987, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447323, 28987, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447324, 28988, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447325, 28988, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447326, 28988, 1, '1', 'William'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447327, 28988, 1, '27', 'Burt'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447328, 28988, 1, '2', '1957-03-03'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447329, 28988, 1, '3', '07808724129'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447330, 28988, 1, '4', 'williamburt@btinternet.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447331, 28988, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447332, 28988, 1, '8', 'Flat 1 , 124 High Street\r\nPortsmouth'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447333, 28988, 1, '9', 'Po1 2hw'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447334, 28988, 1, '12', '2018-04-21'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447335, 28988, 1, '16', '70 High street\r\nPortsmouth'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447336, 28988, 1, '17', 'Po1 2hh'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447337, 28988, 1, '33', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447338, 28988, 1, '34', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447339, 28988, 1, '19', '2018-04-16'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447340, 28988, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447341, 28988, 1, '29', 'I do not know the serial number of the meter at the previous address or the reading. We were there from 22nd January to 22nd April, 3 months'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447342, 28989, 8, '1', 'hayley lawrance'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447343, 28989, 8, '2', 'hlawrance1989@hotmail.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447344, 28989, 8, '3', 'po193px'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447345, 28989, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447346, 28989, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447347, 28989, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447348, 28989, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447349, 28989, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447350, 28989, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447351, 28989, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447352, 28989, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447353, 28989, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447354, 28989, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447355, 28989, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447356, 28989, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447357, 28989, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447358, 28989, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447359, 28989, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447360, 28990, 1, '5', 'New Customer'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447361, 28990, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447362, 28990, 1, '1', 'Allen'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447363, 28990, 1, '27', 'Stoner'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447364, 28990, 1, '2', '1969-09-05'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447365, 28990, 1, '3', '07415103616'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447366, 28990, 1, '4', 'allen.stoner@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447367, 28990, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447368, 28990, 1, '16', '111 Hangar Drive\r\nTangmere\r\nChichester\r\nWest Sussex'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447369, 28990, 1, '17', 'PO20 2EB'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447370, 28990, 1, '33', '4'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447371, 28990, 1, '34', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447372, 28990, 1, '36', '16M440090'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447373, 28990, 1, '37', '61.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447374, 28990, 1, '19', '2018-03-29'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447375, 28990, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447376, 28991, 1, '5', 'New Customer'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447377, 28991, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447378, 28991, 1, '1', 'Jamie'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447379, 28991, 1, '27', 'Smith'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447380, 28991, 1, '2', '1989-12-04'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447381, 28991, 1, '3', '07540956506'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447382, 28991, 1, '4', 'jamiesmith1989@virginmedia.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447383, 28991, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447384, 28991, 1, '16', '4 Utah Close, Fareham, Hampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447385, 28991, 1, '17', 'PO14 1FT'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447386, 28991, 1, '33', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447387, 28991, 1, '34', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447388, 28991, 1, '19', '2018-04-28'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447389, 28991, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447390, 28992, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447391, 28992, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447392, 28992, 1, '1', 'Arvin'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447393, 28992, 1, '27', 'Mirzadeh'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447394, 28992, 1, '2', '1981-10-04'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447395, 28992, 1, '10', '9420232301'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447396, 28992, 1, '3', '07715 357326'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447397, 28992, 1, '4', 'arvin@vitality-dental.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447398, 28992, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447399, 28992, 1, '8', '16 Bankfield\r\nCharlton Road\r\nSingleton'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447400, 28992, 1, '9', 'PO18 0HS'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447401, 28992, 1, '35', 'n/a'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447402, 28992, 1, '12', '2018-04-18'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447403, 28992, 1, '13', 'The Goodwood Estate'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447404, 28992, 1, '16', 'Bushovel Farm, Steyning Road\r\nWiston'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447405, 28992, 1, '17', 'BN44 3DD'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447406, 28992, 1, '33', '3'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447407, 28992, 1, '34', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447408, 28992, 1, '36', 'none'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447409, 28992, 1, '37', 'none'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447410, 28992, 1, '19', '2018-04-18'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447411, 28992, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447412, 28992, 1, '29', 'new address is on private water supply. please just close my old account down.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447413, 28993, 8, '1', 'Simon Flew'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447414, 28993, 8, '2', 'simon.flew@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447415, 28993, 8, '3', 'PO15 5HH'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447416, 28993, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447417, 28993, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447418, 28993, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447419, 28993, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447420, 28993, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447421, 28993, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447422, 28993, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447423, 28993, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447424, 28993, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447425, 28993, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447426, 28993, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447427, 28993, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447428, 28993, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447429, 28993, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447430, 28993, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447431, 28994, 8, '1', 'John Mathews'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447432, 28994, 8, '2', 'j341mathews@btinternet.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447433, 28994, 8, '3', 'PO20 0LG'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447434, 28994, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447435, 28994, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447436, 28994, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447437, 28994, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447438, 28994, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447439, 28994, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447440, 28994, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447441, 28994, 8, '13', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447442, 28994, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447443, 28994, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447444, 28994, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447445, 28994, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447446, 28994, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447447, 28994, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447448, 28994, 8, '20', 'Website'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447449, 28994, 8, '21', '15% leakage reduction by 2025 seems insufficient.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447450, 28995, 8, '1', 'Anna'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447451, 28995, 8, '2', 'anna_conda987@yahoo.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447452, 28995, 8, '3', 'PO5 1SG'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447453, 28995, 8, '6', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447454, 28995, 8, '7', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447455, 28995, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447456, 28995, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447457, 28995, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447458, 28995, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447459, 28995, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447460, 28995, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447461, 28995, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447462, 28995, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447463, 28995, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447464, 28995, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447465, 28995, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447466, 28995, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447467, 28995, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447468, 28996, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447469, 28996, 1, '7', 'Mr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447470, 28996, 1, '1', 'Daniel'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447471, 28996, 1, '27', 'Laczynski'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447472, 28996, 1, '2', '1985-12-11'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447473, 28996, 1, '10', '9438957601'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447474, 28996, 1, '3', '07724546055'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447475, 28996, 1, '4', 'daniellaczynski@wp.pl'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447476, 28996, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447477, 28996, 1, '8', '2 Osprey Gardens'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447478, 28996, 1, '9', 'PO22 9QG'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447479, 28996, 1, '12', '2018-05-15'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447480, 28996, 1, '16', 'Ul. Siedlecka 10\r\nOsieck\r\nPoland'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447481, 28996, 1, '17', '08-445'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447482, 28996, 1, '33', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447483, 28996, 1, '34', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447484, 28996, 1, '19', '2018-05-15'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447485, 28996, 1, '20', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447486, 28997, 8, '1', 'Billy Egginton'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447487, 28997, 8, '2', 'begginton88@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447488, 28997, 8, '3', 'Po7 8ha'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447489, 28997, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447490, 28997, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447491, 28997, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447492, 28997, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447493, 28997, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447494, 28997, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447495, 28997, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447496, 28997, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447497, 28997, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447498, 28997, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447499, 28997, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447500, 28997, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447501, 28997, 8, '18', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447502, 28997, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447503, 28997, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447504, 28998, 8, '1', 'Mr T R Cattermole'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447505, 28998, 8, '2', 'catz2@wanadoo.fr'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447506, 28998, 8, '3', 'PO5 2BL'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447507, 28998, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447508, 28998, 8, '7', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447509, 28998, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447510, 28998, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447511, 28998, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447512, 28998, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447513, 28998, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447514, 28998, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447515, 28998, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447516, 28998, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447517, 28998, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447518, 28998, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447519, 28998, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447520, 28998, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447521, 28998, 8, '20', 'Website'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447522, 28998, 8, '21', 'Lived in France for 25 years  1990-2015 in an area where meters are compulsory.  Taught us to be frugal with  water and recycle all the time eg using a container to trap cold run-off before showering, washing up, and any use of hot water, using washing up/cooking water for the vegetable patch and not flushing the loo every time we had a pee !  The loo also had a half-flush facility - and if it didn\'t, a brick in the cistern worked a treat.\r\n\r\nA well-thought out plan with the Thicket Reservoir being long- needed and overdue - I\'m looking forward to what will be an outstanding local amenity.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447523, 28999, 8, '1', 'Catherine Morris'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447524, 28999, 8, '2', 'catherinemorris182@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447525, 28999, 8, '3', 'PO9 5QG'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447526, 28999, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447527, 28999, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447528, 28999, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447529, 28999, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447530, 28999, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447531, 28999, 8, '11', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447532, 28999, 8, '12', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447533, 28999, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447534, 28999, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447535, 28999, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447536, 28999, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447537, 28999, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447538, 28999, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447539, 28999, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447540, 28999, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447541, 29000, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447542, 29000, 1, '7', 'Miss'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447543, 29000, 1, '1', 'Katie'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447544, 29000, 1, '27', 'Thatcher'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447545, 29000, 1, '2', '1988-09-03'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447546, 29000, 1, '3', '07557378413'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447547, 29000, 1, '4', 'psy70694@myport.ac.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447548, 29000, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447549, 29000, 1, '8', '17 Mayfair court\r\n21 Parchment street'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447550, 29000, 1, '9', 'Po19 3ra'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447551, 29000, 1, '12', '2018-04-13'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447552, 29000, 1, '16', '44a East street'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447553, 29000, 1, '17', 'Po9 1AQ'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447554, 29000, 1, '33', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447555, 29000, 1, '34', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447556, 29000, 1, '19', '2018-04-13'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447557, 29000, 1, '20', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447558, 29000, 1, '22', 'Mr Tom Stamp'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447559, 29000, 1, '23', '07557378413'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447560, 29000, 1, '29', 'I have moved in with my partner who already has an account set up with you. I don\'t need a new account set up, just need my old account closed please.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447561, 29001, 8, '1', 'Dave Causer'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447562, 29001, 8, '2', 'davecauser1@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447563, 29001, 8, '3', 'Po16 8te'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447564, 29001, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447565, 29001, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447566, 29001, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447567, 29001, 8, '9', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447568, 29001, 8, '10', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447569, 29001, 8, '11', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447570, 29001, 8, '12', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447571, 29001, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447572, 29001, 8, '14', 'Don’t Know'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447573, 29001, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447574, 29001, 8, '16', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447575, 29001, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447576, 29001, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447577, 29001, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447578, 29001, 8, '20', 'Website'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447579, 29002, 8, '1', 'Christopher Stunt'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447580, 29002, 8, '2', 'cmstunt@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447581, 29002, 8, '3', 'PO3 6FB'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447582, 29002, 8, '6', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447583, 29002, 8, '7', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447584, 29002, 8, '8', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447585, 29002, 8, '9', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447586, 29002, 8, '10', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447587, 29002, 8, '11', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447588, 29002, 8, '12', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447589, 29002, 8, '13', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447590, 29002, 8, '14', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447591, 29002, 8, '15', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447592, 29002, 8, '16', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447593, 29002, 8, '17', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447594, 29002, 8, '18', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447595, 29002, 8, '19', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447596, 29002, 8, '20', 'Email'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447597, 29002, 8, '21', 'The plan seems very sound and fare.'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447598, 29003, 3, '39', 'Replace Name'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447599, 29003, 3, '7', 'Miss'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447600, 29003, 3, '1', 'Olivia'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447601, 29003, 3, '27', 'Needle'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447602, 29003, 3, '34', '1991-10-15'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447603, 29003, 3, '31', 'Mrs'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447604, 29003, 3, '30', 'Olivia'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447605, 29003, 3, '32', 'Muscat'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447606, 29003, 3, '3', '07407613604'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447607, 29003, 3, '4', 'oliviamuscat1991@gmail.com'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447608, 29003, 3, '16', '7 Crescent Road\r\nFareham \r\nHants'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447609, 29003, 3, '17', 'PO16 0HJ'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447610, 29003, 3, '43', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447611, 29003, 3, '42', '2'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447612, 29003, 3, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447613, 29004, 1, '5', 'Change of Address'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447614, 29004, 1, '7', 'Miss'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447615, 29004, 1, '1', 'Helen'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447616, 29004, 1, '27', 'Hearson'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447617, 29004, 1, '2', '1984-05-02'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447618, 29004, 1, '3', '07496182420'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447619, 29004, 1, '4', 'helenhearson@hotmail.co.uk'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447620, 29004, 1, '26.1', 'Yes'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447621, 29004, 1, '8', '44 Garnier Street\r\nPortsmouth\r\nHampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447622, 29004, 1, '9', 'PO1 1PD'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447623, 29004, 1, '11', 'Hampshire'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447624, 29004, 1, '12', '2018-04-10'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447625, 29004, 1, '16', '58 Spencer Street\r\nAccrington'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447626, 29004, 1, '17', 'BB5 6ST'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447627, 29004, 1, '33', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447628, 29004, 1, '34', '1'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447629, 29004, 1, '19', '2018-04-10'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447630, 29004, 1, '20', 'No'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447631, 29004, 1, '22', 'Unknown'); 
INSERT INTO `wlcj_rg_lead_detail` VALUES (447632, 29004, 1, '23', '00000000000');
#
# End of data contents of table `wlcj_rg_lead_detail`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_rg_lead_detail_long`


#
# Delete any existing table `wlcj_rg_lead_detail_long`
#



#
# Table structure of table `wlcj_rg_lead_detail_long`
#

CREATE TABLE `wlcj_rg_lead_detail_long` (
  `lead_detail_id` bigint unsigned NOT NULL,
  `value` longtext,
  PRIMARY KEY (`lead_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ;

#
# Data contents of table `wlcj_rg_lead_detail_long`
#
 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (333, 'Coming from drive onto pavement very green and slippery. Also just up from this address going towards traffic light there are two water outlets on the pavement with the same problem. Lost my footing yesterday because of this. Thanking you in this matter.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (2349, 'I currently reside at 92 Broyle Road Chichester Po19 6BE.\r\nThe property at Felpham has been empty but has new tenants form 1st May.\r\nAny overpayment can be let on account for payment for subsequent bills.\r\nFor either property.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (2852, 'Leak info taken in error. Not our area. \r\nCalled in by MR MEEK, but did not leave contact details.\r\n\r\nInfo from customer - CUSTOMER CALLED TO ADVISE OF A BUST MAIN HERE, HE ALSO ADVISED THAT THIS WAS A BUSY ROAD'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (4053, 'Not sure what type of leak this is it seems to be coming from up through the ground under my house to the front. It\'s only small but if left I can only imagine it getting worse. Woukd appreciate an expert coMing out to look at asap if possible please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (4696, 'Just before the water meter in our box at the front of the property. You can see the leak trickling down the side of the unit. The leak was initially reported a few weeks ago and we were told it would be dealt with within seven days. We have heard nothing from you since.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (5128, 'We were tenants at this address so the new bill payer is the landlord until new tenants move in. The phone number given for the new bill payer is for Hobdens estate agents who deal with the property on behalf of Ms Osborn (the landlord).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (5403, 'My new lettings agency has advised me that they will initiate the name change for water services on our new flat. please only send the last bill for the previous address to my new address & do not create a new account for me - this will be done by them. thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (5861, '35 Kingsley Road\r\nSouthsea, Hants\r\nPO48HJ\r\nI inherited this property on mother\'s death in January. I have now sold it, completion being next Thursday 21 May. Because property empty water was turned off, hence no consumption to record. Purchaser has agreed reading.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (7239, 'The road was recently resurfaced. This is the second leak I have reported to you - I live just around the corner from Aston Road.\r\nThe first was repaired some three weeks or so ago, and this latest is a few yards to the west of the repair patch.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (8337, 'There appears to be a leak in the middle of the B3334 Gosport Road, when travelling towards Stubbington from the Newgate Lane Roundabout.\r\n\r\nThere has been a constant wet patch & small puddle here for some months and don\'t know if it\'s been previously reported or you are aware.\r\n\r\nIt\'s approx. 325M from the roundabout, there\'s a road sign on the right and a blue plastic storage box on the left (cycle track).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (8362, 'Current address is 23 Seamist Solent Breezes\r\nWarsash SO31 9HG\r\n\r\npurchased 19 Warwick Close Lee On the Solent PO139AZ on 17/4/15\r\nit is being rented out and tenant takes over on 26/5/15  Nicky Milligan\r\nplease send invoice for period 17/4 to 26/5 to 23 Solent Breezes'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (10604, 'Not sure if you supply water to this building, but water and sewage are included in rent.\r\nPlease send me final bill for old property  to new address at \r\n4 Vista\r\nFratton Way, \r\nPO4 8FD, Southsea. \r\n Kind regards'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (12016, 'THIS LEAK HAS BEEN EVIDENT FOR ABOUT 3 DAYS. AS FAR AS I CAN DETERMINE IT IS \'OOZING\' SLIGHTLY FROM THE THE STOP COCK ACCESS \r\nPOINT AT THE BOUNDARY OF MY DRIVE. STOP COCK ABOUT 50CM IN DRAIN RECESS WHICH HAS FILLED WITH WATER AND NOW SLIGHTLY LEAKS ON TO AJOINING PUBLIC PATHWAY. AT THIS TIME NOT CONSIDERED A HAZARD BUT CLEARLY REQUIRES INVESTIGATION.\r\nTHANK YOU'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (13222, 'My partner and myself are no longer going to live together from July 31st onwards. I will however continue to live locally so I may need to carry forward the joint account\'s balance into my own sole account.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (13258, 'I have just acquired the above-addressed house.  Previous owner left water-services within the property in a bad way.  Specifically no one can find a mains tap within the bounds of the property.  To facilitate various repairs to domestic (water-using) appliances my plumber investigated the mains cock in the street outside the house and reports that your service is "in a very bad shape" and doesn\'t either shut down or open fully.  The house has a solar-energy system that relies on having various apparatus maintained with full flow of water. Can you please inspect your mains offtake-point and remedy any fault?  Thank you very much.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (13957, 'I have moved from my previously rented property (where I was responsible for all utility bills) to live with my landlady who owns both properties (25, Pryors Lane and 3, Brooks End) and I am now NOT responsible for any utility bills, it is an all-inclusive rental in my new property.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (14025, 'I have discovered a leak on the front lawn. I believed it was my neighbours, however they contacted Homesure who said it was not there leak, but also thought it was not mine either. The same location was dug around 2 years ago when the neighbours electricty cable had to be repaired. My water pipe was repaired with a inner sleeve along the pipe around 3 years ago.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (15281, 'Outside number 44 Victory Avenue Horndean PO8 9PJ\r\nWater is leaking from supply cover and by the kirb on the road and running down the road. It is a slow leak but looks as if it has been there for a while as green algae is growing in the water.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (15605, 'I am a tenant moving out of this flat which is being sold, completion date is on 19 June. I am temporarily moving in with my parents for a few months - their/my new address is 7 Clayhall Road, Gosport PO12 2BB\r\n\r\nPlease settle my account and confirm this email. Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (16827, 'I am the tenant at this property which is let through Beals Estate Agents in Gosport. The owner of the property pays for the water and sewage bills. I don\'t have his details but he is currently paying at the moment and will continue'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (17029, 'Noticed it\'s been leaking for at least 3 days, but it\'s nowhere near any houses.  You can see the leak clearly, as it runs into the southbound A3 London Road.  It might be running from the 1st house on the east of the bridge on Portsdown Hill I guess.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (17288, 'The stopcock is leaking again. The site of the leak is the blanking plug where a water meter would go. This is a recurrent problem probably due to the high water pressure (>5 bar).\r\nPlease could you find a permanent solution to this leak. \r\nThe stopcocks are located under my neighbours dustbins at the entrance to the property. Please note that the position of the stopcocks is reversed and that my stopcock is the one furthest from my house, the one nearest to my house supplies my neighbours.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (17451, 'I dug a hole in the front garden and found water at a depth of 10cm which continuously fills. The hole is approximately 2m from the boundary. This property does not have a water meter and shares a stop tap with next door (no. 4). The hole is close to the route of teh water supply pipe for both No. 5 and no. 7.  Therefore it is not possible to test if leak is after or before the stop tap in the pavement. I would be grateful if you could arrange for a leak test so that the leak can be confirmed and responsibility for repair determined.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (17585, 'At the end of Uplands Road on the small green outside No. 60 Uplands Road.  East Hampshire District Council (or whoever) have just cut the grass up this road and there is a deep gorge in the grass which is filling up with water.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (17592, 'At the end of Uplands Road on the small green outside No. 60 Uplands Road.  East Hampshire District Council (or whoever) have just cut the grass up this road and there is a deep gorge in the grass which is filling up with water.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (18735, 'I reported this leak in April 2014  After several visits to establish exactly where the leak was your staff found the cause was your mains supply and I was told it would be \r\nRepaired within 3 months.  The situation now is that the entrance to the railway line is now saturated,the men working on the lines have to wade through mud.  On top of this the water has now ingressed into my garden by about 6 feet and the whole place is alive with mosquitoes.  I am one of these people who is a mosquito magnet and it is. becoming most uncomfortable.  If this matter is not sorted out shortly I will have no option but to contact the Ombudsman.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (19778, 'We have had the fire hydrant on our site tested and they have provided the following information\r\n\r\n•	Hydrant pit is not draining sufficiently and would cause problems for fire service attending call out.\r\n•	We strongly recommend liaising with local authority water board to discuss repair.\r\n\r\nI am not sure if you cover this , can you please let us know if this is not the case'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (21163, 'I am letting out 105 Reginald Rd and the property is now managed by Martin & Co, Grove Rd South, Southsea, who will be in touch to supply the names etc. of the new tenants.\r\nMy partner Mr van de Griend and I are both living at 41 Hunter Rd.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (21393, 'Lorraine Johnson has moved out of 15 Cranleigh Road, and is now living with James Noble at 17 Lambert Close, who already has responsibility for paying the bills. The account for 17 Lambert Close does not need changing.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (22768, 'We have moved out of Flat 1, 10 South Parade, Southsea, Hampshire. We have returned to live with in-laws and we do not pay the bill at this property. Tom Knight is the new tenant at Flat 1, 10 South Parade.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (22794, 'My partner and I (Mr A J Gillon & Mr K Gillon) previously living with family at 7 Ford Road Gosport Hants PO12 3ET. Moved to 87 Avery Lane on the 27/06/15 we are both now responsible for the water bills at this address. Please advise us on the water rates and due dates \r\nKind Regards\r\nA J Gillon.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (22991, 'Please confirm what the charges will be and what we will be required to pay for at this address. \r\n\r\nPlease add my partner to the bill, Miss Isabelle Hooper, her contact number is 07818070191\r\n\r\nPlease contact me via email\r\n\r\nKindest regards\r\n\r\nDavid Massey'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23005, 'Please confirm what the charges will be and what we will be required to pay for at this address. \r\n\r\nPlease add my partner to the bill, Miss Isabelle Hooper, her contact number is 07818070191\r\n\r\nPlease contact me via email\r\n\r\nKindest regards\r\n\r\nDavid Massey'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23038, 'We are moving to the USA for 2 years, the property is being let to tenants through RPS Letting Agents, 181 High St, Lee on the Solent.\r\n\r\nExpecting tenants in the property from 18 July 2015 but I do not have their details, RPS should be able to provide the details.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23054, 'First time buyer previously living with parents so no previous address. \r\n\r\nPrevious owners have an outstanding bill which I\'ve forwarded to them to pay.\r\n\r\nI will be the sole occupant of this property.\r\n\r\nI\'m seperately requesting a meter to be installed.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23069, 'New customer so have applied seperately for an account. Would like to get the meter installed asap. \r\n\r\nHave checked the access point outside and cross checked with neighbours and I definitely don\'t currently have one.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23269, 'We are moving to the area from Botley where we were with Southern Water.  I believe our new house has a meter but we are not sure where the meter is located. As soon as we find out we will give you a meter reading. We are due to move on Friday 10th July.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (23823, 'You sent us a letter reference number 71838222, our last address was not in our name it was in my mother in laws name and she did not move with us to the above address.  She remarried and is now living at a different address.  \r\nWe moved into the house on 2nd July 2015 but completed on the house 20th April...we have not been living there for 3 months because of decorating so the house was unoccupied for this time apart from being over there after work to paint.\r\nWe now have tenants in our previous home which is 78 Valentine Close, Fareham, Hampshire, PO15 6SL.  It is up to them to sort out their own water bills.\r\nplease call me if there is confusion.\r\nRegards\r\nDiane Downey'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24363, 'We have been receiving unpaid bill letters address to previous tenants. Obviously we are only responsible for the usage from 1/6/15 as this is when we moved into the property. We have also been receiving letters from southern water about unpaid bills for a previous tenant; I\'m wondering why there are 2 suppliers, is this a mistake or does one provide water and one waste removal? Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24421, 'There is no meter set up at this address, I understand Portsmouth Water supplies water to the residence and Southern Water charges for waste water, I have had to pay an outstanding bill for the water used since the 1st July 2014 to Southern water. If I could be sent a bill for the water provided since this date also from this company. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24518, 'Hi there\r\n\r\nRental terminated on 09.07.15 at 24 anglesea road so we need to get a closing bill for this sent to 8 hoverfly close.  We are already set up at customers at our new address though so no action needed with this.\r\n\r\nKind regards\r\n\r\nMichelle'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24532, 'I am a new tenant and previously lived in a shared house where the rent included all services so I don\'t have a history of paying for water charges here in Portsmouth. I would also like to pay monthly by direct debit as I am on a pension only and wish to budget all my payments.\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24782, 'Myself and my Partner (Stephanie Wiggins) received a bill for the year on our current property but will be moving out at the end of the month. Please can you re issue the bill for only the month we will be in the property and then once paid close the account as we will be moving out of Portsmouth.\r\n\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (24842, 'I am currently still living in 6 Margaret Court till 15 July 2015. I am the legal owner of 96 Eastfield Road since 29/05/2015 which I will be moving to on the 15 July 2015. The people included in the current adress account (i.e. Mr Paul and Gabrielle Faehndrich have moved to switzerland and are not moving to my new address)'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25021, 'The address 128 newcome road po1 5dx is not a water meter\r\nThe address flat 4, 2 longridge road London sw5 9sl this address is my new address but the water bill is registered to my partners name already\r\nPlease call me on 07891415435'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25067, 'Hi,\r\n        We will be taking over the tenancy at 54 Spruce Avenue, Waterlooville, Hampshire, on the 29th July 2015, but will not be ceasing the tenancy at 127 Portchester Road, Portsmouth, Hampshire, until the 8th August 2015, as when we have moved out, we will need to go back and clean through etc.\r\n\r\nI have no knowledge as to where the water meters are in either property, so am unable to provide meter readings, until someone provides me information on this matter.\r\n\r\nBest regards\r\n\r\n\r\nIan Divers'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25174, 'There was lots of water pouring from the gutter which is spilling across the traffic lights from Southwick Hill Road onto the A3 London Road.  It wasn\'t as bad as yesterday but still needs looking at.  Not sure if it poses a problem for ambulances turning at high speed down the hill as they may possibly aquaplane on the surface water when on an emergency?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25191, 'A new account has already been set up at my new address in the Name of Abbie Edwards / David Broad. My previous address is a property I am currently renting out. The new tenant moves in on 17th July 2015.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25240, 'I am a single mum on tax credits, I was absolutely astonished how much more I have been paying than other mums living in similar properties, at least 3 times more!  I am also going to contact Southern Water regarding the amount that the\'yve been expecting me to pay, in excess of £500 per annum which has left me in debt and again is more than 3 times more than I should be paying.  I intend to speak with my local MP on this matter, as you should both be able to advise new customers roughly what their usage is likely to be.  I feel robbed of over a £1,000 which as a single mum and carer I can ill afford!  Please let me know when I\'m likely to have the meter installed?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25398, 'This is a rental house of which I am the landlord & owner .\r\n\r\nThe tenants left at midnight 30 June , so I will pay bills 1 July onwards until a new tenant arrives .\r\n\r\nPlease send bills to my home address :-\r\n36 Thistle Road , Hedge End Southampton , SO30 0TT'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25589, 'REFERENCE:  YOUR CUSTOMER:  MRS P FIRTH - 4 NORFOLK HOUSE   HAVANT   PO9 2RD\r\nACCOUNT NUMBER: 9163398301\r\n\r\nIn respect of the above named account I am now the Power of Attorney on my mothers bank account.  \r\nI wish to set up a Direct Debit to pay this bill. \r\n I need you therefore to change the account name as follows:\r\n\r\n"Mr N Firth - POA for Mrs P Firth"\r\nc/o 15 Wendover Road\r\n        Havant\r\n        PO9 1DJ\r\n\r\nI will download the Direct Debit Form and send that to you with any relevant information you may also need in order that this can be effected as soon as possible.\r\n\r\n\r\nNigel Firth'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (25862, 'We have just purchased the above property and we will need to undertake internal renovation as the property is currently not in a liveable state. We require you to arrange a water meter, is this possible?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (26556, 'opposite my house on pathway . Water coming up through water point. Noticed it this morning, but had been raining so didn\'t think anything of it, but got in this evening and ground still wet and water coming up through path.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (26788, 'I\'ve still been paying for the previous address as I haven\'t got round to notifying you. Not sure if anything can be done about this now but can you please move my account to new address. \r\nMany thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (26794, 'Outside the drive at the front of the house.  I am not sure that it is a leak, but there has been a puddle there for the last month, all through the dry weather so I think there might be a weak underneath.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (26911, 'PLEASE NOTE.\r\n97 Church Road, Hayling Island will be empty from the above date, and will shortly be put on the market. However, it will still be liable for water rates.\r\nPlease could you continue the existing Direct Debit for 97 Church Road Hayling Island, until you are notified of the change of ownership.\r\nPlease could you amend the address on the Hayling Island billing so bills are now sent to Alan Teush c/o 15 Monckton Road, Gosport, PO12 2BG.\r\nI have LPA for financial affairs and will be dealing with bills etc.\r\nIan Backhouse'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (26929, 'you had mr p gaffney and mrs p gaffney as account holders\r\nwas never mrs p gaffney always been mrs lynn gaffney and mr paul gaffney, but we have split up and mr gaffney no longer pay the bills. I have paid since april,2014.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27033, 'We actually move from previous address a week before we have to so there will be an overlap from previous to new address. We\'ve had the keys for the new address since the 7th July 2015 and have used some water and we are responsible for the water from that date.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27061, 'We are moving to this address on the 24/7/15 the present owner is Craig Palmer.\r\nWe don\'t know the meter readings yet. but will confirm on the day we move in.\r\nPlease could you also send a letter of confirmation asap or email a copy so I can take copy to Portsmouth city council as a form of ID to get a parking permit. This is all new to me the parking permits as we are moving from Basingstoke.\r\n\r\nMany thanks in advance for your help\r\n\r\nregards\r\n\r\nAmanda Byrne'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27074, 'Please locate mains stopcock in verge / pavement as not visible ,this is required to turn off supply to replace House stopcock.\r\nYour records will show I am also an existing customer at Applewood ( same post code )'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27331, 'I am an existing customer at 20 Bramley Gardens, PO10 8AN but we are not moving out of that address yet, so are will be paying bills for both properties at the moment.\r\nCan you also put my husband Mr Ian Lichfield on the bill. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27480, 'Hello.\r\n\r\nBecause I have never been involved to read the water meter (don`t know even where is located) I would like to ask you to read the meter on behalf of me.\r\nAlso sewer company called Albion water needs to have the final reading to set the final bill. Thank you so much for co-operation.\r\nKind regards.\r\nJaroslaw'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27493, 'from the 22nd July until 10th August 2015  My landline phone and internet will not be connected.Due to be connected on the 10th Aug.If you should need to contact me  my mobile no. is  077050868438 or by post.Thankyou'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (27808, 'Water is leaking out in 3/4 places from my neighbors front wall. This has been like it for at least a week as I have been away and thought my neighbor would have reported it but they don\'t seem to have.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28340, 'I was privately renting my property off Mr Harry Diamond up until Thursday 2nd July 2015.\r\nI did not have a water metre, I hope I have given the correct information, if you require any other information please call me on 0796 739 5469.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28444, 'Additional person at the address: Mr Matthew Thompson to also be added to the bill. \r\n\r\nI received a letter saying that the water was going to be cut off as it was unknown we were living there. The estate agents had told us that they informed you that we moved in on 8th June and gave you the meter reading then. Please let me know if you did receive the 8th June water meter reading as I can inform you of it.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28457, 'Please could my wife be added as a joint account holder:\r\nEmma Jane Porter\r\nDOB: 29/03/1985\r\n\r\nWe were previously paying Southern Water for both our Fresh and waste water, I have already notified Southern Water of our change of address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28638, 'We have sold 22 Thompson Road and are moving out on Friday 240715, we are now in different water area. Need final bill only. DD will be discontinued on Friday.\r\nContact address is Swindon address\r\nMany thanks\r\nSteve'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28644, 'My plumber has reported that the external (Portsmouth Water) stopcock to my property is seized open. The stopcock internal to the property is also defective. Please repair the external stopcock asap so that I am able to isolate the supply at the property and carry out internal repairs.  Regards Jack Cowens.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28688, 'I am the landlord of 176 St Augustine Road Southsea. The property has been empty since February 2015 and has been sold to a new owner. Completion of the sale is due on 24/07/2015, after which time I shall not be responsible for paying any bills. Can I ask that any bills for outstanding amounts be sent to 6 East Street Thame OX9 3JS?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28827, 'Please send me final bill for the period when I was leaving at Flat 1 48-50 Elm Grove to my new address.\r\n\r\nAt the new address please include my wife name (Mrs Anna Gackowska) in the account so she will have a proof of address.\r\n\r\nKind regards,\r\nKrzysztof Gackowski'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (28840, 'Hi,\r\n\r\nIn my newly moved property, I didn\'t find the meeting location.\r\nCould you please help me providing the meter number for Flat 9, 40 Portland Court.\r\n\r\nPlease let me know if it is metered or un-metered property.\r\n\r\nRegards,\r\nNaveen.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (29649, 'We have sold 32 King Street and have completed that transaction today.\r\nYou may have an out of date correspondence address on file for this property (8 The Close, Burdon Lane).\r\nIt is possible that a recent bill for the period commencing 1/7/2015 will have been sent to that old address.  It will not have been forwarded to this address.  Can you therefore issue a pro rata bill for the period from 1/7/2015 to 24/7/15 to this address - East Trenean Farm PL13 1QN.\r\nMany thanks, Brenda Farr.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (30354, 'It is not a bill at old or new flat, they are both pre pay key meters Also I Was meant to get a reminder by text about meter readings, but heard nothing. If you need to contact me, please do after 3:30pm \r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (30970, 'We purchased the above property 10/07/2015 and will be renting it out to tenants in the near future. Please currently send all bills to our home address Brooks Farm Cottage, Brooks Lane, Bosham, Chichester, West Sussex. PO18 8JX and I will inform you once tenanted.\r\nMany thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (31027, 'We have not exchanged and got a definite date for moving to the new address yet so we will advise once this has been finalised. However we have left the previous property and are on holiday so require a final bill for there. \r\n\r\nPlease forward any postal correspondence to; \r\n81, Kinross Crescent\r\nCosham\r\nPortsmouth\r\nPO6 2NP\r\n\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (31358, 'Directly out the front of our block of flats there is a pipe underground that has leaked before and been fixed twice before. It was only dug up I think a week ago but there is water rising to the surface again so I think the fix may have not been sucessful'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (31931, 'I am moving out of 72 Leesland Road on 16th August and moving in with my partner at 177 Skipper Way.  She already has and pays relevant water bills at 177 Skipper way, no name change or new account creation is necessary.  Please just close my account for 72 Leesland Road.\r\n\r\nAt 72 Leesland I was a tenant, and the new tenant arrives on 21st August.  The new tenant is arranged with Beal\'s of Gosport.  I don\'t know who they are.  I end responsibility for the property on 16th August.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (31997, 'At the front of the house at the end of the path is a small cover where you should be able to turn off the water, the water cannot be turned off and the hole is full of water. I have been advised to get this checked out.  Many thanks Jennifer'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (32118, 'Following phone calls with Portsmouth water we have now moved out of Flat 10 Ventura and I am submitting final reading. In order for an actual final bill to be sent to replace the estimate dated 18/07/15. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (32402, 'Flat 4 , Rednal House is a student rental property which we own. The last tenants moved out/ end of tenancy on 31/07/15. The flat is vacant until mid September when the new tenants move in. I will contact you with moving in date when it is known. I , myself have not moved to or from 82 Miller Drive where I currently live and pay ports water bills. I have guessed at the date we actually moved in as so long ago,but it was in early months of 2003. Please do not change our account for this property.\r\nPlease do not charge us during the vacant period on the flat , Rednal House. If necessary please close this account and I will reopen in Mid September. A direct debit payment is due to be debited on 03/08/15.\r\nPlease send confirmation email. Thankyou.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (32473, 'The contact numbers and e-mail are for Miss Carol Cooper. I am Jane\'s older sister. Jane is disabled and whilst the bills are paid from Jane\'s accounts I have enduring power of attorney and take care of her bill payments.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (32923, 'I contacted another water company last week but understand it may be that that water supply and sewerage are different supplies down here?  I haven\'t come across that before. Please advise if not the case as I don\'t want to pay twice!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (33026, 'I am moving out of Flat 3 George Court on 3rd September 2015 therefore please could you let me know the status of my account and if I need to make any payments or receive any credits to ensure it is fully settled. Many thanks, Mr Krishan Mistry.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (33187, 'Hi We have a new build house which was on a temporary builders supply. We have moved into the house and I notice that the meter is faulty. Could you please set up my account and organise for the meter to be repaired?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (33476, 'I will be moving out at 1 p.m on Tuesday 04/08/15\r\nI will be staying with friends and my mail is being redirected.\r\nI can be contacted on my mobile 07909795857 but will be out of the country from 5th to 12th August.\r\nYou can also contact me via e.mail : Karenjhowe@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (33800, 'Have changed water supply over, this is for sewage rates. Where I live now we only pay Southern Water. I am moving into my deceased parents home. This could already be in my name as I am executor of their will.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (34155, 'I understand that the property is on a Water meter but I could not locate it and require help with this and a meter reading. Please phone to arrange a time that you will be able to visit the property. \r\nWith thanks \r\nM Cowley'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (34169, 'I understand that the property is on a Water meter but I could not locate it and require help with this and a meter reading. Please phone to arrange a time that you will be able to visit the property. \r\nWith thanks \r\nM Cowley'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (34294, 'My new address is not supplied by Portsmouth Water. Please send me the final bill, preferably by email or otherwise post it to my new address and I will pay it as soon as I have received it. Many thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (34374, 'Hi,\r\nWe are leaving 65 Lovage Way, on 11th August, new owners are moving in on Thursday 20th August.\r\nPlease can you amend my surname as I have recently married.  New surname is HILLS.\r\nPlease can you also add my husband to the bill, if required, Mr Simon Hills.\r\nMany thanks\r\nLouise'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (34805, '91 Telephone Rd is a student property, with our lease ending on 11/08/2015.  Everyone has moved out of the property already, however the most recent bill received asks for payment from 01/07 to 31/12. It would be great if that could be changed so we could pay just what we owe until now.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (35111, 'I am renting out the property via Dibben & Dibben, Stubbington, Fareham. THe New tenant is Marian Parfitt and the tenancy commence 10th August 2015.\r\n\r\nThe reading above was taken when I left on 1st August 2015'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (35858, 'I contacted you a couple off weeks ago to say we were moving on 11th August but there has been a delay and we don\'t move until 18thAugust sorry didn\'t let you know but have been on holiday and didn\'t get back till yesterday thank you .'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (36185, 'We took possession of this property on 31st May we have had major refurbishments undertaken before moving in. The previous person a Father Twomey had left several months before.we received a bill for him so our\'s will start from his last bill'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (36326, 'I am not responsible for the bills at the house I am moving too as I am moving in with my girlfriend and she already has her accounts in order. so no need to set up or transfer accounts, just close existing one please. thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (36557, 'Hi guys \r\nDue to divorce,  I Mr John joiner no longer live at 26 salterns estate fareham. My ex and the children reside there,  Iam informing you because as my records show my bill is upto date , so I can Ealing my direct debit this week .. \r\nPlease contact Andrea for her payment instructions. Many thanks kindest regards \r\nMr John joiner'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (36570, 'Hi guys \r\nDue to divorce,  I Mr John joiner no longer live at 26 salterns estate fareham. My ex and the children reside there,  Iam informing you because as my records show my bill is upto date , so I can Ealing my direct debit this week .. \r\nPlease contact Andrea for her payment instructions. Many thanks kindest regards \r\nMr John joiner'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37197, 'I have been living at above address since December 2011. Please can you change the account details from Mr Allen who is the landlord. I am responsible for the water charges at the property & have been paying the account 91351230 01 since moving to the property.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37273, 'I wish to change from 2 names on the account (Mr Craig Newman and Miss Stephanie Brown) to just one name on the account (Mr Craig Newman). Once finalised, the only contact number needed on the account will be 07771393050 (Craig\'s number).\r\n\r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37353, 'You really cannot miss this. It has been leaking for about 2 days now.  The Fareham Road is wet day and night on the Fareham bound carriageway.  You can see the water running out over the pathway, so I ASSUME the leak is not under the road.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37361, 'You really cannot miss this. It has been leaking for about 2 days now.  The Fareham Road is wet day and night on the Fareham bound carriageway.  You can see the water running out over the pathway, so I ASSUME the leak is not under the road.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37601, 'I previously notified you of my move from my old address and that I moved in with my son to be enable to sell without a chain.  I complete the purchase on 14th August 2015 but will not be moving in until 1st September 2015.  The bill should continue to be in the names of Mrs A Smith and Mr D L Smith'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37720, 'I purchased this house on 30th January 2015, and there were tenants (4 students) in situ.  The tenants have just moved out as their tenancy has expired on 12th August 2015.  They have told me that they have paid their water bill up to 12th August, but I\'d be grateful if you could confirm that to be true.  Their names are Shahzain Syed, Mario de Sousa, Alex Nyagawa and Kingsley Fjikeme.\r\n\r\nI am intending to rent the house out in the coming 2-3 weeks, but for the  moment, I am responsible for bills, so I\'m registering with you.\r\nPlease feel free to contact me if you need more info.\r\n\r\nRegards\r\nEvelyn Chan\r\n07974911844'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37865, 'I have not yet moved into my new house. Please address any letters to me care of 146 Main Road Emsworth PO10 8HB before 28  August  2015 which the date when my purchase of 6 Frankland Terrace will complete'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37895, 'Hello, \r\n\r\nMe and my partner have moved into a new property (3 Cranesbill Court, Brushwood Grove, Emsworth, PO10 7GW), which we have bought, on Friday 14 August. \r\n\r\nWe are due to terminate our tenancy at 3 Regency Court, King Charles Street, Portsmouth, PO1 2RR on Sunday 23rd August. Our agency, Leaders, should contact you to provide final meter readings but I just wanted to let you know about the change of address.\r\n\r\nAs we are currently paying by Direct Debit,  I wanted to make sure that this can still be done at the new property? \r\n\r\nKind regards,\r\nMarjorie'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37965, 'We are new tenants at 74 Heyshott Road Southsea. It seems the previous tenants did not clear their arrears regarding this property and Southern Water has been sending the letters to me as the occupier and i have send these letters to the Estate Agent to deal with.\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (37979, 'I have moved on this address on the 4th of August 2015. I will be paying the bills, I prefer to receive paper bills. The previous bill of £95.45 was sent on the wrong name on the 13/08/2015. Please update my details and send a new paper bill. Thank you! Liviu Stefan'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (38177, 'I am the landlord of the above property, my e-mail address is emilywiltshire@mail.com.  My tenant James Corlett moved in on the 20/06/2014 and I don\'t know if you have these records.  I also don\'t have an up to date reference to give you as I have not had any correspondence from you in a long time.  Are you able to check the address and give me an update?  Many thanks \r\nEmily Wiltshire'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (38388, 'I am moving home to the family residence- 11 Highland Terrace, PO4 3DE- and will not be responsible for paying the water bill.\r\n\r\nMy partner who I also currently live (Samuel Carter Brazier) with is moving back into the family home and will also not be responsible for the water bill.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (38389, 'I am moving home to the family residence- 11 Highland Terrace, PO4 3DE- and will not be responsible for paying the water bill.\r\n\r\nMy partner who I also currently live (Samuel Carter Brazier) with is moving back into the family home and will also not be responsible for the water bill.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (38460, 'PLEASE NOTE I AM ALREADY REGISTERED AT 28 GRANT ROAD, I RENTED OUT 12 TREGARON. PROPOERTY HAS NOW BEEN SOLD AND WOULD LIKE TO HAVE FINAL BILL.\r\nSHOULD BE FROM 24/4/15 TO 31/7/2015. PREVIOUS TO THIS DATE TENANTS WERE RESPONSIBLE FOR THE BILL.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (39432, 'Unsure sure if account is under myself and my wife as it used to be joint names on the invoices but last few only seem to have mine, please add her onto the account again so we can both contact you if required to do so.  Her details are Mrs Hannah Dewane 19/07/1989, we don\'t believe there is a water meter at our new home.  Can we look into the cost of getting one installed and can you please advise us of our new bill via the post, thank you very much.  Best wishes \r\n\r\nMr and Mrs Dewane'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (39485, 'Prior to moving into the house in Portsmouth, I have poor mobile reception so contacting me by email would be best. This will be a student house and the other tenants are Miss Darina Jurovskaja\r\nMiss Jessica Lewis\r\nMiss Bethan Hallett\r\nMr Ryan Grimes'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (40188, 'Dear Sir/Madam,\r\n\r\nI have already contacted you about this change but have received no acknowledgement.  Please will you note that Mrs Janet Hudson is responsible for this account as from 6th July 2015 (the date of the last bill reading).  All future bills should be addressed to her at 2 Repton Close, Gosport, PO12 2RY \r\nSouthern Water have also been informed of this change and they have acknowledged the change in their records.\r\nWith thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41241, 'I apologise, I don\'t have my water bill to hand, and I wasn\'t aware we needed to take meter readings? I wouldn\'t know from where! \r\n\r\nI also am paying £10 every four weeks by standing order, I hope this is enough to cover the bill.\r\n\r\nMany thanks\r\nSarah Cassidy'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41335, 'We will contact you on September 4th when we move in and provide a meter reading.... before any water is used.\r\nI\'m sure Mr & Mrs Hill (existing owners) will provide the same.\r\n\r\nWith thanks\r\nPaul Torjussen'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41371, 'My partner and I are lodging at her parents address - already has services, no new ones are required. Please advise that the account for 111 Twyfird has been closed via email darrell.bunce@gmail.com or by telephone 07880336131. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41459, 'We moved from our old address on 13/08 so relinquished responsibility for the bills on 13/08.  We have moved to a property where the water is provided by SSE so I have cancelled my Direct Debit and expect a final statement of account to be provided in due course'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41522, 'My name is Dave Paton and I am a support worker for Two Saints Housing Assosciation 35 Waterside Gardens, Fareham. PO16 8SD. Up until 24/8/15 Two Saints paid the water bills at 3 Warders Court Chilworth Grove Gosport PO12 3UR as we were subletting in to a Mr Barry Large. Mr Large moved oout of this property on 24/8/15, therefore can you cancel any payment and send any refunds to Two Saints. This property is owned by Gosport Borough Council who will be placing a new tenant in there soon. Please contact me on the number above if you require any further info.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41554, 'I AM LEAVING ENGLAND ON 4TH SEPT 2015 BUT RENTAL AGREEMENT DOES NOT END UNTIL 30 SEPTEMBER SO TECHNICALLY I AM RESPONSIBLE FOR ANY CHARGES UNTIL THAT DATE UNLESS LANDLORD OR AGENT (LEADERS SOUTHSEA) ADVISE YOU OF A NEW TENANT PRIOR TO THAT DATE.\r\n\r\nIF POSSIBLE PLEASE SUBMIT FINAL BILL FOR PAYMENT BY EMAIL'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41580, 'My tenancy started at the above address on 13/07/15, but I did not move until 18/07/15. I have been unable to set up utilities at this address as it is a new build and the developer had not yet registered it with the local authority.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41849, 'I last wrote to you following the death of my mother Ann James and my sister then took responsibilities for the bill as requested. I now live at the property and are now responsible for all future payments and wish to do them on line. I have all paperwork and there is no need fro a reading as such.Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (41919, 'I already have a direct debit set up from my bank Santander. Can this please continue for the new address. I am not aware of a water meter there, as I haven\'t been shown one before finally moving in. It is a Council run sheltered accommodation flat, in a block of six.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (42002, 'Please  note tat I have made another entry earlier but for got to add the Building name Park View. This is the full correct address.\r\nWe are not aware if there is a meter at this property but we would like to have one installed. We have also run out of time to check the meter at the previous address.\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (43056, 'main stopcock (+ one other by mistake) was replaced a couple of months ago.  water is rising out of ground next to main stopcock and flowing out onto road.  I am the scout leader for the group which is why there is the difference in addresses,'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (43157, 'Handling property at 17 Farlington ave as Administrator of estate of Late Mr John Markwell. House is currently unoccupied and will complete with new owner on 11/9/15.    The London addrses is my permanent address, not relevant in respect of new meter reading etc.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (43271, 'We would like that on bills we can see both names:\r\nMs Olga Petrova & Mr Andris Bertulsons. \r\nWe paid for Portsmouth water till 31.12.2015 in our previous address.\r\nOur account number is 9012730701.\r\nThanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (43869, 'Hi,\r\nWe wish to change the name to another one of the roomates. If you have a copy of our tenancy agreement, you will find that both the previous and new names are included. Please let us know if you need anything else.\r\n\r\nRegards\r\nAndreas'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44407, 'i am the landlord of this address. the previous tenant ms sharon mpofu left this address on the 22/07/15,\r\ni am having work done on the house before new tenants move in so will pay my bill once its all done\r\nsally barker.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44529, 'The new owners of 4 Coppice Hill ( Miss Joanne Willis) will be moving into the property on 4th September 2015. The previous owner Diane Slater will not be responsible after this date . Please note, Mrs Diane Slater ( previous owner) does not have a new property within the Portsmouth Water area'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44627, 'I was the owner/landlord of Fareham property (30 Beaconsfield Road), which was rented out to Mr & Mrs Smith, who vacated the property 29 May 2015. Since then the property has been empty. The property has now been sold (completion date 4 Sep 2015) to Ms Kang. As such, I was responsible for the property between 29 May 2015 and 4 Sep 2015.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44701, 'My tenants moved out of the property on 16th July 2015.  They left without notice and their account was number 9366182401 with a debit on 5 Aug 2015 reminder of £108.90.  They did not leave a forwarding address.  Please zero this account and charge me from the 18th July 2015.  The property has been empty since and will be sold in the near future.\r\nRegards\r\nA M Dimbleby'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44718, 'Hello\r\n\r\nI understand there are also some arrerrs on my account. I have just got a new job where I will receive a substantial pay rise and plan to clear the arrerrs at the end of sept (26th) could you please forward to my new address a full account statement included owed amounts so I can ensure the account is bought into line asap.\r\n\r\nWould also be interested in paying via a payment card if that\'s a service you offer.\r\n\r\nMany thanks\r\nGary martin'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44737, 'This is the Agent\'s number - I do not know if new tenants will be moving in or have the Landlords number. If you were to call the Agent they will be able to tell you who will be in the property after the 5th.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (44985, 'This is a new build, so here\'s some further information to help you track it down!\r\n\r\nMeter Serial Number:  15191377\r\n\r\nPlease can all billing and account correspondence be sent to: 230 Oving Road, Chichester PO19 7EJ.  \r\n\r\nThank you.  Heather Allen'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45131, 'I left the property at 260 Laburnum Grove Portmouth on 26/08/2015.  I have moved abroad and therefore have no forwarding UK address.  Please send any correspondence by email.  I have cancelled the direct debit. Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45325, 'Moved to new property 28.08.15 (purchased) however we are tied into the contract (rented) on 106 Frensham Road until 30.09.15 however we have moved all furniture and living at 86 Empshott Road 28.08.15 (date we got the keys).\r\nRegards\r\nTom'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45338, 'I wanted to establish new residency prior to move as I won\'t have any Internet available for 20 days.  I would like to call you with the meter reading the day of purchase.  Could you please provide a telephone number?  Thank you Kristen Trent'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45413, 'Please be aware that we were due to move to 65 Westfield Road but the property fell through.  We move into 28 Owen Street tomorrow morning.  Rosina Arnold will be co-habiting with me at the new address and share responsibility for the bills.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45463, 'I have perviously tried to set up as a new customer and have been advised i would recieve a letter but have yet to recieve this , I would also like to know the payment methods and costs ? \r\nMany Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (45888, 'I have now graduated from University now so have moved out of our student house. The new tenants will move in anytime now so they will be paying the water bill for that house. Our contract ended on July 31st.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (46103, 'We have already paid the rateable bill for August-June16, However, since then we received the wastewater bill from Southern Water and realised we could save quite a lot with a meter. So can the amount we paid be taken as downpayment towards whatever bills occur after a meter is fit.\r\n\r\nThank you, Tom.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (46116, 'Hello -\r\n\r\nI moved here from my family\'s home in Canada into this flat I am now renting  at 6 Petrie Roadon August 27, and I am now responsible for paying my monthly water bill with yourselves.\r\nPlease email me if you require any additional information.\r\n\r\nThankyou,\r\n\r\nMichael Helsby'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (46332, 'I believe our last payment was made on 03.08.15 which covered 6 months from 01.07.15.\r\nIt would be greatly appreciated if you could please arrange for the appropriate funds to be refunded to my bank account from where the funds are debited.\r\nlind regards craig'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (46376, 'After opening the meter box at the weekend i noticed a drip on the meter connection. i presume it has been installed incorrectly and would like somebody to come and view and fix it, we are in a 3 year old Taylor Wimpey property.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (47284, 'We completed our purchase of No 10 on 28 August and are currently doing repairs and redecoration there.       Your property reference for No.10 is 72995650.   We currently pay for No. 9 by Direct Debit which we wish to continue and transfer to the new property once we move in.   Hope this is all the information you need.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (47572, 'We have recently moved from our rented accommodation on Esslemont Road to a property on Empshott road of which we are now home owners. \r\nWe pay our fresh water billby direct debit.  Please would you get back to me regarding the process of moving home.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (48266, 'Good morning, \r\nI have moved out of the house but I am still responsible for the bill as the property is not rented\r\nPlease send any future bills and correspondence to my new address in London\r\nKind regards\r\nMark Brenson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (48267, 'Good morning, \r\nI have moved out of the house but I am still responsible for the bill as the property is not rented\r\nPlease send any future bills and correspondence to my new address\r\nKind regards\r\nMark Brenson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (48760, 'Hi, I am not changing my name, but I live in a shared house as a tenant. My last housemates have moved out, and I have new housemates that have been moved in. As we are all jointly responsible for the bills I would like their names to be added to the account please. Thank you. Their names are:\r\n\r\nDavid White\r\nDaniel Elliott\r\nRebecca Boult'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (48897, 'I have requested permission from my landlord, Gosport Borough Council, to have a water meter installed at the above property and have received a letter dated 3 September 2015 confirming that a water meter can be installed.\r\n\r\nIt states within the letter that I will need to provide a certificate of completion when the works are carried out and to forward this certificate to my landlord.\r\n\r\nPlease could you also advise whether I would need to be at home when the water meter is being installed.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (49389, 'CHANGE OF NAME DUE TO NOT CHANGING NAME AFTER HUSBANDS DEATH IN 2007.\r\nMRS BARTLETT MOVING FLAT WITHIN SAME COMPLEX AND FAMILY ARE DEALING WITH ALL PAPERWORK AND HAVE DISCOVERED THIS OVERSIGHT..\r\nCHANGE OF ADDRESS FORM WILL BE COMPLETED ALSO.\r\nemail address is daughter in laws.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (49409, 'CHANGE OF NAME FORM SUBMITTED AT SAME TIME, FROM MR PETER BARTLETT, WHO DIED IN 2007.OVERSIGHT BY MRS BARTLETT IN NOT CHANGING NAME ON ACCOUNT.FAMILY NOW LOOKING AFTER ALL PAPERWORK TO COVER HOUSEMOVE.\r\nemail address is daughter in law mrs r reed.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (49441, 'My name was Lauren Anscomb and has been changed by deed poll to Lauren Rose.\r\n\r\nIn addition could you please add Benjamin Gander as a joint person at the new address his date of birth is 31/05/1984.\r\n\r\nThanks you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (49454, 'I have contacted your customer services  dept previously and someone has visited out house to discuss supply pressures. I keep getting letters saying you may disconnect the house because you don\'t know my details?!   Please do t. I have a family of young children!!  Resubmitting details as very happy to pay a bill when produced.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (49546, 'My purchase of 106 Gordon Rd is scheduled to complete on 25th September.\r\n\r\nThere is no meter at the address.\r\n\r\nPlease set me up as the new bill payer at that address from that date.\r\n\r\nMany thanks,\r\n\r\nSue'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (50233, 'Note that 7 Trendle Green is my second home and I have sold it, completion on 30th September 2015.  I am not immediately purchasing another property.\r\nThe address in London is my main residence and I am registered there for all correspondence.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (50392, 'Have already informed you of move into 25 Birch Tree Drive and you have opened an account no 94106812 01 for it. All good.\r\nPlease simply close account for 7 Russet gardens (93876677 01) and send final bill to new address to 25 Birch Tree Drive, PO10 7RS\r\nthank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (50820, 'Moving to different house (no 63) on 30th September, but on the same street hence same post code. Property ref no. is 71532692 for new house.\r\nPlease confirm if I still need to complete the Customer details, update request form sent to no.63 on 10-09-15?\r\nthanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (50949, 'Due to personal circumstances I would like to remove my name Miss Leah Turley from the joint account with Mr Martin Shanahan, leaving the account just in Mr Shanahan\'s name. Please could you send me confirmation when this has been done.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (50975, 'tenant agency told us they were setting this is up for us and have today told us that information is false! so we don\'t have a meter reading and that is also why its taken two weeks for me to set this up! sorry!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (51368, 'I am new in town and I signed a contract for Southern Water, but I\'ve just read in my first bill with them that they only provide wastewater services and Portsmouth Water will send me a separate bill for fresh water, so I would like to know whether I have to do anything or they send you all my information so I just wait until I receive that bill. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (51670, 'We will complete the sale of 29 Gosport Road on the 25 Sep 15 and vacate the property by 1300 hrs that day.\r\n\r\nMy landline number will also be cut at that time.  My mobile  07963 848891 remains active.\r\n\r\nSorry I do not know the details of the buyer, and am not permitted to provide third party details.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (52148, '9 Orion close has been sold and I will be completing 2/10/15 & no longer be responsible for the property. I will be moving in with a family member at 10 Sollent Road where I am not responsible for bills there'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (52186, 'So far no new tenant I am aware of, please refer to the flat agency above. Can you give me an email stating if there is any money left to be paid or weather I have paid to much. Refund to the bank account known to you please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (52700, 'I move out of 33 Stanley Street on the 26th September 2015. I will be living with my partner at 22 Mitchells Road where the bills are already paid. I would like my final bill for 33 Stanley Street up to my move out date so I can settle the account.\r\nThank you and please send the bill to my new address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (52816, '24 Holman Close is now a let property. I am the landlord.\r\nI have moved in with my partner – Mrs Jane Kalinski – and am living with her at 22 Anvil Close.\r\n22 Anvil Close has a water meter. Jane will continue to be the payee for her account'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (53116, 'Hello I am the house holder in the property 6 little south sea street I have an over due bill which costs 74.44 pound I was abroad for 2 months I was not able to see the bill also the first over due bill was 37.22 pound. Even more I had leaking in the property like  2 and half months ago for almost one day and it was fixed. However, my agent cubitt & west ( which i rent the property from ) said they will pay the cost of the leaking, may you sort it out with them please as I am not the responsible of that. lastly, I got my visa stamped with my entry date to the UK .\r\nbest regards \r\nAws.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (53433, 'Although we are moving in on 02/10/15 we took ownership of the property from 28/08/15 so will be responsible from this date. Is there a grace period for empty properties? \r\n\r\nAlso, the property is jointly owned with my Partner Mr Luke Pearce, please ensure the account is in both our names. \r\n\r\nThanks in advance.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (53534, 'The meter reading is for today 24th September 2015. We moved in on 21st Seotember but I could not take a reading because the meter is a long way down and the glass was covered in dirt. I lay on the ground to clean it today!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (53805, 'I have lived at the above Clanfield house for 23 years but have been responsible for paying Water bills at 178 Southampton Road, ever since my mother Mrs. Edna Minhinnick died in 2009.  The property has now been sold - Completion Day 25/09/15. I do not know who has bought it - the estate agent will be handing them the keys. \r\nI have pre-paid the water bill until 2016, so would like a pro-rated rebate please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (53904, 'Additional responsible person loving with me is my partner- Mr Scott Dack.\r\nAlso my move in and move out dates clash I will be moving out on the 26th (tomorrow) however tenancy for old address is until the 9th October 2015.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (54281, 'I have already notified you of this mofe in writing, however I have had a reply stating you you were unable to \'deal with\' change of address notifications more that 14 days before the event takes place. As I am leaving the area I wanted to notify you as soon as possible.\r\nIt is now less that 14 days until my move so I am sending this form as confirmation.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (54357, 'Just outside the the blue front gate on the left is a small metal cover above the stopcock for the house.\r\nThe stopcock is now permanently covered with water which never used to be the case.  The soil just inside the gate is permanently wet. My neighbour on the left as you face the gate has a cellar and he has told me that their appears to be damp coming through the wall from somewhere.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (54410, 'I moved from 87 Ferry road, po4 9ud on the above date.mPlease can you transfer the account over from that address. I forget to contact you and don\'t want to be responsible for my old address. Many thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (54417, 'Water supply shut off the valve to 11 Green Lane is not functioning and leaking. The valve is located in the pavement outside the property.\r\n I raised the supply cover today and tried to shut the valve - the hole was half full of water which I thought was due to rain. However when I tried to shut off the supply, I could see water bubbling in the hole. I could not shut off the supply valve by hand and did not want to use a supply valve key in case it damaged the valve. As the valve appears to be leaking and I cannot shut off supply to the house to repair a leaking toilet cistern valve, I ask that the supply valve is repaired / replaced.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (54651, 'Pipework in garden opposite waste water works entrance has a leak,its a new house build opposite and owner has isolated water supply,could you please investigate and let me know of your findings thanks ian williams'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55103, 'This is the forward address from my previous address. I\'m not responsible for the billing and the properties already billed by Portsmouth Water. Please send me the final bill up to 21 Oct 2015 for address 36 Rosetta Road Southsea.\r\n\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55260, 'My husband and I have moved here from Devon. I have only just found out you may be our water suppliers here in Selsey.\r\nIn Devon we had a water meter and  I would pay SWW every 3months when they sent a bill and I read the meter to verify.\r\nWe have been unable to find a water meter here to give the reading. Is there one. Are they compulsory? How much might it cost to have one installed?\r\nWe have also been unable to find a stop cock inside or outside of the bungalow. We are at the junction of 2 streets. A plumber will need to do work on the house in the near future but we do not know how to turn the water off.\r\nCould you please help us with any of these questions?\r\nWe will not be available by landline until next Monday. But e-mails we will still have access to.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55319, 'We live in a small one bedroomed semi detached bungalow.\r\nCould you please tell me how much having a water meter installed would cost us. I have heard SE Water will be installing meters free in all their properties over the next few years. Will this be the same for you as well?\r\nThank you for your time.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55380, 'There has been a leak for several days in the font garden of above property that is spreading over and under the pathway & towards the boundary of the properties opposite including my property. My concerns are the health & safety caused by the damage to the already uneven pathway'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55414, 'Hello, \r\n\r\nThere seems to be dirt covering our water meter, which is located on the pavement outside our house. Because of this I am unable to get a final meter reading. Please can you send someone to look into it and advise as soon as possible. \r\n\r\nMany thanks, \r\n\r\nMrs Bleasdale.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (55699, 'Due to change of area I will no longer be using Portsmouth Water, and from previous telephone conversations with you I understand I will be in credit when this account is closed.  I was told this will be paid directly into my bank account, can you please confirm this.     Am I right to assume the final paperwork will be sent to my new address as above, or online to my daugther\'s email address also listed above.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (56509, 'This is a new development Flat.  We purchased it on the 11 September and moved in on the 26th September.  We have been told by our solicitors that the Land registry is currently taking approx 8 weeks.  \r\n\r\nWe have not had access to the water meter which is not situated in the flat so are unable to supply a current meter reading at present. We have spoken to the developer to gain access next week.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (56639, 'This is a new build house and on 14 August 2015 the developer, Rydon Homes wrote to you informing you that we were the new owners from 31 July but as yet we have not moved in.  Please contact us in order that we can set up a direct debit.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (56771, 'My tenancy at flat 50 will come to an end on the 13th october 2015. I rented this property from your move estate agents in havant who are now finding a new tentant for the address. At present i have no new address that i am going to. If a revised bill can be sent to me for me to pay the balance of the six months i was a tenant. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (56855, 'Outside Covindale House near to the front entrance, there are two water stop cocks. One of these stop cocks has developed a bad leak, water is leaking from the stop cock into the ground. The leak has now affected the water pressure in Covindale House, I am now only getting a trickle of water from my taps.\r\nPhone number and e-mail are daytime (9 to 5 Monday to Friday) outside work phone 023 92872603'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (57016, 'Hi there, I have moved from Fratton to Havant although I have not sold the address at Fratton just yet. however the property is vacant and on the market for sale, Im not 100% sure what I need to do as this is the first time I have been in this sort of situation.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (57299, 'Unnamed agricultural road. To the west of the Home Farm in Upper Norton, Selsey Road, Chichester. Driving towards the coast, turn right into field opposite the Home Farm entrance. Leak is just north of the Selsey Golf Club grounds, where the power lines cross the Tram Way footpath.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (57570, 'My wife, Mrs C Lloyd is the named person on the account at 32 Park Lane PO16 7JX, although I have always paid.\r\nWe are moving to separate addresses. I (Mr Lloyd) will be moving to 91 Fareham Park Road (as stated above) and will need to be billed accordingly and Mrs Lloyd will be living with a family member until her own house purchase is complete.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (57826, 'My wife and I are moving to the abovementioned address on 13th October and would like to setup our water supply in order to not having any issue after our arrival. If it is necessary any further step, please let me know it. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (57939, 'Hi there. My father died last year and I am not sure why we are still getting bills in his name as I know we contacted you at the time. My mother is about to sell the house so we will be changing details again soon - she no longer lives at the property. I will get in contact again once we have a sale date.\r\n\r\nPenelope Phillips'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (58287, 'We can hear water going through a pipe constantly 24 hours a day. It is constant and is not affected by our taps being off. Our water supply is a shared supply from the mains to other properties apart from our own but even so it seems odd to have water on constantly and feel this must be a leak.  The fact that we can hear it inside our property and it is always running 24 hours a day and has been doing so for a long time is of concern as we don\'t know where it is going to.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (58469, 'This household has had an account since moving in on 07/03/2015.  The previous account holder has now moved out, so we have been requested to set up a new account.  We have paid a final bill dating up to the end of September of £42.52.  A reading was taken of 00057 on 01/10/2015.  Please start the bill charge from this reading.  The property reference number I have been forwarded is 73217980.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (58683, 'Hi Sir/Madam,\r\n          I am Matheepan  Manickavasagar.\r\ni am living  above on this address currently. The who have Previous Bills Holder, has been moved. \r\ni would like to pay the  bill\'s from last july. \r\ncould you change it in my name the bills please.\r\n\r\nThanking You.\r\n\r\nSincerely\r\nMatheepan.m'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (58846, 'Hello\r\nIn my new address i don\'t need pay water bills, because Lord do that. Don\'t send me nothing here and don\'t call me, because I\'m working those times.\r\nSorry but I don\'t have money at all to pay for you, and anyway I\'m not living there more than a month. Could you somehow delete everything this sum of money I should pay, I am alone mother with child, I really can not pay to you or  for somebody else, I don\'t have money and won\'t... I am totally in bankrupt. \r\nSorry  again and thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (59576, 'I have sold my flat (81 Markfield, Bognor Regis) and require a final bill from my water meter reading.  The reading was taken on 04.10.15 and the water supply was subsequently turned off on departure.  The new owners will move in on 10.10.15.\r\n\r\nI have moved away from the region and Portsmouth Water will not be responsible for providing water to my new property, but I have included the address on the form because I had to.\r\n\r\nPrefer contact via EMAIL please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (59651, 'Ben Swarbrick & Michael Catterall are moving out of 37A South Parade on the 26/10/15. \r\n\r\nBen Swarbrick & Thomas Dash are moving in to Cavendish Road on the 30/10/15. \r\n\r\nMichael Catterall is going elsewhere and therefore needs to be removed from the account.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (59949, 'You recently refitted the meter and there is now a slow leak in adjoining access aperture (flooded but presumably housing stopcock). The meter still rotates slowly even when no appliances/taps in use. The surrounding ground is saturated. Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (60001, 'My dear wife passed away this year and as i am now on my own i understand, from family, friends and neighbours, that it would be cheaper for me to go on to a Meter, hence this application. \r\n\r\nI do work four days a week. Monday -Thursday, from 0800Hrs to 1200Hrs.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (60487, 'We are responsible for paying the bill fro this property until 01/10/15 when our tenant moved in.  Please can you advise what the charges are for this period.\r\n\r\nMy address for correspondence is 50 Brook Gardens PO10 7LB'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (60948, 'Hi,\r\nMy name has been spelt incorrectly on the bill. It should be Priya Srinivasan. Could you please correct that. Secondly i tried to pay the bill this evening via online banking. It says the reference number is not correct. Could you please let me know, what reference no. I should be using whilst paying the bill. \r\nThanks\r\nPriya'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (61235, 'We are moving out of our rented property on 31.10.2015 when our tenancy ends. We will not be responsible for the bill at our new address.\r\n\r\nThe person responsible for the Water bill at our rented property once we vacate will be the landlord Mr David Brown. \r\nI do not know his address but our letting agents do and they are Dack Property Management in Southsea.\r\n\r\nThanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (62284, 'Hello!  we are completing on the house on 23rd October 2015.  We wont be moving in until December, so we will have 2 accounts active at first.  We currently live at 1 Grange Cottage, Colworth, PO20 2DU'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (62592, 'I am moving to live with my sister and her partner Dominic, they are already set up and paying their water bill so the new address given is simply for your information to send me my final bill.\r\n\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (62664, 'The property is a \'new build\' and the developer was Miller Homes.\r\n\r\nThe property is jointly owned with my wife Mrs Helen Wheeler and I would appreciate it if although my name would be on the account with Portsmouth Water, that my wife is allowed to undertake any dealings with Portsmouth Water on my behalf.\r\n\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63124, 'mains only - believe that the current owner ( Mr Watts) has account with you.\r\n\r\nI\'m also known by surname of Gould but I think my customer account is in name of RICCIO- which is correct.\r\n\r\nI wish to continue paying by direct debit.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63266, 'My fiancé is moving in to the home before we marry and we therefore want to reallocate the bills between us.  All payment details will remain the same but the key account holder will change.  Please contact me with any queries you may have. I would be very grateful if you might issue the most up to date bill with the new name on it for our own administration at work.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63309, 'Hello, my name is Maria de los Angeles de la Cruz Barquero. I was sharing a flat with another person that is no longer living with me in the house. As I was sharing with her, her name is in our account with Portsmouth Water. Her name is Laia Ramio Thomas. As she is not living with me anymore, I would like to remove her name in the account and just keep myself.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63603, 'Just complete the buying process, I will pick up the key on Friday from Estate Agent. Could you please possibly tell me when is the water meter( so I can  do the reading) and when was the last reading and how many cubic meter it read?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63660, 'New build property. Moved in on 17/10/2015 and meter reading at 00000. Can you confirm what next steps are? When will we receive first bill? How much? Do you supply both in water and out water? Thanks Phil'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (63772, 'The bill is currently in joint names between my mother and father, but my father has recently passed away. Please remove my father\'s name from the account and leave my mother\'s as sole account holder.\r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64050, 'A repair to the supply pipe was carried out in early August free of charge. There is another leak, although smaller and water is not coming up through the driveway. There is water under the water meter and the dial on the meter currently spins one revolution every 20 seconds when no taps are turned on in the house.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64224, 'Hello, \r\n\r\nI am very sorry but I am unable to find the water meter reading. I hope it is ok. There are only two of us living in the property - no children. We don\'t own a dishwasher and did 3 loads of laundry using the washing machine (on quick 30 minutes eco mode) since moving in. \r\n\r\nKind regards, \r\n\r\nMarie'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64296, 'I am leaving the property on the 27th October and there will be a new occupier from that date. I am moving to an area that is not served by Portsmouth Water and I do not have a meter. Therefore I will simply cancel the direct debit.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64465, 'Dear sir/madam, \r\nafter speaking to southern water - it appears that my water charges are high at this rental property. As i am living here with just my daughter there is generally only the 2 of us and so can you arrange for a meter please.\r\nregards\r\n\r\nclaire beech'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64742, 'Please note that we are moving from rented to a purchased property.  Our rental at 31 Paddington will not cease until 13th December but we took ownership of 40 Beresford on 23 October. We understand that we will be liable for the bills at both properties during this period.\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (64778, 'We are unable to find a water meter at the new property so cannot provide a meter reading from our move in date.\r\nPlease note that my surname has changed to Fyfe-Green due to marriage; I would be grateful if your records could reflect this.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (65135, 'Dear Portsmouth water\r\nI reported this leak 3 weeks ago and absolutely nothing has been done to rectify it. I have to wonder: (a) is there a point to me reporting a leak and (b) why the water bill is so high.\r\nWell after 3 weeks plus of water being wasted I now know why the water bill is so large.\r\nBecause of the inefficient nature of Portsmouth water I am now left wondering if Portsmouth water is actually fit for purpose.\r\nFix the leaks!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (65413, 'Moved into address in May but didn\'t realise i had to sign up as a new customer (as it is a new build) so i\'ve been waiting for a bill to come through the door. Whatever i owe i will pay in installments.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (65532, 'New address not within Portsmouth Water Company area.\r\n\r\nMessrs Whiting and Wheeler are the new owners of my previous address, Osborne House, 272 Main Road, Southbourne but not sure who is responsible for bills.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (65610, 'Sorry we have no meter readings. We have never previously provided meter readings and were under the impression this was collected by yourselves. If not then do let me know and I can search for a meter reading for our new place but we have been responsible for the new place for just over 3 weeks now.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (65826, 'Please can you take this as written notice that we need to cancel our account at the above address due to a move abroad. We will submit a final meter reading in December and also confirm bank details for any refunds.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (66046, 'We completed the purchase of The Blue House on 28/10/15.  We will be moving their permanently when we have completed the sale of our old house (16 Evelegh Road, Portsmouth, PO6 1DL) where we are also a customer of Portsmouth Water.  We will let you know when that happens'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (66693, 'My husband and I own St Andrews House, so I am a returning customer. It was rented to Daniel Grant and Oliver Little for the last 13 months.  They moved out on 27/10/15, when the inventory was done and vacant possession achieved.  I will be responsible for the water charges from that date until another tenant is found.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (66893, 'Please be advised that I currently live at 31 Robin Gardens\r\n\r\n102 Robin Gardens is owned by us and has just been unoccupied and is currently up for sale.\r\n\r\nPlease therefore do not transfer my current living address details.\r\n\r\nPlease can the water bills be posted to 31 Robin Gardens PO8 9XE to allow me to pay them until sold?\r\n\r\nThankyou'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (67212, 'I was told this street had shared water supply but I believe my house has an individual supply.  This would need to be confirmed.  I would like to be around when the meter is fitted if at all possible to understand how to read it etc.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (68219, 'I\'m afraid I do not know my meter readings as I have never know where my meter is since living at Cottage Grove, which was from 21 March 2015.\r\nI also cannot provide a meter reading from Mafeking Road as I will not be moving in the Property until 07.11.15'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (68658, 'We have moved to France and the address given to you is our correspondence address. We did not take a meter reading on 04/11/15 as we could not locate one. Please send all correspondence to our mail box address. Many thanks.  Tina Dunning and Philip La Roche.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (68954, 'I spent ages on the phone trying to report this leak some weeks ago. It has been leaking for over a year. I only see it when walking the dog and so often forget to report it. A S.W van did come out to inspect it (I saw them) and nothing has happened since!  That was a few months ago. Although not gushing, on the driest summer day there is always a wet puddle/patch on the floor with green mildew around the edges, indicating that there is always water present.  Sometimes the puddle is quite bad, it is NEVER dry.  I can see this isn\'t urgent but I have read that with water leaks, the amount of water you can see above the ground is doubled underground. Either way, it is still a precious resource filtering away!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (69445, 'Water has been intermittently flowing and dripping from an overflow at the rear of the address for approx 10 years. The leak is to the extent that it can easily fill and overflow a 45 gallon drum in around a week.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (69479, 'Please could you send me details on how much I owe for the Selsy address, if anything and how to set up a direct debit at my new address.\r\n\r\nI understand that I am now on a water meter so not sure what that looks like or where to find it in my house.\r\n\r\nMany thanks\r\n\r\nKaren'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (69629, 'Hi, \r\n\r\nI have just moved in to this property and received a bill from yourselves but my last name is incorrect. The bill states Scania Flack but my name is Scania Slack. Please can you amend this? Also to confirm I have paid the bill online today.\r\n\r\nKind Regards \r\nScania Slack'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (69648, 'We completed on Pippins cottage on 05/08/2015 but remained responsible for rented property at 5 Hither Green until 06/11/2015.\r\nWe understand that Pippins Cottage is not yet metered. It has septic tank drainage.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (69869, 'On a public highway (right of way) known as Footpath 78 the old Selsey Tramway, there is a leak on the network main which is flooding the area and damaging the footpath surface. Please can you put the necessary repairs in hand to repair the leak as a matter of urgency. You are required under the Highways Act to put right any damage to the right of way caused by the leak at your own cost. Any works required to reinstate the path surface must have the consent of this authority.  The path surface must be restored to a safe level and compact condition\r\nPlease contact me with regard to what is to happen and when'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (70213, 'Hi, \r\nits my request please add my husband name as well. \r\ni would like on the bill my name and my husband name be there \r\nMrs Rachna Anderson and Mr Matthew Anderson, \r\ni couldn\'t find an option for joint account holder. \r\nIf you need any more detail please contact me\r\nkindest regards \r\nRachna Anderson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (70603, 'leak on grass verge near to footpath to dunsbury way this leak has been present for approximately 8 months ( i work for HBC as a verge cutter and this leak has been present since grass cutting started in March )'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (70633, 'I am aware that I have arrears on my account from previous addresses.  I would like to resolve these issues and enter into a payment arrangement.  I will be in contact once I have confirmation of the change of address and balance of the arrears.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (70981, 'I am moving back home to my parents and so I will not be responsible for the bills at the new address. They are not new owners and have lived at the property for years and so already have an account set up with you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (71028, 'They are the agents and not the landlord / owner\r\n\r\nThey will be tenanting the flat shortly with a different individual\r\n\r\nPlease send me a final bill to the address above, 1 Camberwell Grove, \r\nI left the flat on 10/11/2015'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (71396, 'I moved into this property on the 21st July 2015, but I just found out that there is second company which I have to pay, so my meter reading when I moved in was 990 and now it is 1016 on the 20 Oct, this was given by your company to Southern water. could you please send me a bill, thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (71766, 'I have received a half yearly bill through for £60, and it seems that I might benefit from being on a meter instead. Please can you call me to discuss. The outstanding bill will be paid when I have a clear indication of what will happen.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (72333, 'This man has had a tenant in his property of 30 Frobisher close, Gosport hants po138eh since 2012 I believe he\'s not been paying his water Portsmouth or southern rates. He has currently moved back to 30 Frobisher close now. I don\'t wish to give my personal details'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (72614, 'I was the water bill payer at the address in Bognor Regis from 02/09/15 to when the above-named tenants moved in on 16/11/15. I have moved back in with Jane Cox at my old address in Portsmouth where Mrs Cox is currently paying the water bill and will continue to do so. I will need my account closed and any credit balance please posted to me in Portsmouth or put back onto my payment card. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (72718, 'My surname has changed as I got married on 19th June 2014. I would also like. Y husbands name put onto the new bill.. His name is Adrian Lee Illingworth. \r\nOnce the names are changed please could you send an updated bill out to my address. The monthly payments will continue to come out of my normal account which is in my married name. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (73682, 'Please can you kindly read the water meter at The Bund, Church Lane, Yapton BN18 0EH on Monday 30th November 2015 and send the account to me,  Mrs Cudmore at 62 Chaucer Avenue, Rustington.  Will the final payment be taken by direct debit or do you require me to send a cheque for any amount which is outstanding OR do you credit me if there is an overpayment?  I believe that the water supplied at Chaucer Avenue comes under Southern Water so am unsure what happens when moving areas.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (73827, 'With regards to the last question, at the new address I will be sharing flat with Alexandros Makridis, so the new direct debit will show either my name or his. (I am only letting you know to avoid confusion).\r\n\r\nI had paid the full amount in advance (July 2015- July 2016). Please let me know how I can get refunded.\r\n\r\nMany thanks!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (73863, 'I AM VACATING OLIVER COURT WHICH IS A RENTED PROPERTY.  I WILL MOVE IN WITH MY GRANDMOTHER FOR A PERIOD OF 3 WEEKS.  PLEASE SEND ANY FINAL CORRESPONDENCE TO THE EAST DEREHAM ADDRESS. IF YOU REQUIRE ANY FURTHER INFORMATION, PLEASE DO NOT HESITATE TO CONTACT ME ON MOBILE NUMBER OR EMAIL.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (73895, 'you have the address change to show i am now living at 3 edwards close and i am setting up a dd for this address currently - i have sold 278 chatsworth avenue and moved out in august 2015 (you already have the date i moved into 3 edwards close) the completion for 278 is 24.11.15 so i need a final bill for 278 chatsworth up to 23.11.2015 sent to 3 edwards close please'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74222, 'Prior to 1st Sept we had been letting our house at Merthyr Avenue. At present we have no tenants, and in the process of selling house. There is no meter at this property. Obviously we are now liable for bills since 1st Sept.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74496, 'Relocating to Bournemouth, Please remove my interest from 28 Jessie Road with effect from the 30/11/2015 and provide me with confirmation this has been done. Please send any final bill to my new address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74542, 'Sorry - just submitted this a moment ago however I put the move out date as November which was incorrect.\r\n\r\nAlso living with partner at new address so Mr Darren Harbut will need to be added to the account.\r\n\r\nNew property will be occupied by 2 adults 1 child'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74743, 'We moved into this property on 10.08.2015 and notified you of this development. Our concern is that someone from your company has hand delivered a letter asking for previous tenants to repay their debt. we do not know where they live and ask if you could make us responsible for the bills from 10.08.2015. The household is managed by an estate agent called Eayres who are based in Waterloovile and you can contact them for further clarification. Their contact number is 02392259226 and the landlord is called Lois 07882518844. thanks Humphrey'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74879, 'We are moving out of this rented property and are moving into two separate properties, both of which have pre-existing accounts with Portsmouth Water so Lee Swinford, and Daniel Clark will not be responsible for the charges at either new property. Please close this account down with Portsmouth Water at 66 Sunlight Gardens with effect 09/12/15.\r\n\r\nAnnette McHugh is the landlady of 66 Sunlight Gardens. We believe that a new tenant will be moving in to the property with effect 12/12/15 but we cannot confirm any correspondence details of the new tenant(s).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74880, 'We are moving out of this rented property and are moving into two separate properties, both of which have pre-existing accounts with Portsmouth Water so Lee Swinford, and Daniel Clark will not be responsible for the charges at either new property. Please close this account down with Portsmouth Water at 66 Sunlight Gardens with effect 09/12/15.\r\n\r\nAnnette McHugh is the landlady of 66 Sunlight Gardens. We believe that a new tenant will be moving in to the property with effect 12/12/15 but we cannot confirm any correspondence details of the new tenant(s).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (74897, 'HENRY SMITH PASSED AWAY ON 14/12/2014 AND YOU WERE ADVISED OF THIS IN JANUARY 2015, AND YOU WERE ASKED TO AMEND THE ACCOUNT HOLDER NAME FROM HENRY TO ME, VIOLET SMITH, HIS WIDOW.\r\nI AM MOVING TO MY NEW HOME ON 30/11/2015.\r\nTHANK YOU'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (75449, 'Junc of Woolston Road &amp; Gorley Court, Warren Park, Havant. Sorry no info on the drain cover that I can see but water is coming out of it and running down the path as well as puddles on the path. The drain cover also looks as if it has been run over.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76618, '********we have moved into our house at po119sq and retired from our job at  ** gu27 3nd ** which was a postal address for po119sq *******\r\n\r\n********** All Mail must go to PO11 9SQ only Please **********'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76636, 'I have sold 6 Singleton (which was my holiday home) and completion is due on 3-Dec-15.  I haven\'t therefore moved to a new address but have had to fill in this information according to your form so the Ferry House address details are simply those of my main residence where I have lived for over fifty years.  I hope this makes sense.  Is there any rebate of my water bill?\r\n\r\nI have left the meter reading box blank as I am not metered.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76733, 'I have moved out of the Portsmouth Water area and sold my property in Southsea with effect from 12th October 2015 so would be grateful if you would refund any outstanding charges and close my account please.\r\n\r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76830, 'My wife and I are both on the Portsmouth Water correspondence, and we are both moving to the new address (form only allows for one person).  We haven\'t moved yet (am submitting this on 29/11) - we move on 4th December.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76923, 'Please note that I was unable to get a final meter reading. The house agent (whitesagency.com) said they would do this. I have moved back with my parents temporarily and the property at 46 Highbury Grove is already covered by its own account.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76924, 'Please note that I was unable to get a final meter reading. The house agent (whitesagency.com) said they would do this. I have moved back with my parents temporarily and the property at 46 Highbury Grove is already covered by its own account.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (76957, 'I have sold 35 Park Farm Avenue and I am moving in with my Daughter and Son in Law, Mr &amp; Mrs Toms, at 66 Paxton Road, Fareham, Hants, PO14 1AD.\r\n\r\nThis is a temporary move, as my Daughter has sold  her house and are awaiting a completion date.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (77132, 'I did not have the ability to get a final meeting reading- please can you take a reading or make an estimate. I appreciate my account is in arrears - I am committed to resolving this - please send a final statement and bill to my new address in Bristol and I will settle all outstanding amounts. Thanks Loana-Nathalia'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (77168, 'Overlap in previous rented address and purchased new address, previous tenancy finishes on December 13th however we have already vacated the premises and moved into the new address on the 28th November'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (78046, 'Tenant S Mullings has vacated 23/11/15 to 15b Waverley Road Southsea. Property is empty and unfurnished and will be sold. Please send all correspondence to owner K Hewett 3 St Andrews Rd Farlington Portsmouth PO6 1AD.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (78184, 'We previously completed a from and sent an email out when we completed on the above property but have not heard back, logically we would like to setup our direct debit for the supply. We completed on the date above, but have not moved in.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (78578, 'Hello, I would like to ask about payments for Portsmouth Water to property above. How much we have to pay till this moment? Is it paying only per 3 months or is it possible to pay for it every single month?\r\n\r\nI am forward to hearing fromyou.\r\n\r\nKinds Regards,\r\nDorota Lipczynska'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (78932, 'I am writing on behalf of my parents to inform you that they moved into a Care Home on 27/5/15 and I sold their house on 2/12/15.\r\n\r\nPlease direct any correspondence to me at the \'new address\' entered above, but please note that I am not a new bill payer.  I have lived here for 20 years.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79061, 'No meter at previous address, fixed licence fee.\r\n\r\nPlease can I also authorise my partner Mr Neil Victor Usborne to have access to my account as he is jointly responsible for bills in the new property.\r\n\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79266, 'I am already a customer of yours for my property at:\r\n\r\nFlat 18 Marden House, Dial Close, Barnham, BOGNOR REGIS PO22 0JL\r\n\r\nHowever, at least until mid-January 2015 I will own both the Barnham property and the Chichester one.  Can I have these two properties assigned to my account please, so that I can manage them both under my existing log-in.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79511, 'We couldn\'t find a metre, though it looks ready to have one fitted as the white plastic hexagon fitting is there. We use less water than estimated for a couple, so we would prefer to have one fitted if possible please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79657, 'we are moving on the 11/12/15 .there is no meter to provide and I have already called and stayed on line foe a good 20 minutes as they weren\'t  help with my request as the address on the bill is not correct.\r\n\r\n( the address on the bill is : 2 park cottage Arundel Road Boxgrove Chichester PO18 0LH\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79761, 'A letter was sent recently to the previous address despite a postal redirect being in place. Please send all further correspondence to the new address on Shaftesbury Road.\r\nServices from Southern Water have already been moved between the addresses.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79778, 'A letter was sent recently to the previous address despite a postal redirect being in place. Please send all further correspondence to the new address on Shaftesbury Road.\r\nServices from Southern Water have already been moved between the addresses.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79941, 'We haven\'t left our previous address yet - old address is 12 denewulf close, so32 1gz and  we\'re still living here and paying for water until decorative work completed on our new house.  We\'ll let you know when we move but we need to start paying for water on Wyedale.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (79955, 'Mains comes in through copper pipe which comes up through hole in concrete floor, which is rendered over.\r\nThe area around that pipe is surrounded by a puddle of water, although the internal stopcock shows no signs of leakage'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (80132, 'This leak has been there many months and I wonder why it has not been repaired before. The water, although small, runs across the road and can be dangerous in icy conditions. The rest is yours! Thankyou.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (80348, 'our new property is available from 10th December.we will move out from our old property on 17th December. we haven\'t got meter reading in the flat. It should be checked by Portsmouth water . Please take the meter reading on 17th December  to give us a final bill.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (80403, 'Please send all related correspondence to Mrs S. Blackburn, 17, Victory Road, Stubbington, Fareham, Hants PO14 2SE . The property this e mail refers to is a rental property and will be unoccupied for a short period. The forwarding address for tenants who vacated the property on 8th December is: Mr &amp; Mrs J Pope, 162, Gudge heath Lane, Fareham, Hants PO15 6PX'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (80813, '18 Viking Close will be vacant but still owned by us. It will be on the market until the end of december, and will become a rental property in January if it has not sold in the next few weeks.\r\n\r\nPlease call me on the 10th or after midday on the 15th as I am working night shifts from the 11th to the morning of the 15th.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (80913, 'Bills at old address (Station Road) were in the name of my partner - Helen Mary Streeter.\r\n\r\nI believe you are aware of our move to the new address but don\'t think you know that we have left the old address so providing this information to enable accounts to be linked, etc. as required.\r\n\r\nThanks,\r\nSam Bowden'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81112, 'I recently had to turn off our water supply for a repair in our property and noticed that the stopcock chamber was full of water. I have checked again and the water is still there presumably indicating that the stopcock is leaking.\r\nPlease note that there will be nobody at the propert on Friday 11/12/15.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81144, 'All I\'m doing is telling you the meter reading when I moved out  on December 8 so you can sort out my final bill with you. I assume it\'ll be reflected in my last direct debit at the end of this month. I gather I now get my water here from Southern Water, so it\'s good bye and thank you !'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81212, 'I was a tenant of Mrs. Harris, and have now moved abroad to work. My tenancy finishes on 31/1/2016 and Mrs Harris will be taking over the flat with effect from 1st February 2016.\r\n\r\nMy mail is all being redirected automatically to my parents who will handle correspondence in my absence.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81225, 'Hi, this is Francis Kane landlord of above property and I have completed this form on behalf of new tenant. I do not know his dob.\r\nChelsea Campbell moved out of property 9/12/15.\r\nRegards Francis Kane 07962 226239'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81238, 'Hi, this is Francis Kane landlord of above property and I have completed this form on behalf of new tenant. I do not know his dob.\r\nChelsea Campbell moved out of property 9/12/15.\r\nRegards Francis Kane 07962 226239'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81873, 'Please send final bill for old address and new bill for new address to 306 Allaway Avenue.\r\n\r\nWe moved out of 42 Goodwood Road on 13th September\r\nWe took ownership of 306 Allaway Avenue on 14th August but only moved in on the 13th of September\r\n\r\nProperty ref number for 306 = 70797462\r\nMy account number for Goodwood = 9032687501'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81948, 'I will be completing purchase on 16/12/2015.\r\nI will be the only person living at the property.\r\nI have been informed that there is currently no water meter.\r\nDo I have to contact Southern Water and inform them of this information separately? \r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81980, 'Updated information\r\n\r\nChelsea moved out 9 Dec 2015 and gave no forwarding address\r\nJake Jenkins and Stacey Hughes took over property 10 Dec 2015 and cancelled 12 Dec 15. \r\n13 Dec 2015 Florin Niki Arghirov took over property. DOB not known\r\n\r\nRegards Francis Kane 07962 226239'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (81994, 'Updated information\r\n\r\nChelsea moved out 9 Dec 2015 and gave no forwarding address\r\nJake Jenkins and Stacey Hughes took over property 10 Dec 2015 and cancelled 12 Dec 15. \r\n13 Dec 2015 Florin Niki Arghirov took over property. DOB not known\r\n\r\nRegards Francis Kane 07962 226239'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (82365, 'Dear Sirs\r\n\r\nMy family and I have moved out of 64 Central Avenue, North Bersted, PO21 5HW on 11 December 2015. We now live at 111 Monks Road, Exeter, EX4 7BQ. Please update your records and send any remittance advice to our new postal address or to jamessimoncleveland@yahoo.com.\r\n\r\nWe moved out on 11 December 2015.\r\n\r\nI have also emailed head office.\r\n\r\nMany thanks\r\n\r\nJames'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (82690, 'Flat is actually empty.  I currently live in Winchestser but visit the flat ocassionally. There will be some friends staying in the flat over Christmas who will be using the water supply.  I will be moving into the flat full time in Spring 2016.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83084, 'Hello,\r\n\r\nI am in contact as since we have moved into our house on 20/08/15 we have not received any documentation of bills.\r\n\r\nPlease can this be sent with account numbers etc.\r\n\r\nRegards,\r\nMatthew King'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83119, 'Moved into partners house who is already paying for water bill so I will not need to be charged. My mum and dad own my old address which I rented off of them: \r\n\r\nRussell and Julie Smith\r\nContact details : 02392699509 (usually have to leave a message)'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83139, 'New address is for the new build house and we will start to pay from the meter readings provided (water meter reference number is 15192418). Currently this house is empty and we still live in 40 Tideway until 31 January 2016.\r\n\r\nI would be grateful if you can send in our final bill to 40 Tideway until 31 January 2016.\r\n\r\nI also would be grateful if you can update your records with my marriage surname which is Mrs Jurgita Mikolaitiene. Miss J Gavenaite is my maiden name.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83300, 'I am out of the U.K. from 17/12/2015 until 01/04/2016. Please note that any final payment due will not be made until my return as I will not receive a bill unless sent via email. I will monitor my email account but infrequently as I am travelling. On return I am staying with my parents who will already pay for their water via relevant suppliers. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83625, 'What I think is the tank overflow is pouring out the side of this house in to the alley between our houses and has been getting worse over some considerable time. The landlord for this house lives at number 17 hilldowns avenue. I would like to stay anonymous as we do not get on. It is causing damage to both property\'s and the ground is soaked.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (83679, 'What I think is the tank overflow is pouring out the side of this house in to the alley between our houses and has been getting worse over some considerable time. The landlord for this house lives at number 17 hilldowns avenue. I would like to stay anonymous as we do not get on. It is causing damage to both property\'s and the ground is soaked.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (84434, 'I am buying this property and completion is on 22/12/2015.\r\nI understand from the vendor that you have been providing a service to the tenant who vacated on 21/11/2015.\r\nI am interested in you providing me this service.\r\nI am resident in Australia but my daughter lives in the UK.\r\nI spend a lot of time in France each year and now possibly more in the UK.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (84556, 'Not moving - executor for Mrs Jr. Freeman former occupier of 4 east way. East way is now let, the tenant who is responsible for all bills moved in 17/12/15. Final bill to be sent to 7 Outram way, Hunston please'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (84731, 'Hi My mum had a fire at 21 Grafton Street, Portsmouth, PO2 7LJ AND HAS MOVED TO A TEMPORARY ADDRESS UNTIL THE END OF APRIL 2016:\r\nNEW ADDRESS: 12 NORRISH COURT, PORTSMOUT, PO1 5QL.\r\nPLEASE CAN YOU CHANGE OVER HER ACCOUNT TO THE NEW ADDRESS AND ADVIS WHETHER HER PAYMENT CARD IS STILL VALID OR IF SHE NEEDS A NEW ONE.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (84739, 'Hi My mum had a fire at 21 Grafton Street, Portsmouth, PO2 7LJ AND HAS MOVED TO A TEMPORARY ADDRESS UNTIL THE END OF APRIL 2016:\r\nNEW ADDRESS: 12 NORRISH COURT, PORTSMOUT, PO1 5QL.\r\nPLEASE CAN YOU CHANGE OVER HER ACCOUNT TO THE NEW ADDRESS AND ADVIS WHETHER HER PAYMENT CARD IS STILL VALID OR IF SHE NEEDS A NEW ONE.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (85322, 'I will be leaving the accommodation on the 20th of January 2016. I will leave the UK on the same day too and I will no longer require your services.\r\nI have bill that is due on 1st of January. Please advise what is the remaining balance to be paid.\r\nThanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (85338, 'David was deaf he move out his old address and new flat on Monday 21st Dec 2015\r\nPlease send me e mail and I see him not far my live and help him everything please don\'t call me I am deaf as well only e mail \r\nRegards\r\n Lorraine davey'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (85492, 'Moving to new house on 29th December 2015  but lease expires on 31st December 2015  for Ruskin Road. Ruskin road will therefore be empty from 29/12/15 until any new tenants move in.\r\nLandlord is Mr Chris Male, letting agents are Kings Estate Agents 02392 298080'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (86056, 'I will be moving out of a shared rental on the 22nd January. The current account holders are myself and Maria May. Maria will be staying at Wainscott and I will be moving into Devonshire Avenue with Mr Ben Farrant on the 22nd January 2016.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (87036, 'We are an existing customer (a/c 9251945501), but this is a second house. We are currently putting our old house on the market but will be living in BOTH properties until the sale.\r\n13 Donigers Close, Swanmore, SO32 2QJ'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (87408, 'We moved into this new build on 20/8/2015 and was advised that the water had already been set up, but as yet not received a bill.\r\n\r\nCan you confirm whether an account has been set up or if not please could one be set up.\r\n\r\nRegards,\r\nMatthew and Michelle King'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (87584, 'We will be the tenants of 73 Binsteed Road until 26th January 2016 but will own the house at 5 Nashe Way from 7th January 2016. I have paid the last bill which is valid until 1st July 2016, £37.07 with reference for payment 92537, paid at 07/12/15. Please let us know if the amount will be transferred into the new house (which we would prefer) or if you will be giving us a refund.\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (88119, 'My purchase of this property will complete on 8/1/16, I will not be moving in at this point but will be using water for decorating etc with plans to move in completely over the following few weeks (correspondence can be sent to the address during this time). I cannot respond to my phone number while working so please leave a message if I do not answer, alternatively I give permission to talk to my family at my current address on 01329 221697.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (88263, 'Please note Verena Sambel moved out of the property (2C St Cyriacs, Chichetser, PO19 1AN) on 3 December 2015. The names of the new tenants are Miss Natalie Halliday and Mr Matt Sewell and moved in on 4 December 2015.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (88468, 'myself, kristina tamoseviciute and ms sabine denk were tenants at 64 victoria road north and moved out from the property. please remove our names from the property billing as we both relocating and someone else will be moving into the above property as arranged with the agency/landlord. our account number 9399768001'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (89395, 'The completion date for the sale of the Evelegh Road house is 11th January 2016 and Mr and Mrs Stokes will be moving in on that date.\r\nWe actually moved to our new East Marden address on 30th December 2015 but the completion date for the purchase of the East Marden house was on 28th October 2015 and we informed you then that we were moving there. Our account with you at the new house is in my wife\'s name, Claire Flatman.\r\nIf you need to contact me, the best way is by email as I work abroad.  You can always contact Claire on the 01243-535091 number if you wish.\r\nWe made our final payment for the year to you for the Evelegh Road house on 8th January, so I assume that there will be a refund from 11th January to the end of the payment year.  Will you be sending out a final statement for the Evelegh Road house and can you pay any money owing to the same bank account that you have been using for taking the payments?\r\nI look forward to hearing from you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (89446, 'Hi\r\n\r\nI have just moved and Linden Homes may have informed you but they have not informed the Gas and Electric yet so I am doing it just in case.\r\n\r\nCan you confirm that you contact Southern Water to deal with my Waste Water Bill as I believe they work it out on the volume of water I have used?\r\n\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (89716, 'Hello. Sorry there was a misunderstanding about my moving. Please can you count my bill again. From 21 Dec 2015 to 18 Jan 2016 i\'m responsible for 2 properties (old and new address ). Thank you\r\nBest regards'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (89755, 'This is a new development by Seaward Developments - the house will be transferred to my wife and I on February 29th - you are the current fresh water supplier and we would like to have the account transferred to us. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90029, 'It has been brought to our attention that we are paying well over the guide lines for the supply. There has only been the 2 of us in the house for 25 yrs, we have no bath, and your estimates of use are well above our usage. Our sources tell us we are entitled to quite a bit of rebate.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90083, 'Please note I am a relocation agent assisting Lucas with his current move from Canada to the UK. The telephone number provided is my number. ( Janie Albertini ). If you need any more information at this stage please don\'t hesitate to contact me. Lucas will actually move into the property later this month though his lease started January 2nd.\r\n\r\nKind regards\r\n\r\nJanie Albertini'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90179, 'I have rheumatoid arthritis and receive DLA benefit as I have mobility problems. Sometimes I need a bath each day as my joints are painful and soaking is easier than showering, but expensive, so I am concerned I would have to limit them if I got a water meter. However, I would save a lot financially p/a. Is there any reduced rate available due to my circumstances?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90289, 'Property purchased on 30th October 2015.\r\nI understand Portsmouth Water supply this property with water.\r\nPlease let us know, by email preferably, any outstanding amount and how we can pay by monthly direct debit until we will  rent out the property in the near future.\r\n\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90848, 'The leak is coming from what i think is the overflow pipe in the tank of number 9. It is leaking in to the alley between our houses and is making my house wet. The house is currently empty but the landlord lives at number 17. \r\nThis leak was reported before Christmas and a water man came out. He told me the home owner had a week to fix the leak or his water would be turned off. After speaking to the home owner, it appeared that the water man was turning off the water and the leak slowed down but it is still dripping and as far as I am aware the landlord has not done any thing about it. I do not want the landlord to know it was me who has Co planned as we do not get on.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (90967, 'Moving from a rented property with shared rent and bills with another tenant, Miss Georgia Loud.  We are both moving back with parents. Both of our parent\'s houses already have their water accounts set up and are responsible for paying, therefore no new accounts need to be set up/parents accounts do not need changing.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (91683, 'I thought it was because the water wasn\'t able to drain, however yesterday I went with a broom and swept the water into the road. Overnight it has filled up. It has become very slippery and my daughter nearly fell over as it is becoming iced up in the cold temperatures.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (92437, 'supply pipe is about 100 metres, but 60 metres run under the adjacent property\'s grass area the let by is likely to be here, but digging many holes could be messy (the pipe has been located)\r\n\r\nIf it is possible to detect the let by along this pipe I would be most grateful\r\n\r\nCan you help-------- I don\'t  mind paying for any work'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (92713, 'Was advised by a customer that there is a heavy leak in the area of Haglane Copse, Lymington, Hampshire. Customer did not want to make another phone call. Advised worried about freezing over. Have tried to get through on emergency but no answer after ten minutes. Advised by southern water that it is Portsmouth water for supply.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (92821, 'I have reccently opened a letter addressed to the previous tenent, noting that there is an overdue bill. Till this date, 19. 01. 16 I had not been aware of any bills as they had the previous tenants name on but opened today when I saw three letters in a pile of uncollected mail. I am happy to pay the current amount due from the date I moved in. If a current bill with my name could be sent I will pay it.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (92850, 'Water consistently present despite no rain. Evidence of increasing flow rather than just pool of high water table.  Suggest check of mains location from your records as we think it may be close to main. Please call if further info wanted, as this leak is prior to our water meters.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (93012, 'Two adults, two small children.\r\n15 showers a week.\r\n1 bath a week.\r\n9 washing machine loads a week (economy setting).\r\nToilet flushed 15 times a day.\r\nNo dishwasher.\r\n\r\nSewerage bill from Southern Water c. £540 a year.\r\nEstimated savings (calculated through Moneysavingexpert) over £200 a year.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (93291, 'Please let me know if I need to set up a new direct debit or can my current one be taken with me with amendment to amount if required.  Also, please advise if the new address has a water meter and, if not, can I have one fitted please?  thanks, Sue Dixon'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (94241, 'I have moved from 12 Falconer House 22 January but am responsible for the bill until 28 February when the Contract ends.\r\nPlease forward any outstanding monies owed to the new address.\r\nPlease note the new address is my husbands and he is already paying the bills at the said address.   We are just moving in with him.\r\nMany thanks Mrs Miller'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (94339, 'We are moving on Friday 29th January 2016.  We wish to continue paying by Direct Debt at the new house.\r\nThere are no meters at either property.  \r\nPlease confirm the change of address has been processed and confirm how much the new direct debit will be at the new house.\r\nthank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (94496, 'Mr A Davidge passed away in June 2015, Mrs D Davidge is his widow and living at the property. Her daughter, my wife, has POA over her mothers affairs and I am the executor of Mr Davidge\' s affairs. The contact number is mine, Neil Kirby, as Mrs Davidge is unwell.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (94751, 'We became aware of a leak in our property as we noticed the internal walls were becoming wet from the ground up. I have started a claim with my home insurers and they sent out an Investigator from Drainage Advisory Services &amp; Assistance  (DASA) They have determined through their investigation that that the leak appears to be on a Lead main and it is leaking due to the supply pipe effectively being at the end of its useful life.\r\n\r\nThe pipe runs straight through my house from the little metal flap outside the house on the pavement, straight through to where it attached to the boiler. As it is a water main, is this something you can assist in fixing?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (95597, 'Joint responsibility of bill for both addresses - 62 Lawrence Road and 56 Prince Albert Road - with my housemate Zaneta Ladanovskaja who is also detailed on the bill for 62 Lawrence Road.  Please let me know if you require further information.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (95804, 'I moved to this house on 22nd Jan 2016. Please confirm that you guys are supplying Fresh Water/Drinking water to this address or not. If you guys are supplying the fresh water then please help to setup my account and also let me know about the charges.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (95982, 'Water seeping up from below the kerb stones and beginning to flood the land surrounding 436 and 436a Havant Road. Has been like it for a few days; initially thought it might be run off from Portsdown hill but is too localised.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (96013, 'There is an overlap of tenancies so we are responsible for the water bills at Chichester Road until 18/02 and for 11 Avocet House from 08/02. \r\nMrs Barbara Hallin DOB 03/03/52 is jointly responsible for the bills.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (96496, 'We are renting an unmetered property so cannot provide a meter reading. We have set up an account with Southern Water for waste water services, but were advised to also set up an account with Portsmouth Water for fresh water services.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (97090, 'Do not know how to read meter for final reading at 19 Little Green and am unsure whether water is metered at new property. Would like you to read meter and send final bill to new address and to start new direct debit payments for new address. Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98344, 'I am the landlord for the property and bought the house recently with completion and exchange on 13 Jan 2016.  The property has been rented with tenancy due to start on 12 feb 2016.  the property has been empty between these two dates.   My letting agent is David Seymour, 89 Stoke Road, Gosport PO121LR'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98403, 'This is a Second home being sold . My own home address 82 Kings Mede horndean waterlooville po8 9th has nothing to with anything and has only been used by yourselves to send the bills to bills thank you .'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98449, 'As attorney to my mother, Mrs JRS Sweet, I am writting to inform you that she moved into a residential care home some time ago and that her house has been sold.  Completion of the sale was 29th January.  The new owner of 3 York chase is Mr C Muller.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98642, 'I purchased the above property on the 22/12/2015 but unfortunately have not been there as my father is very ill in a hospice so everything has been on hold and I am staying in wiltshire, and I forgot to contact you. I am not at the flat as yet so can not give a meter reading, but if you need me to sign any paperwork please email me or fwd to 22 huntingdon rise bradford-on-avon\r\nWiltshire BA15 1RJ i am hoping to move in in the next few weeks many yhanks Julie whitehill'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98699, 'Two days ago workmen dug and installed fittings for 4 meters on Coxes Road adjacent to our block of flats Only one has a meter installed. There are apparently 4 others which were provided some years ago, not all of which have meters in them. Flat 9 is on the first floor.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98770, 'Though I have had to put "moved to new address" above. I have not moved house. The property has been purchased for letting unfurnished. It is currently vacant. I will advise when the tenancy commences when the tenants will become responsible for water rate'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (98877, 'We are moving out of our current rented property on the 5th and won\'t be moving into our next rented property until the 18th February. During that time we will be staying with friends, so if possible could our services be put on hold during that time. The account with you is under mine (Sarah Maitland) and my partner\'s (Matthew Smith) names.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99078, 'I already paid water bill before, probably by March. it is over 9/Feb (this is the 22 Andover road property contract period). so How can i get refund this over period? and the new property is managed by property agent.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99126, 'There are no people living at the house, but I could not choose that option as it is not available.  It will be empty for about a year with possible building works, toilet flushing, general cleaning, and tea making water consumption only.  The property is currently jointly owned by four siblings who intend to improve it and sell it on as soon as possible.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99262, 'I change my surname to my marriage name. I informed you a few months ago but I noticed that my bills are still coming with my old name. Kindly please update. I would like to be addressed as Mrs Ethel Male on my bill please.  Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99276, 'I change my surname to my marriage name. I informed you a few months ago but I noticed that my bills are still coming with my old name. Kindly please update. I would like to be addressed as Mrs Ethel Male on my bill please.  Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99344, 'On the billing account there is 2 names mine and my husbands \r\n\r\nMy name is changed to andrew Burnley-Adams and his has also changed from camron adams to camron burnley-adams  if both these can be updated please'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99706, 'New commercial water supply connection for premises on site not yet developed. \r\n\r\nWe require.\r\n1.25 litres per second peak flow\r\n50mm MDPE incoming supply pipe.\r\n7,500 litre (actual) storage tank providing 8 hours storage'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (99953, 'I may have already informed you of our move to our new address; however, at that time, I was still responsible for the old address.  This is now not the case; as of 6th Feb 2016 I am responsible only for the new address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (100239, 'I have received correspondence addressed to Fiona Mowly please amend surname to Molloy. The account number is 94197967 01.\r\n\r\nI would like to set up a direct debit please. there was no mandate enclosed as stated in the letter.\r\n\r\nI owe you £10.55 which I will pay online.\r\n\r\nBest Regards\r\n\r\nFiona'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (100421, 'Currently, there are no dwelling(s) on this site and the main water line has been shut off.\r\nWe (the owners) will start the construction of a new property at this site commencing April 2016.\r\nTherefore, we would like to have the water service re-connected from the 1st March 2016'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (100632, 'Dear Sirs, \r\n\r\nI had initially tried to simply move connections with Southern Water who I had previously been with but since they advised they would manage this process I have heard nothing from them, so rather than some hybrid two tier supply system I need to set up a supply account with yourselves.  Effective from the above date.      \r\n\r\nNot sure if it assists tariff wise but there are two people in the house, both work full time Monday to Friday,  showers used instead of baths, dishwasher is 12 place so once a week, and washing is on ECO setting for water use so water usage should be relatively low.    Let me know what other info is needed to sort this out.  \r\n\r\nThanks for your help \r\n\r\nYours faithfully \r\nSTEPHEN GREEN'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (101037, 'Block of new build townhouses immediately north of Spiritualist Church - water flowing from garden wall. It\'s pretty obvious where it is - follow the water trail from West Street, Havant!!! Or up from Solent Road/Selborne Road, Havant.\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (101128, 'Former landlord and owner of 54 Hambrook Street - property now sold on 10th February.  On 30th October I paid £105.54 up to 30 June 2016 so please contact me to arrange a refund for the remainder (approx £60).  \r\nMany thanks\r\nA M Dimbleby'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (101183, 'The end of our driveway and the adjoining road always seems a bit wet compared to everywhere else.  Not obvious when its been raining so much but with drier weather (especially this morning) it is clear that it is wet and everywhere else is dry so I wonder if there is a source of water from a below surface leak'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (101682, 'Apologies, I do not have my Customer Numbers to hand - I have 2 accounts, one for the above address jointly with Mr J  May and another one for Field 1, Woodhouse Lane, Blendworth, Waterlooville, PO8 0QG.\r\n\r\nI would be grateful if you could kindly update both account names.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102058, 'We have moved address to Chichester but have received a bill for £82.26 for our old address dated 2nd February 2016. We had previously updated our details via this website but it doesn\'t seem to have worked. Thank you\r\n\r\nDarren Guy'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102095, 'I\'m uncertain as to how the water system works at the flat as I am a First Time Buyer. There is a tank in the airing cupboard with what looks like an immersion heater. Any clarification on rates, payment methods and the likely cost per month would be appreciated.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102210, 'I need to understand where the meter would be situated - I have a conservatory built onto the back of the house, and there is a manhole under some furniture, although it is accessible once that and the carpet are pulled pout of the way.  But would the meter be outside the front of the house, off the property, so to speak?  Thanks!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102562, 'As you can see from the above new address we are leaving the Portsmouth Water Company area and understand that our new water supplier will be Southern Water.\r\nThank you for your excellent service over the years'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102916, 'Dear Sirs\r\nMr Arun Shinde moved out of my flat on 14th Feb and there is 1 week where it is totally unoccupied.  Mr Lew and Ms Kesarkar move in on Monday 22nd February.\r\nThere will be no use of water during the void week.  If there is any charge for the void week please send the bill to me at , 21 Green Lanes, Epsom KT19 9TW as I am the landlord'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102917, 'the couple moving in will be in touch in due course or just write to them if you haven\'t done so already as Mr Shinde may have given you this information when he moved out.\r\nPlease confirm receipt and any action required by me\r\nJohn Johnson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (102986, 'I have filled this form in for my parents who are elderly and not conversant in such things, in an effort to try and save them some money,.\r\nThe email address is mine. They did not have a reference number to hand but I assume you can do this without.\r\n\r\nMartin Camp'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (103007, 'Please remove my ex husband Mr A Carnell from this bill please.  Bills to be addressed to Miss T Williams as I have returned to my maiden name (you had my initial as A previously but should have been a T) many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (103144, 'My mother ,Mrs Matthews, is currently responsible for the water charges at 65 Mayfield Road and will continue to be.\r\nHer account details and information should remain unaltered.\r\n\r\nI am moving from my house which will be unoccupied for the next few weeks until being put up for sale.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (103526, 'Took possession of the house on 12/02/2016 but didn\'t move in until the 17th.  There are 2 people living in the house and we\'d like an application for the installation of a water meter sent to us please.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (103669, 'The above address , 10 Frensham Court was rented to the Rogerio and Anna Lopez from the 15th August 2015 until 15th Feb 2016. They were paying for the water. Their tenancy has ended and I would like to pay the further water bills. Please contact me at the correspondance address for methods I can pay.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (103792, 'I have keys to property but needs a lot of work before we move in painting and carpeting  , as my 4 week old daughter can not live in the property in the state it is . \r\nPlease could you sent me bills and information as this email address will no longer be in use once I move to new property . Many thanks Zoe green'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (104890, 'We are moving out of West Sussex on 26/02/16 and will be moving to Somerset where I don\'t believe Portsmouth water cover. Please send outstanding bill up to the above date to the above address in Somerset.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (104925, 'I have moved abroad. There is a tenant moved into the property on 3rd February 2016. They are responsible for the bill until the tenancy expires on 1st February 2017.\r\nMy direct debit bill will need cancelling.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (104961, 'the property we are vacating is a rented property, the owners name is Brian Fazackarley and we rent his property through Chapplins, 9 Clock House, Waterlooville, PO77HE. We do not have another property where we will be responsible for a water bill as we will be staying with family. Any correspondence required after our vacation of the property, for our final bill, can be sent by email or to 3 Gudge Heath Lane, Fareham, PO155AB'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105543, 'I moved in as a temporary tenant (from 8 Jan. 2016 until 8 August 2016). The reason for the late application is that I wasn\'t informed by the letting agency that I was supposed to contact "Portsmouth Water" myself for payments regarding my water usage.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105557, 'My account was previously in the names of Miss I Hinton & Miss A Vickerstaff.  Miss A Vickerstaff is no longer resident at this address and therefore please can my account be amended to just include Miss I Hinton\r\nKind regards, \r\nIsobel Hinton'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105835, 'I found out this morning that I am due to complete on my purchase of the above property on 1st March 2016. Please could you arrange for meter readings and add me onto your contact list for the property'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105851, 'I have PTSD and am unable to use the telephone. Email contact is best, and replies are normally promptly sent.\r\n\r\nWe moved in to the property on 29th January 2016. We were told that the estate agents would let all the utility companies know of the move in, but this now appears to not have happened.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105911, 'We were told that a family member updated our details on all of our bills however, this one must have been left out. Not realising this, we have now received a bill and are unsure whether we are liable for all of it.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (105978, 'Unable to locate the squarehead shut off valve under the water in the meter position.    The village hall manager is Mr MORRICE 07775325335, who will attend to shut off water in the village hall during repairs.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (106586, 'Me and my partner Agita  Gulbe have paid full bill of £139.23 for previous address of period 07.11.15-30.06.16\r\nWe moving out of this property and would like to get re found or transfers to new address. Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (106645, 'Property Reference Number: 72207180\r\nApologies, I am the landlord of this property and hadn\'t realised there was post to deal with as my letting agents had piled it all in a cupboard!  Flat has been empty since Sep\'15 and now on the market.  Please let me know any charges owing to date and how to proceed with billing, thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (106733, 'My husband applied for a water meter at least 10 months ago, since when we have heard nothing from  you .He is now in a nursing home and I would like to have a meter fitted as soon as possible\r\nYvonne Hudson ( Mrs )'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (106746, 'Although we completed on this house on 19th Feb we are still living at our current address 14 Blackbrook Rd Fareham PO15 5DJ so at the moment we are responsible for water at both properties. Property reference at Madeira Rd is 70691080'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (106775, 'Please be advised that Anna Richardson, previous contact, is no longer employed by Clanfield Parish Insitute, hence the change of contact name and address.  Please forward all future correspondence to 35 South Road.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107098, 'Not sure of the correct date for new address but have been responsible for both addresses for some time. 2 Gloucester Road is now sold with completion 2nd March 2016 so request this account is closed from this date.\r\n\r\nThank you\r\n\r\nAngela Burton'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107323, 'I am not sure about the feesability of a water meter, but I have several friends on the Island and they are all on meters and paying a lot less than I pay so please could this be looked into...Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107381, 'Fire Hydrant Cover on Junction of Townhall Road PO9 1AN and East St Havant..  it\'s been leaking from the cover for a few days, can\'t tell if it still is because it\'s raining - it might have been fixed. The cover is right in the middle of the Townhall Road junction where it joins East St.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107750, 'The house at 47 Merthyr Avenue has been unoccupied for the last 6 months and today was sold/sale completed.\r\nWe will be expecting a refund from you as we had previously paid to cover up to 30 June. \r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107854, 'I am moving out of the area on 29.03.16 \r\n\r\nI have not exchanged on Rolleston road yet so may not move in on the date above. \r\n\r\nTemp address if I can\'t move in on 29/03/16 will be \r\n3 Stanhope St Winshill Burton on Trent DE15 0LS\r\n\r\nI will be cancelling my direct debit after March payment is made if I owe anything please contact me by email if you owe me please recreation my bank account\r\n\r\nMel Hutchinson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (107874, 'I am moving out of the area on 29.03.16 \r\n\r\nI have not exchanged on Rolleston road yet so may not move in on the date above. \r\n\r\nTemp address if I can\'t move in on 29/03/16 will be \r\n3 Stanhope St Winshill Burton on Trent DE15 0LS\r\n\r\nI will be cancelling my direct debit after March payment is made if I owe anything please contact me by email if you owe me please recreation my bank account\r\n\r\nMel Hutchinson'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (108009, 'I understand from Southern Water that our meter reading has gone through the roof.  They have told me to contact you in case there is a leak or incase the meter is faulty.  Please can you advise what we need to do?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (108574, 'I wanted to inform you that we have moved out, exchanged and completed sale of our property yesterday on 2/3/16. I have instructed Southern Water to take the final meter reading and send me the final bill. We have a slight delay in moving into 20 Wallisdean Avenue so are expecting to exchange and complete on Friday 11th March 2016. I will contact again once we have moved in as we will need to organise having the first meter reading organised.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (109088, 'We are both long retired occupants of this property and recently we discovered that we may have been paying far more for our water supply than we needed to over the past 10 years? There are only 2 of us living in this large victorian 3 bedroomed house, and I am led to believe that we would save considerably by having a water meter fitted to our services? This being so, then how do I obtain the item and arrange for it to be fitted?  Thank you for your advice and help in this matter.  Derek Usher'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (109201, 'Ms w Stanley has died 6.2.2016\r\nI\'m Mr stanley not been with wife for sometime,\r\nMoved back to look after children and take on with \r\nwhat comes with it . Please send all details of payment \r\nto above address by email or post .'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (109232, 'Hello,\r\n\r\nThe previous council tenant to 1 Whitworth Road has apparently left a debt on most accounts. The housing options team are happy to help with this matter,I hope this will not impact on my home move with yourselves. Thank you Corinne.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (109531, 'I have not yet moved into the property but took ownership at the beginning of December 2015.\r\nThere has been a bill submitted against Account Reference 92241404 01, which apparently is overdue, dated 27th February 2016, but this is the first note that I have received.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110574, 'WE ARE LEETING YOU KNOW IN ADVANCE AS WE ARE NOT ON A METER. HOPEFULLY,  WE CAN SETTLE THE BILL WHICH WILL BE FOR APRIL UP TO 13TH BEFORE WE LEAVE. THANK YOU\r\n\r\nI am re-submitting this form as I accidentally put our Southern water reference on the form, instead of our Portsmouth water  one.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110593, 'Please note I am the landlord for Flat 1 The Cherries and am responsible for the water and sewerage charges from 26/01/2016 to 06/03/2016.\r\nThe meter reading on the 26/01/2016 was 00148 and on the 06/03/16 00149 as the flat was empty during that period.\r\nThe final bill should be sent to me at my home address above. I already have an account with PW for this property.\r\nRichard Oppe'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110668, 'I will move house from 2A ST Andrews road, Farlington, Portsmouth to 55 Porteous Crescent, Eastleigh, Hampshire on 19/03/2016. PLEASE arrange someone to do water meter reading and send me a final bill to my new address after 19/03/2016'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110688, 'I will still own the \'Previous Address\', however, it will be unoccupied until further notice.\r\n\r\nI would also like to put the account of the new address in joint name (myself and my partner).  Please can you advise how best to do this?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110803, 'My wife already has an account at the Newcome Road address to which I am moving, please close my account for my previous Fawcett Road address. Any monies that may be due to me can be credited to the account already in place under the name of Jessica Flynn at 138 Newcome Road, PO1 5DX.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (110831, 'I am notifying Portsmouth Water of our residential property purchase by our recently formed company structure, called - Britannia Gold Properties Ltd, with myself and my Wife as owners, Landlords. \r\n\r\nThe property purchased is: \r\n\r\n66 St Chads Avenue, Portsmouth. PO2 0SD. \r\n\r\nWe are notifying Portsmouth Water as Landlords as we will need to start paying the Monthly Water use charges until the house is let. Currently the house is currently empty, but still using water as being updated.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (111205, 'I have moved to my partner\'s house. She already has water supply accounts. I am just letting you know that a new tenant is moving into 14 Willow Court on Sat 12 so I should not be responsible for the water bill after that date.\r\n\r\nThanks,\r\n\r\nDavid Maw'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (111934, 'I have moved in with my brother and sister-in-law, they already have an account and pay the bill at their address. This form is simply to inform you that I have moved out of 31 Adames Road and to provide you with the final meter reading there so that you can send me the bill for that address up to and including 13-Mar-2016'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112013, 'Dear Sirs,\r\nin case of 2nd Floor Flat, 17Waverley Grove, PO4 0PZ we have paid up to the end of June 2016. Please transfer money back to our bank account:\r\nAleksander&Katarzyna Krupski\r\nRBS\r\nsort code: 16-17-26\r\naccount: 10943549\r\n\r\nThank you very much for your help.\r\n\r\nKind regards,\r\nAleksander Krupski'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112039, 'The house is a new build property built in the grounds of 76 Highbury Grove (I\'m number 76A). I rent the property from Mr David Cleeve, 6 Meadow Edge, Waterlooville, Hants PO7 5AZ\r\n\r\nI completely forgot to register with both Portsmouth and Southern water when I moved in on 19/12/15 so have registered both on line today. There is a water meter at the property. Its a 2 bed end of terrace house and i live there by myself.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112177, 'We are now renting the property in 6 Stein Road, Southbourne. The utilities were set up by the rental agency under the name of my wife: Louise Coates but I am responsible for paying the bills. The new account number is 94258977 01 for the new address that we have moved to.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112238, 'I vacated 4 Peronne Close on 4 March and my main residential address is now 41 South Road however I still own the property 4 Peronne Close and tenants will be moving in under a tenancy agreement on 25 March from which point they will be responsible for the bills.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112303, 'I complete on the house purchase on Wednesday this week.\r\n\r\nPlease could you let me know if I have to do anything on the first day (e.g. take a meter reading) or if this is done by the previous owners?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (112498, 'Hi there! We have a leaky pipe in our basement - a builder who was working there recently advised us that it is an old lead pipe and we should be abe to have it replaced by Portsmouth Water for free. \r\n\r\nPlease let me know when it would be convenient for you to do this. \r\n\r\nRegards,\r\n\r\nEmma'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (113206, 'Hello\r\nWe are going to move out the property  on 29th of April 2016\r\nCould You Please prepare all the bills to that date so we can pay before we go\r\nWe are moving abroad so it might be difficult to contact us after  29th of April\r\nKind regards\r\nMonika'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114244, 'Miss Sturtivant has been in a Nursing Home since 2013 and the flat has now been sold. Please send final bill c/o Marina etc.  Unable to provide meter reading as don\'t know where this is.  Thank you.  Sue Stemp (Niece)'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114265, 'This is a sheltered accommodation address.the manager there will answer any queries,her other phone number is92815465. Mrs pam green.  Do not contact her until after the 8th April  when I move into that address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114418, 'Dear Sir/Madam\r\nI am moving from my current address to Flat 1 Helen Mews, Helen Lane Weymouth, DT4  8AX. \r\nCan you please cancel my account from 31/03/16 and send any correspondence to the Weymouth address. Do not call the number above as its not correct. reason for not giving you correct number is that I work in a surgery during your normal working hours and will be unable to take your call. please contact me by either post or e-mail.\r\n\r\nKind Regards\r\n\r\nSharon'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114637, 'My landlady has paid the bill up to April, and would like me to continue with this year\'s bill from April 1st 2016.\r\nMy flat is one bedroom and I am living alone (can confirm with Portsmouth City Council as currently get single council tax discount), so believe I qualify for lower rate.\r\nPlease send a bill in my name for the sum due from April 1st onward and I will make initial payment straight away and set up a direct debit.\r\n\r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114888, 'Previously reported this and had a handwritten note through the door saying it had been looked at and will be monitored.  Has this been checked again?  It has been dry recently yet there is still a puddle on the road.  There must be a source for this water and it seems increasingly hard to believe its just surface water'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (114905, 'Our letting agent for the new address said something about having registered us (me and my partner Miss Jay Murphy who will also be resident at the property) with you so this address may already be on your system.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (115364, 'Moved out of 131E Southwood Road PO11 9PY on the 05/01/16 and have been living in Spain at my new property, the property has only completed today the 22/03/16\r\n\r\nI am going to stay at a relatives address at 15 Ashwood Close, Hayling island  and do not have pay any bills, can you send final bill to that address Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (115504, 'We take over the tenancy at 24 Grenville Gdns on 1st April, the agent is contacting water/sewerage/gas/electric services for meter reads etc. We move out of 32 Seaview Rd on 8th April 2016 there is no meter at this address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (115705, 'I had a water meter installed but was not given a first water meter reading,\r\nAlso I don;t know which one is my water meter as the numbers on the two just outside the property don;t correspond with the one I was given.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (115721, 'This request is for my elderly mother who lives alone in this flat. As a result of the charges being calculated on the old rateable value she is being vastly overcharged for her water and waste water. I spoke to someone in Customer Services who advised that I should make this application. Please coordinate all contact through me (Glenn Dryer) as Mum is deaf and has poor eyesight and easily frightened. Thank you. Glenn Dryer'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (115798, 'Miss LA Harris has been moved into a residential care home suffering from dementia.  I. Mr WT Swinchatt, have lasting power of atterny for her and all correspondence should be addressed to myself at 8 bramham Gardens KT9 1NG\r\nI have given the letting agents name as the new bill payer as I have no idea who will be resposible'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (116147, 'This is a slow leak which has now been there for a couple of days. The water is running down the gutter and into the drain near the bus stop. It is getting worse each day and the road also looks like it is starting to drop as cracks have appeared.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (116249, 'We complete the purchase of this property on 29th March 2016.\r\nAccount should be in the names of Mr D L and Mrs A M Smith.\r\nWe already have an account at 50 Hastings Avenue, Gosport, PO124BZ Ref: 9221696502 and will be closing this after we have our new property to a habitable state and once our other property is sold.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (116553, '1. Property unoccupied, remaining unoccupied, pending major refurbishment works. Please put the property on a builder\'s supply only.\r\n2. Please use my correspondence address for bills and other correspondence:\r\n57, Brackendale Road, Bournemouth, BH8 9HY\r\n3. Please confirm you will supply this reading to Southern Water for their sewerage billing.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (116706, 'There is a leak from the main shut off tap in the street, when I went to turn it off I found the inspection chamber was full of water. After emptying it it quickly refilled. There is also lots lots of sludge in the chamber as when the water reaches the top of the chamber it is washing back in soil.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (116817, 'My landlord are :-\r\nFirst Wessex, and for three years I have challenged them as to why I am being charged about £300 pa for \'Legionella Testing\'. They state that it is because my supply comes off a \'Communal Water Storage Tank\', and whilst not a legal requirement to do testing, my landlord chooses to charge me for this external testing on their equipment.\r\n\r\nI am very serious about having a water meter as this also affects my waste water charge, plus I can shorten my son\'s showers as he is a bit wasteful in my opinion, and as your records may show, I often report water leaks that I notice. You can search your records using the email address or phone number supplied.\r\n\r\nWhen I last requested to my landlord permission to have a water meter I was refused, but during my investigation regarding the legionella charge when I was asking a member of your customer service for information, to aid my quest, she informed me that I no longer needed permission from my landlord.\r\n\r\nSo if during your investigation you discover, or indeed, fail to discover that the fresh water supplied to my flat comes from a communal water storage tank,  I would be indebted if you could inform me in relevant detail such that if there is no communal water storage tank I can challenge why I am being charged for something that doesn\'t exist.\r\n\r\nI know this seems a long winded thing, but for three years I\'ve challenged this charge, and have only this year been supplied with the communal water storage tank reason, prior to that I was informed it was a \'normal charge\'. So to get evidence of if a communal water storage tank exists or doesn\'t, would be a massive help.\r\n\r\nOf course I am willing to have the water meter in my flat if need be, I\'ll be quite happy to have a water meter to be honest, they seem to have quite good reviews for properties like my own who don\'t use much water, but are charged quite high sewage rates that exceed the cost of their waste.\r\n\r\nKind Regards,\r\nJohn Ilsley.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (117346, 'My tenants are moving out of the above property on 1st April, so I will be responsible for the water bill from this date. If you could please send a bill for my attention to the above addresss so I can arrange payment I would be very grateful. Many thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (118385, 'I have been informed by the the letting agency Tenandfinders who are responsible for managing the property I am renting that they have updated this information (me being the new tenant). However, I received a letter in the post with an update request, therefore I am completing this form online instead to provide you with this information myself.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (118539, 'WE ARE MOVING OUT OF AREA, OUR LETTING AGENT WILL TAKE METER READING ON 19/4/2016 (OUR END OF TENANCY DATE ) AS WE WILL HAVE VACATED THE RENTED PROPERTY A FEW DAYS PRIOR.\r\nTHE AGENT IS ECKERSLEY WHITE ESTATE AGENTS , LEE ON THE SOLENT.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (118645, 'I have moved back in with my parents therefore I will not be in Portsmouth anymore. \r\n\r\nCan all corresponding bills be sent to \r\nDaphne Green-Hobbs\r\nWalberton Lodge,\r\nYapton Lane\r\nWalberton\r\nArundel\r\nWest Sussex\r\nBN180AS'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (118646, 'I have moved back in with my parents therefore I will not be in Portsmouth anymore. \r\n\r\nCan all corresponding bills be sent to \r\nDaphne Green-Hobbs\r\nWalberton Lodge,\r\nYapton Lane\r\nWalberton\r\nArundel\r\nWest Sussex\r\nBN180AS'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (118765, 'Not a leak, but the stopcock in the street co-located with the water meter is seized up and unusable.  This is causing difficulty in carrying out plumbing works and would be a serious problem in the event of a leak.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119185, 'We have reported this leak sometime ago and it has been sprayed with a mark.  Since then nothing has happened and many residents are concerned at the possibility of the road breaking up due to the constant flow of water coming up from the leak.  Also many elderly residents find the constant trickle noise of water draining disturbing their sleep.  Please can you fix  this leak urgently.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119192, 'We have reported this leak sometime ago and it has been sprayed with a mark.  Since then nothing has happened and many residents are concerned at the possibility of the road breaking up due to the constant flow of water coming up from the leak.  Also many elderly residents find the constant trickle noise of water draining disturbing their sleep.  Please can you fix  this leak urgently.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119774, 'A leak has sprung from below ground and is running like a tap at the moment. We hope it doesn\'t get worse. A local plumber has said it its Portsmouth Water\'s responsibility as its outside our boundary. If you need a local plumber who knows the property he is Mark Adams and can be reached on 07813 164808 as he is working nearby. \r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119821, 'I phoned up on 30th March 2016 to advise I would no longer be responsible for the bill as I was moving. The name I gave for the person moving in was wrong. Please amend the wrong information I have. It should be Ms G Aquilina. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119822, 'I phoned up on 30th March 2016 to advise I would no longer be responsible for the bill as I was moving. The name I gave for the person moving in was wrong. Please amend the wrong information I have. It should be Ms G Aquilina. Thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119842, 'I already call you for open our account in the new flat in Festing Road, but now I wich to close the old one in Osborne Road. Could you please send me at the festing Road address the final bill for the old one. Regards'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119861, 'I requested a meter installation recently for both properties. they has been installed as I\'ve been told in writing in your letters. unfortunately, I do not know where the meters were installed. so could you please send me someone to read the meters and show me where it was installed for the future \r\n\r\nI have sold the 19 Havelock road property. so could you please send me the final bill at the new address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (119974, 'Prevoius contract house ends on 6/04/2016, I would like to confirm if I have all the bill up to date until that date -Shared house with Fatima Luciana Torres Marinho ( costumer n.o 9384834401)\r\n\r\nMoved to new adress (new house contract-start date:14/03/2016)- Shared house with Claudia Antunes Dos Santos Alves ( costumer n.o.9427297901)'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (120315, 'Chris Jeram (my partner) has already set up the account for our new property. No further action needs to be taken with regards to 166 St Augustine Road. \r\n\r\nIf you could send me a final bill up to 9th April for Touch Wood (to Touch Wood) as my father Paul Edwards owns the property and will pass the bill on to me.\r\n\r\nIf you need any further details from me I would appreciate it if you could contact me via email at andrea.edwards@port.ac.uk.\r\n\r\nMany Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (120633, 'Please note our new address as of 15.04.16. This property is not metered.\r\nMy partner should also be named on the account as William Hammond.\r\nWe look firward to hearing from you at our new address.\r\nMany thanks\r\nLaura Broomfield'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (120653, 'It is not a gushing leak but the verge is permanently wet, sometimes with a small puddle. I think it is getting worse. There has been building at the end of the road and many goods vehicles have been trundling up and down, sometimes using my drive to turn around (The Avenue is a cut-de-sac). This my have caused/exacerbated the leak.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (120815, 'Hello,\r\n\r\nI would like to notify you that as of 07/04/2016 I will no longer live at my current address (129 Chichester Road PO2 0AQ). I am moving to London on the 08/04/2016. \r\nMy current bill is up to date with payments and I am aware that the next bill is due June 2016. \r\nWould you be able to confirm you have received this and the notification of my moving date, with any possible outstanding balance (if any) and/ or refund due back to me.\r\nThank you.\r\n\r\n\r\nWith Regards,\r\n\r\nMarina'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (121176, 'As my move in Date is the 22/04/2016 I cannot provide an initial Water meter reading of the new property until then.  Would my direct debit be amended?  Or should this be stopped and I need to re-set it for the new property?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (121236, 'I have not been in touch to register as I was unsure who was supplying the water so was waiting for a letter to confirm this. However, I have found out that our mains water is supplied by Portsmouth water from the old owners of this address.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (121580, 'I Moved to this adress at 1st April 2016, i have water in my flat but I want change the name on the contract and pay my bills. I dont know the complete name or date of birth last tenant because he is arrested beore i rent the house and i dont have any letters in my home.\r\n\r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (122303, 'I have recently received a letter about my water consumption, when I first moved in I sent you a meter reading but have had nothing since. someone has recently come out to do a meter reading but I haven\'t had any form of bill through yet. My property reference is P71787390.\r\nIf someone could respond as to what I need to do next that would be appreciated.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (122512, 'I Henryk Markiel I am Landlord of the property above . I would like to make the meter as requested by my Tenants . My phone number is as above 07928558036 my email: henryk.markiel@yahoo.com I given my contact number due to my Tenant are foreign and do not speak English. ( their phone   number if you wish verify by text message is 07459852540 please do it only if necessary.\r\nBest Regards\r\nHenryk Markiel'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (122779, 'It has come to my attention we have not relieved a water bill since moving in last November we would like a payment card to make payments monthly. \r\nKind Regards \r\nChristine Hunter \r\nAnd \r\nDaniel Carter'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (122813, 'NB:    Caravan plot (not main residence) was sold 16.3.2016 - therefore requested \'new address\' info above is not applicable.  Please address any correspondence (as previously) to me, Mr D W Seward at\r\nTrunkwell View, Beech Hill, Reading,  RG7 2AS (where we pay our water charges to Thames Water).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (122978, 'I HAVE NOW VACATED 100 NEW ROAD PENDING COMPLETION OF SALE TO  MOVE TO LIVE WITH MY GRANDDAUGHTER\'S FAMILY AT 63 CAMPBELL ROAD.  PLEASE CAN I RECEIVE A FINAL BILL FOR SETTLEMENT OF 100 NEW ROAD (PROPERTY WAS NOT METERED).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (123062, 'I bought the flat on 16th February 2016 whilst I was looking for new tenants. On 31st March new tenants started.\r\n\r\nWe have looked for the meter in the flat, but there isn\'t one.\r\n\r\nThe tenants need to be billed after  31st March, I need to be billed from 16th February to 30th March.\r\n\r\nMy home is in:\r\n10 Symonds Close\r\nChandlers Ford\r\nEastleigh\r\nHants\r\nSO53 3TP'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (123463, 'I thought this was changed over however your debt recovery manager arrived to speak to the previous owners the Hibbards about their arrears which obviously highlighted the fact that the move had not been completed. I last made a payment to you in October.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (123479, 'I thought this was changed over however your debt recovery manager arrived to speak to the previous owners the Hibbards about their arrears which obviously highlighted the fact that the move had not been completed. I last made a payment to you in October.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (124125, 'Please note that I will be leaving the country indefinitely. I do not know who will be the next tennant. \r\nThe landlord of the previous flat is Triple D Redisential Letting  (Phone 02392 349 064)\r\nPlease do not post any cheques. Please transfer any refunds to my bank account details of which will be provided upon request. Thank you. Kind regards, YSilber.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (124143, 'Customer Account Number: 94067002. \r\n\r\nDear Sirs,\r\nthank you very much for your letter.\r\n\r\nPlease register water for:\r\nDr Aleksander Krupski & Dr Katarzyna Krupski.\r\n\r\nand send us bill.\r\n\r\nKind regards,\r\nDr Aleksander Krupski'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (124433, 'Hi there , I\'m the new tenant on above premises and just want to inform you . I can\'t find the meter at the property , so I do not know my meter readings and couldn\'t provide you with them . Regards Viktor Dimitrov'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (124485, 'There appears to be a leak from a sub-surface stop cock which feed a water tap in the field.  I purchased the field some years ago and wish to establish the responsibility for the leak at the stop cock or where else I can have the supply temporarily terminated to mend the leak.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (125386, 'I would like to have a water meter installed in my flat as I currently share the water bill with the tenants who live in Flats 1, 2 & 3, and I believe my water usage is not as high as theirs. If this would be possible I\'d be really happy, thank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (125857, 'I first reported this leak in November 2015.  It was eventually attended to in January 2016, but it is now worse than ever - water bubbling up and forming a trail across the pavement a long way from the source.  Also, I notice that that the grounds man has had to cut the grass around the waterlogged ground leaving a large uncut area.  I\'ve watched it getting worse every time I walk the dog past it.  I haven\'t re-reported it before as there are 16 flats that look out on the location and I thought that at least one of them would have reported it before now. or if not the company that cut the lawn.  It does need urgent attention.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (126300, 'I am the tenant of this rented property which is managed by Abacus Lettings, 50, Felpham Road, Bognor Regis, PO22 7NZ tel. 01243 842048.  It is occupied by myself and my 13 year old son.\r\nI would like to pay by monthly direct debit on the 15th of each month and my bank details are:\r\nAccount Name: Tara Pearce.\r\nAccount Number: 92907309\r\nSort code: 09-01-28\r\nYou wrote to me 14/4/16 asking for a details update and this is my response.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (126463, 'I am moving out of rented accommodation and in to a newly purchased flat.  As there is an overlap when I will have \'one foot in each flat\' , there will be approximately 3 weeks when I will be liable to pay water charges for both premises, ie 29 April to 23 May - and thereafter only for 32a St Davids Road, Southsea.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (126884, 'I move out of flat 29b elm grove on the 24th april and don\'t move into my new place of 124 elm grove till the 11th may..\r\n\r\nI don\'t no where the meter is for flat 29b elm grove and also not sure if I have a water meter at my new address..'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (127104, 'Moving abroad on 6th of july 2016. Please produce the final bill in ONLINE form (email), as will not be in the country to receive the letter/bill in a conventional mail way. Will provide final meter reading on 6th of July 2016.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (127196, 'Letting agent Contact for 22 Grayshott Road:\r\nCosgroves\r\n49-51 Osborne Rd, Southsea PO5 3LS \r\n023 9282 7827\r\n\r\nLetting agent contact for 17 Purton Road\r\nWoodlands\r\n3 South Street, Horsham, West Sussex, RH12 1NR\r\n01403 252100'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (127373, 'Apologies. I registered at wrong address earlier today since I have been receiving letters with wrong address at my flat (in fact, my flat (which is a new build) has a post code which does not exist on many service provider\'s databases. Please ring if you wish to discuss further. Sorry for any confusion caused. David Turnbull'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (127628, 'I am told that you are the mains Sewerage provider for my property but not the mains water supplier. Can you please confirm this and also the payment procedures that we will need to set up for continued service?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (128236, 'I do not know how to read the meter and the new property isn\'t on meter ?.\r\nI am moving out on Saturday 30/04/16. I would like to know if you could send someone to read my meter please before I leave \r\nThank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (128541, 'We have had a problem with Water pressure for a few days showers not working some taps slow. We rent this property and contacted our Landlord who gave us permission to contact a plumber who came this PM. He believed it could have been the stop cock this he checked but it was fine. Unusually we have a stream that runs directly outside of the house it has been managed by gravity and a pipe running into a down pipe other than ocasionaly blocking it has not caused us any concern and has always been there. We have been in this property 8 years and had the impression that this "stream" was naturally occuring, what became apparent when the plumber turned of the mains at the top of our drive the "stream" almost stopped. This occurance gave the plumber the idea that this stream is partially caused by a leak somewhere between the top of the drive and the house which escapes via the stream. The water pressure situation in the house is slowly becoming worse the plumber stated you must be contacted to come and check the situation and we have informed our landlord.\r\nYour attention to this problem will be appreciated\r\nRegards Jo Gray'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (128747, 'Please not Mrs Rampling named above is currently in hospital (st Richards Chichester) I am her Daughter Mrs Tracy Clampitt of phone number above .\r\nMy mother is moving today from her present address to the one in Sutton. She is unable to contact you directly at this time, I will be dealing with any enquiries. Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (128925, 'In road gutter between 32 and 34 St Marys Ave.  Very close to hydrant (yellow lid).\r\n This damp/wet patch has been seen for a few years now but, it often dried up.  Since last summer, the gutter has remained damp all the time and sometimes a puddle will form.\r\n I noticed that my driveway is getting soft and if I dig down about 300mm, it is very wet.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (129443, 'We purchased the property from Mrs. Ethel Hall on April 29 2016. The previous owner\'s son informed us that they were going to contact you regarding the meter. It is currently under water. I suspect this is due to surface water run-off as the water in the tube surrounding the meter is stagnant and the is no sign of a leak on the property side of the meter as the meter flow indicator is stationary.\r\n\r\nOn another note, I understand that Portsmouth water supplies only water service to the property and that Southern Water is responsible for the sewer water. Is that correct? If so do I need to contact them or do you?\r\n\r\nPlease do not hesitate to contact me if you require further information'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (129562, 'Experiencing low water pressure for 5 days. No immediate evidence of leak within property. Assumed our boiler potentially involved but pressure is low on both hot and cold water feed.  Unsure if this is external and may be affecting other houses in near vicinity of Silverdale Drive'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (130802, 'A small leak of approximately 5-10 litres a day on the surface on the public highway, coming from under the kerbstones of a bus stop outside the flats of  the above address.\r\n\r\nTravelling west on Allaway Avenue, Paulsgrove, continue just pass the shops, and on the left hand side there is a bus shelter. Water is present on the road and you should be able to identify the leak under the raised kerbs installed as part of the bus stop.\r\n\r\nhttps://www.google.co.uk/maps/@50.8500136,-1.0962931,3a,87y,180h,72.06t/data=!3m6!1e1!3m4!1sYQ_QQ9a0uQnZX9J_WLbeVQ!2e0!7i13312!8i6656\r\n\r\nIf that helps.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (130931, 'Leaky stopcock in our drive at above address.  This was replaced some years ago, but is now leaking again.\r\n\r\n Just about to regrout block paving drive, so this needs to be rectified asap\r\n\r\nThanks very much\r\n\r\nNadine'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (130947, 'Hi from Frank Kane (Landlord)\r\n\r\n17 Fairlead Drive Gosport Hampshire PO13 9UX\r\nI took back possession of the above property on 13 April 2016 from Charlene and Andy Chapman as they had abandoned the property. They did not give a forwarding address but I was told Charlene moved to the Romsey area of Southampton.\r\nMr Simon Farrell took over the empty and unfurnished property on 21 April 2016. I entered my dob as I did not have Simon\'s.\r\nRegards Frank Kane kanefj@hotmail.com'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (131101, 'Unfortunately we can not provide water meter readings as we do not have access to the communal meter cupboard for the entire block of flats. Would it be possible to send someone to take a reading? Thanks you!'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (131335, 'We have had a plumber fit a new tap and fix a toilet this week. When he turned the water off at our stop-cock he said he could still hear running water.  Our water pressure also seems low and he\'s advised us to contact you. We await your reply...'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (131574, 'I am the owner of the house and the previous occupants were tenants.  The house is currently empty.\r\nForwarding address for outgoing tenants is:\r\n\r\nMrs. S. Wilkinson\r\n23 Burrill Avenue\r\nPortsmouth\r\nPO6 2DZ\r\n\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (131916, 'PLEASE NOTE - THIS FORM IS NOT RIGHT FOR MY USE. \r\n\r\nI HAVE SOLD THE EASTLEIGH HOUSE PROPERTY TO A DEVELOPER WITH EFFECT FROM 22 APRIL   PLS SEND FINAL BILL TO THE HAYLING ADDRESS WHICH S AN EXISTING CORRESPONDENCE ADDRESS FOR THIS SITE NOT OUR NEW MOVE LOCATION)'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (132338, 'My water meter was leaking Friday/Saturday, stopped Sunday and has been leaking slowly Monday/Tuesday. Could you please send someone to look at it. It is located on the pavement just outside the front gate. Thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (132622, 'Hi, this is to notify you that the name for the addressee for this bill needs to be changed from Mr Samuel Lee McGinley to Mrs Sarah Louise McGinley. Should you need to clarify this change with Samuel he can be contacted on 07912347615 or mcginleysamuel@gmail.com. Samuel no longer lives at this address wef 20/04/2016.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133047, 'My wife and I purchased the above property as a holiday home on the 28th March 2016 and wish to set up an account for water supply.\r\n\r\nWe will be minimal water users and as the property does not have a water meter, we are concerned that we may pay far too much for our consumption.\r\n\r\nI would be pleased to receive your advice on this matter please.\r\n\r\nPlease note our correspondence address is 7 rue de la Basse Paleine, 49260, Le Puy Notre Dame, FRANCE. Email is the best way to contact us and we would prefer not to receive post at 9 York House, as we will often not see it for extended periods. I also do not wish to receive any form of marketing material from any source.\r\n\r\nMany thanks,\r\n\r\nBill Tilley'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133215, 'I rang southern water on Friday 6 May, they told me that I did not need to contact you as it will be linked to my account with them, however our water pressure has gone on saturday 14 May and I\'m beginning to believe that I was supposed to get in contact with yourselves.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133231, 'Please use email communications as preference. I am largely unavailable 9-5, but if you leave a message on my phone I will endeavour to get back to you.\r\nI would like to have a meter fitted on either the 31st May or 1st June if possible. Also at time of fitting would it be possible to replace an aprox 2 meter lead pipe that leads from the meter to the inside of the house where it changes to copper? I am quite surprised to find the pipe coming from the mains to be lead as this is a known health hazard. I can lift paving pre-visit in the garden to enable access if required.\r\nThank you\r\nPaul Brock'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133447, 'flat1\r\n148a high street\r\nselsey\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex\r\n\r\nwest sussex'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133777, 'The above leak was reported to Thames Water on our Report a Leak webpage but this is not our Clean Water area. The customer advises: \'Leak Details - Where did you spot the leak? Street : beeding close, Town : Bognor regis, Postcode : PO22 9TS. Additional Info : outside the fence of Huchison Flooring. How bad is the leak? Flowing down street.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (133936, 'I am moving home on Thursday 19th May. I have been paying by direct debit through my partners account, Michael Edwards.\r\nWill you please create a final bill and cancel the direct debit, once this has been deducted/refunded.\r\nThank you.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (134208, 'HI,\r\nI THINK I MAY HAVE RECEIVED A LETTER FROM YOU BUT UNFORTUNATELY I HAVE MISPLACED IT.  I THINK I MAY OWE YOU MONEY HOWEVER I AM NOT SURE AS HAVE ONLY BEEN THERE SINCE FEBUARY.\r\nIF YOU COULD LET ME KNOW AND I WILL GET IT PAID ASAP IF REQUIRED.\r\nMANY THANKS,\r\nPOLLY HUGHES.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (134388, 'Please note we are the new owners of this property as from midday on 25th May , please ensure the meter is registered to us from this date and that we are not responsible for previous usage.  Confirmation and information would be appreciated. Thank you'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (134444, 'Hi. I reported the leak a while ago and it has been marked and I thought it had been repaired as it was dry the next day. however, it continues to leak. I\'m concerned as I am on a meter and not sure whether I am being charged for the leaking water. Thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (134580, 'Hello , I have moved into a new build property . The development is Bovis  Homes  which apparently we\'re going to contact you . I have had no correspondance as yet regarding a new account or bills etc . The house has a water meter .\r\nPlease could you advise me\r\n\r\nKind regards Mrs Louise Meades'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (134707, 'I am the owner of this property and it is currently tenanted with the tenancy ending on May 26th and I will be responsible for the water bill after this date. \r\n\r\nCurrently I live in the United States (5813 Crossroads Court, Waterville, OH 43566) but will be returning permanently to the UK later this year.\r\n\r\nI would like to arrange for payment of water bills by direct debit with my UK bank.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (135000, 'Please note that Mrs Dowst may have a separate account in respect of 64 Eastfield Road, PO4 9EN. \r\n\r\nMrs Dowst remains responsible for the account in respect of 64 Eastfield Road, in addition to this "new"account.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (135031, 'The existing stop Cock @ the pavement has been covered over with Tarmac, therefore would not be able to isolate in the event of leak from pavement to house, could you also Quote to install new Blue pipe from supply to house and make redundant old lead supply,'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (135165, 'We have bought Rosemary Cottage as of today, 20 May. We are moving into Rosemary Cottage on June 1st. We are still renting at Broadbridge Farmhouse until the end of June so still responsible for payments.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (135712, 'Please note meter reading was taken on 22/05/16 but we moved in on 12/05/16. The previous occupiers submitted meter readings on 11/05/16.\r\nThe costumer reference number i have submitted is the property reference number on a letter sent to Westway on 12/05/16.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (136029, 'Mrs P Buck is a retired deaf customer who cannot be reached by phone (except texts) nor does she have an her own email address.  The above email information you require has been completed by using her eldest son\'s email address Communication with Mrs Buck would be best by letter please.  There were no water meters at either of the aforementioned properties.  The previous customers of these addresses are unknown to her.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (136075, 'We got the keys to the property on 20/05/2016 but haven\'t moved in yet, it will be Saturday 28th we officially move in - I know we are responsible for the water as soon as we got the keys! It is also a new build.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (136315, 'In my front garden under the soil right by door step. Have a little flooded patch for about a week when tried to dig holes water just bubbles up. not sure if these pipes come under you or southern water and no idea how to tell. Hard to tell what the water is like as coming through mud.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (136941, 'Currently residing in London with a view to move into property no later than 27th August 2016 (purchase of house completed before my current tenancy agreement expires). Am in the property most weekends.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (136969, 'Mr Simmons is deaf therefore cannot answer his telephone.\r\nMobile phone number should only be used for text messaging purposes.\r\nIf contact is required then please contact his Housing Officer, Lynda Thomas on the e-mail address provided or telephone 023 9260 6110.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (137002, 'Dwelling has been renovated pending being rented. The previous occupant appeared not to have a supply although there is a stopcock outside at the rear of the pavement.\r\nMy builder has laid a new plastic water pipe to meet the meter at the required depth.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (137740, 'I will be moving to the new address on the 02/06/2016. Neither my current property at 56 San Diego Road or the new property at 1 Mill Cottages have water meter so to that end are unable to submit you this information.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (137845, '43a cuckoo lane                                                                                                        \r\nstubbington                                                                                                                   \r\nfareham\r\n hants'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (137850, 'We will be moving to above address and require a meter reading. on the 1st of june 2016 .I will need to open an account and will be paying by direct debit.       We will be without a land line or email when we move in for two weeks. but my land line here till midday on the 1/6/16 is 01489 602737.                    D Maslin               mobile 07701001719'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (138091, 'The property (100 Winterbourne Road) is a student rented house owned by Robert Keane. Our tenancy and contract ends on 31/05/2016 and we are all returning to our home addresses. \r\n\r\nThe property continues to be owned with new tenants due to move in soon, however, I am unsure of their names or the date they are moving in. I have provided as much information as possible.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (138483, 'Not really a leak as such but a massive waste of water. Almost on a daily basis the owner of the above property has a hose coming out of the front door into some sort of tank in a van on the road outside. It is left running until it overflows and then it can sometimes be left for hours with the water continuing to run down the road. \r\nI\'m guessing this person isn\'t on a water meter or he surely wouldn\'t be so wasteful. \r\nThe other issue is the hose draped across the pavement, sometimes when it\'s dark which is dangerous and possibly illegal.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (138868, 'Hi There \r\nI am the landlord of the property, the property will be re let once new tenants have been found. It is unfurnished. The last tenant left on the 28th May 2016. He has moved to 97 Alvington manor view, newport, P030 5NZ.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (139135, 'There is a leak next to the car parking space at the above address, the lady at number 1 will not be able to help as she is housebound. I am sure the leak is from the church next door but happens to be on our land. The leak is quite evident and easy to find.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (139265, 'Please note that on 29th July I will leave Portsmouth for permanent overseas employment in Cyprus.  The property at 8 Penny Street is owned by Portsmouth Grammar School who will take over any bills until a new employee takes up residence from 1st September 2016.  Please arrange a final meter reading on or before 29th July.  Thank you Andrew Burtt'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (139282, 'Please note that on 29th July I will leave Portsmouth for permanent overseas employment in Cyprus.  The property at 8 Penny Street is owned by Portsmouth Grammar School who will take over any bills until a new employee takes up residence from 1st September 2016.  Please arrange a final meter reading on or before 29th July.  Thank you Andrew Burtt'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (139511, 'There are no visible signs of a leak on the surface, but a camera investigation of the church\'s waste pipe before it connects to the main sewer showed the ingress of high pressure water jets.  I have the engineer\'s report and photographs showing this leak which I can email to you if you let me have a contact email.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (140229, 'Good afternoon\r\n\r\nI\'m trying to give notice that me and my partner are leaving from this flat (rented) on the 30th of June, so would like to close the account. We will be moving to another country, as so won\'t be able to give an adress to recieve the final bill. Can it be sent to my email? and the final meter? shoul i send through email as well or will one of tecnitions be able to come get the final reading? \r\n\r\nThank you\r\n\r\nBest regards \r\n\r\nLeila Santos'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (141526, 'I have filled out this form as I am about to move this coming Friday (10th).  The account number on my recent water bill is 94123089 01 (as I am moving out before the start of the billing year I will obviously not be paying for that particular bill).'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (141540, 'I have contacted Southern Water today also and set up a direct debit for my metered water charges, not too sure why as it says in your FAQ section that SW supply the means to remove waste water, and you provide the fresh supply. Please could you let me know that I have done the correct things? And will you give me an indication as to my billing amounts? I opted for 12 monthly payments and would like an estimated monthly cost. Many thanks.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (141751, 'Sorry I thought this had already been done but seems there has been confusion. I believe I have continued to pay the dd for the previous property 161 elson road as opposed to my new address 76 Gosport rd. Can you assist or transfer the monies over?\r\nContact telephone 07776991164'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (141960, 'I am moving out of my house and renting it from mid July.\r\nWe will move out on 1st July and be responsible for bills until the tenants move in.\r\nI will be going travelling but all mail can go to my parents address above.\r\n\r\nPlease call me on 07889 366728 if any more info is required.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (142129, 'Hi  I hold sold my house 13 Alver Road and am moving to Dorset.  The new owners of 13 Alver Road is Miss C Staples and Miss K Holden.  Please calculate the balance of my bill and make any adjust at the next payment.  Many thanks.\r\nRosemarie Pluckrose'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (142334, 'I move out of Lion Court on 17th June and into 86 Ravens Way on 17th June .There are NO meters at all. I hope this info is all you need in advance to set everything up . You have my details if not . Kim'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (142401, 'Water can be heard overflowing at side of the property when standing at the entrance to the SWS pumping which is adjacent to the property. Access to Two Hoots to assess the overflow may be problematic.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (142634, 'Good Morning, please note that we\'ve not moved in yet (building works underway) but we did buy the property as of 11 May 2016, and accept responsibility for payment from that point on.  Could we complete a direct debit mandate please?'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (143414, 'Previously at 8 Wolfe Close it may have been my housemate Rebecca that the bills were sent too. I am happy to have the bills sent in my name at the new property 9A South Pallant. \r\n\r\nWe were unsure as to where our old water meter was at 8 Wolfe close and are unsure of where to find our new water eter at 9A South pallant. is this something you vcould support with? We would like to settle our bill for 8 wolfe close as soon as possible'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (144193, 'We deal with this property for my father in law (Iain Lauder) he has now signed the proeprty over to my husband (Alistair Lauder) we are currently receiving the bill and paying and these details will remain the same.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (144577, 'The builder working on the property has reported a leak to the rear of the building. When he turns the supply off at the mains it stops but when turned back on can hear a flow at he rear of the building.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (144601, 'Hi \r\n\r\nYou already know about this leak, you inspected it on Monday.\r\n\r\nI just wanted to let you know it\'s leaking a lot of water now, see https://drive.google.com/file/d/0B1pZNjE7Y2T7aHN4ZDNNMmVLaE0/view\r\n\r\nI just thought I should let you know just in case.\r\n\r\nThanks,\r\n\r\nMr G Palmer'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (144870, 'I have received a bill for the the period of 1st of July- 31st of December. I am only staying in the flat up to the 28th of July. \r\nThe flat is on the market under Tenant Network, Southsea. \r\nWhat is the best way to cancel the contract in my name and pay only until the day I leave the property?\r\n\r\nMany thanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (145003, 'Outside 71 castle road there is water rising up through a small drain on the pavement.\r\n\r\nIt clearly started overnight and has subsequent flooding the pavement on that side of the road, as well as steady filling up the street.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (145090, 'CWS tank overflowing from No 36 Homer Close, rented property, tenants seem unconcerned.\r\nThe overflow exits onto the communal path in front of my property and is used by many residents daily.\r\n No 36 is flat above mine and CWS tank is shared by us both, to alleviate the nuisance to others I am having to run off hot water twice a day which is just an unavoidable waste.\r\nI assume you have landlord details on record and thought you may write to them to apply pressure to get the problem solved.\r\nWhat was an occasional drip is now becoming a constant stream as the ball valve seal breaks down.\r\nApproaches to the managing agents have yielded no results to date.\r\n\r\nThanks'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (145346, 'I am Mr Vernon Bunting and I am the Co Landlord with Mr Ross Anthony Edwards of the property 56 Tredegar Road.  I have completed this form to inform you that as of the 27th May 2016, we have successfully let the property to Miss Victoria Martin.  Could you please adjust all billing arrangements to the Tenant accordingly.  If there is any further information you require or anything else i need to do then please contact me by e-mail at vernonbunting@virginmedia.com.  Many thanks. \r\n\r\nRegards,\r\n\r\nVernon'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (145416, 'Hi. There is an extra amount of £36.99 that I paid for the previous address which was for the previous billing year (2015-2016). Can that be transferred to the new property? My account number is 93840823 01.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (146143, 'Hi,\r\nWe have taken ownership as of 17 June 2016 and would like to get set up as a customer for supply please. We are looked to pay via credit billing in the first instance.\r\n\r\nCan we have the account in joint names please? My partners name is Miss J. Bond.\r\n\r\nI\'d also like to get a meter installed so perhaps we can get this arranged soon too please.\r\n\r\nKind regards,\r\nNeil Sephton'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (146220, 'Current Address\r\n125 Locks Heath Park Rd\r\nLocks Heath\r\nSO31 6LY\r\nWe are taking over Woodside today but staying on at this address until late July where we have Southern Water as our supplier. Please initiate a new account for Woodside.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (146526, 'I am taking up residence in a nursing home in Southampton, my wife is moving from the current address to a Flat in Botley Road Southampton. Due to my ill health my wife (with the assistance of my son Mr Ian Parish) will take responsibility for the household bills. The contact phone number I have supplied is my sons, I would ask that any \'phone contact required goes through him as my wife is rather hard of hearing and struggles on the telephone. Sincerely, Peter Parish'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (147502, 'The leak I reported a few days ago is getting worse now as the puddle is becoming rather deep and large and water is now flowing down the road a steady flow. We need your engineers to come and repair the leak as water is being wasted constantly and this needs sorting.'); 
INSERT INTO `wlcj_rg_lead_detail_long` VALUES (147561, 'The site, which is under development,  is still served by a communal water meter, which is divided up by Our Enterprise Haslar.  Moving out of 3 Monckton Road wef 1 July, please cease direct debits then.  Thanks.');
#
# End of data contents of table `wlcj_rg_lead_detail_long`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_rg_lead_meta`


#
# Delete any existing table `wlcj_rg_lead_meta`
#



#
# Table structure of table `wlcj_rg_lead_meta`
#

CREATE TABLE `wlcj_rg_lead_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `form_id` mediumint unsigned NOT NULL DEFAULT '0',
  `lead_id` bigint unsigned NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`id`),
  KEY `lead_id` (`lead_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `form_id_meta_key` (`form_id`,`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ;

#
# Data contents of table `wlcj_rg_lead_meta`
#

#
# End of data contents of table `wlcj_rg_lead_meta`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_rg_lead_notes`


#
# Delete any existing table `wlcj_rg_lead_notes`
#



#
# Table structure of table `wlcj_rg_lead_notes`
#

CREATE TABLE `wlcj_rg_lead_notes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` int unsigned NOT NULL,
  `user_name` varchar(250) DEFAULT NULL,
  `user_id` bigint DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `value` longtext,
  `note_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lead_id` (`lead_id`),
  KEY `lead_user_key` (`lead_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ;

#
# Data contents of table `wlcj_rg_lead_notes`
#

#
# End of data contents of table `wlcj_rg_lead_notes`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_snp_log`


#
# Delete any existing table `wlcj_snp_log`
#



#
# Table structure of table `wlcj_snp_log`
#

CREATE TABLE `wlcj_snp_log` (
  `action_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `action` varchar(20) NOT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  `email` varchar(70) DEFAULT NULL,
  `ip` varchar(64) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `list` varchar(250) DEFAULT NULL,
  `custom_fields` text,
  `popup_id` int NOT NULL,
  `referer` varchar(255) DEFAULT NULL,
  `errors` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

#
# Data contents of table `wlcj_snp_log`
#

#
# End of data contents of table `wlcj_snp_log`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_snp_stats`


#
# Delete any existing table `wlcj_snp_stats`
#



#
# Table structure of table `wlcj_snp_stats`
#

CREATE TABLE `wlcj_snp_stats` (
  `date` date NOT NULL,
  `ID` bigint NOT NULL,
  `AB_ID` bigint NOT NULL,
  `imps` int NOT NULL,
  `convs` int NOT NULL,
  UNIQUE KEY `date_ID` (`date`,`ID`,`AB_ID`),
  KEY `ID` (`ID`),
  KEY `date` (`date`),
  KEY `AB_ID` (`AB_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

#
# Data contents of table `wlcj_snp_stats`
#
 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-19', 10505, 0, 5, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-20', 10505, 0, 18, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-23', 10505, 0, 21, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-24', 10505, 0, 13, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-25', 10505, 0, 6, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-11-27', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-03', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-07', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-08', 10505, 0, 30, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-09', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-11', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-14', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-15', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-17', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2020-12-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-06', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-08', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-10', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-12', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-13', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-15', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-18', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-19', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-20', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-23', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-27', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-01-29', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-01', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-03', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-06', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-07', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-09', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-10', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-11', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-13', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-17', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-23', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-02-25', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-09', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-10', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-11', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-12', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-16', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-17', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-18', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-25', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-26', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-03-28', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-04-06', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-04-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-04-27', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-04-29', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-04-30', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-03', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-06', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-07', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-10', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-17', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-19', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-26', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-05-27', 10505, 0, 6, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-02', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-07', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-08', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-09', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-15', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-21', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-26', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-28', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-06-30', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-03', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-15', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-16', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-27', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-07-30', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-05', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-06', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-19', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-29', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-08-31', 10505, 0, 6, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-01', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-07', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-09', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-13', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-15', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-09-30', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-10-07', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-10-08', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-10-15', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-10-20', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-10-27', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-01', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-02', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-03', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-05', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-10', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-11', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-15', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2021-11-30', 10505, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-06', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-07', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-11', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-18', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-25', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-01-28', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-07', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-10', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-13', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-15', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-16', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-21', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-02-24', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-03-08', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-03-10', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-03-15', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-03-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-04-06', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-04-12', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-04-18', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-04-29', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-05-03', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-05-09', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-05-19', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-05-23', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-06', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-07', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-10', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-17', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-20', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-22', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-06-30', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-07-01', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-07-09', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-07-12', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-07-14', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-08-01', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-08-10', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-08-12', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-08-25', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-08-27', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-04', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-08', 10505, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-11', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-21', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-25', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-09-27', 10505, 0, 4, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-10-01', 10505, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-10-31', 10505, 0, 5, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-10-31', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-03', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-04', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-06', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-07', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-08', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-10', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-13', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-14', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-16', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-18', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-21', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-24', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-25', 805, 0, 5, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-26', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-27', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-29', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-11-30', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-05', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-08', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-09', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-12', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-13', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-14', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-16', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-18', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-19', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-20', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-22', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-26', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-28', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-29', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2022-12-30', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-04', 805, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-09', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-10', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-15', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-17', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-18', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-20', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-23', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-25', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-01-29', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-02', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-07', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-08', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-09', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-10', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-12', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-14', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-18', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-19', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-20', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-21', 805, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-25', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-27', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-02-28', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-03', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-04', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-05', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-08', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-11', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-14', 805, 0, 3, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-16', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-18', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-19', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-20', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-21', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-22', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-23', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-27', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-28', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-03-31', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-04-02', 805, 0, 2, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-04-04', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-04-05', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-04-08', 805, 0, 1, 0); 
INSERT INTO `wlcj_snp_stats` VALUES ('2023-04-11', 805, 0, 1, 0);
#
# End of data contents of table `wlcj_snp_stats`
# --------------------------------------------------------

# --------------------------------------------------------
# Table: `wlcj_term_relationships`


#
# Delete any existing table `wlcj_term_relationships`
#

