INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("90","1215","1215","300","Manager","0","0","0","29","1862","-1429.21","0","0","0","0","0","0","0","2017-11-29","2017-11-30 21:43:08"),
("91","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-29","2017-11-30 23:00:35"),
("92","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-29","2017-11-30 23:00:40"),
("93","2034","1215","300","Member","35","370","-727.912","0","0","0","0","0","0","0","0","0","0","2017-11-29","2017-11-30 21:43:25"),
("94","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-29","2017-11-30 21:43:31"),
("95","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-29","2017-11-30 21:43:36"),
("100","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 03:00:31"),
("101","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 03:00:44"),
("102","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 03:00:48"),
("103","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 03:00:53"),
("149","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 03:00:31"),
("150","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 23:00:36"),
("151","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-11-30","2017-12-01 23:00:42"),
("152","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 03:00:47"),
("153","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 03:00:51"),
("154","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 03:00:55"),
("229","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 03:00:34"),
("230","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 23:00:38"),
("231","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-01","2017-12-02 23:00:43"),
("232","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 03:00:47"),
("233","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 03:00:52"),
("234","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 03:00:56"),
("341","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 03:00:26"),
("342","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 23:00:30"),
("343","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-02","2017-12-03 23:00:35"),
("344","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 03:00:39"),
("345","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 03:00:43"),
("346","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 03:00:47"),
("461","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 03:00:29"),
("462","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 23:00:34"),
("463","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-03","2017-12-04 23:00:39"),
("464","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 03:00:43"),
("465","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 03:00:47"),
("466","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 03:00:51"),
("568","1215","1215","300","Manager","0","0","0","8","918","-3487","0","0","0","0","0","0","0","2017-12-05","2017-12-06 03:00:30"),
("569","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 23:00:35"),
("570","2032","1215","300","Member","115","5746","-259.123","0","0","0","0","0","0","0","0","0","0","2017-12-04","2017-12-05 23:00:40"),
("571","2034","1215","300","Member","8","8084","-3396.43","0","0","0","0","0","0","0","0","0","0","2017-12-05","2017-12-06 03:00:45"),
("572","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-05","2017-12-06 03:00:50"),
("573","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-05","2017-12-06 03:00:55"),
("656","1215","1215","300","Manager","0","0","0","15","1848","-1777.64","0","0","0","0","1","0","0","2017-12-06","2017-12-07 03:00:34"),
("657","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-05","2017-12-06 23:00:40"),
("658","2032","1215","300","Member","102","4122","-321.822","0","0","0","0","0","0","0","0","0","0","2017-12-05","2017-12-06 23:00:45"),
("659","2034","1215","300","Member","15","7269","-1895.71","0","0","0","0","0","0","0","0","0","0","2017-12-06","2017-12-07 03:00:50"),
("660","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-06","2017-12-07 03:00:54"),
("661","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2017-12-06","2017-12-07 03:00:59"),
("744","1215","1215","300","Manager","0","0","0","13","1971","-1732.5","0","0","0","0","0","0","0","2017-12-07","2017-12-08 03:00:36"),
("745","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2017-12-06","2017-12-07 23:00:41"),
("746","2032","1215","300","Member","112","4779","-238.55","0","0","0","0","0","0","0","1","0","0","2017-12-06","2017-12-07 23:00:46"),
("747","2034","1215","300","Member","10","974","-2544.11","0","0","0","0","0","0","0","0","0","0","2017-12-07","2017-12-08 03:00:51"),
("748","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-07","2017-12-08 03:00:56"),
("749","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-07","2017-12-08 03:01:01"),
("799","1215","1215","300","Manager","0","0","0","11","893","-1932.7","0","0","0","0","0","0","0","2017-12-08","2017-12-09 03:00:41"),
("800","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-07","2017-12-08 23:00:46"),
("801","2032","1215","300","Member","127","4739","-208.96","0","0","0","0","0","0","0","0","0","0","2017-12-07","2017-12-08 23:00:51"),
("802","2034","1215","300","Member","18","4738","-1359.71","0","0","0","0","0","0","0","0","0","0","2017-12-08","2017-12-09 03:00:56"),
("803","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-08","2017-12-09 03:01:01"),
("804","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-08","2017-12-09 03:01:06"),
("833","1215","1215","300","Manager","0","0","0","11","944","-3523.2","0","0","0","0","0","0","0","2017-12-09","2017-12-10 03:00:36"),
("834","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-08","2017-12-09 23:00:41"),
("835","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-08","2017-12-09 23:00:46"),
("836","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-09","2017-12-10 03:00:51"),
("837","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-09","2017-12-10 03:00:56"),
("838","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-09","2017-12-10 03:01:01"),
("914","1215","1215","300","Manager","0","0","0","1","30","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 03:00:29"),
("915","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-09","2017-12-10 23:00:34"),
("916","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-09","2017-12-10 23:00:39"),
("917","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 03:00:44"),
("918","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 03:00:49"),
("919","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 03:00:54"),
("1027","1215","1215","300","Manager","0","0","0","12","1024","-760.455","0","0","0","0","0","0","0","2017-12-11","2017-12-12 03:01:36"),
("1028","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 23:01:41"),
("1029","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-10","2017-12-11 23:01:46"),
("1030","2034","1215","300","Member","5","2289","-2501.75","0","0","0","0","0","0","0","0","0","0","2017-12-11","2017-12-12 03:01:51"),
("1031","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-11","2017-12-12 03:01:55"),
("1032","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-11","2017-12-12 03:02:00"),
("1131","1215","1215","300","Manager","0","0","0","29","3621","-365.464","0","0","0","0","0","0","0","2017-12-12","2017-12-13 03:01:35"),
("1132","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-11","2017-12-12 23:01:39"),
("1133","2032","1215","300","Member","123","5475","-206.639","0","0","0","0","0","0","0","0","0","0","2017-12-11","2017-12-12 23:01:44"),
("1134","2034","1215","300","Member","18","535","-1062.53","0","0","0","0","0","0","0","0","0","0","2017-12-12","2017-12-13 03:01:49"),
("1135","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-12","2017-12-13 03:01:54"),
("1136","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-12","2017-12-13 03:01:59"),
("1267","1215","1215","300","Manager","0","0","0","10","1511","-72.8889","0","0","0","0","0","0","0","2017-12-13","2017-12-14 03:01:38"),
("1268","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-12","2017-12-13 23:01:43"),
("1269","2032","1215","300","Member","87","3870","-245.314","0","0","0","0","0","0","0","0","0","0","2017-12-12","2017-12-13 23:01:48"),
("1270","2034","1215","300","Member","3","21","-1163.5","0","0","0","0","0","0","0","0","0","0","2017-12-13","2017-12-14 03:01:53"),
("1271","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-13","2017-12-14 03:01:57"),
("1272","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-13","2017-12-14 03:02:02"),
("1352","1215","1215","300","Manager","0","0","0","9","388","-4077.5","0","0","0","0","0","0","0","2017-12-14","2017-12-15 03:01:47"),
("1353","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-13","2017-12-14 23:01:52"),
("1354","2032","1215","300","Member","124","6319","-178.114","0","0","0","0","0","0","0","0","0","0","2017-12-13","2017-12-14 23:01:56"),
("1355","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-14","2017-12-15 03:02:01"),
("1356","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-14","2017-12-15 03:02:06"),
("1357","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-14","2017-12-15 03:02:11"),
("1452","1215","1215","300","Manager","0","0","0","19","1592","-1805.61","0","0","0","0","0","0","0","2017-12-15","2017-12-16 03:01:41"),
("1453","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-14","2017-12-15 23:01:46"),
("1454","2032","1215","300","Member","135","4795","-211.493","0","0","0","0","0","0","0","0","0","0","2017-12-14","2017-12-15 23:01:50"),
("1455","2034","1215","300","Member","2","162","-87","0","0","0","0","0","0","0","0","0","0","2017-12-15","2017-12-16 03:01:55"),
("1456","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-15","2017-12-16 03:02:00"),
("1457","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-15","2017-12-16 03:02:06"),
("1558","1215","1215","300","Manager","0","0","0","7","440","-3137","0","0","0","0","0","0","0","2017-12-16","2017-12-17 03:01:40"),
("1559","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-15","2017-12-16 23:01:44"),
("1560","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-15","2017-12-16 23:01:49"),
("1561","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-16","2017-12-17 03:01:54"),
("1562","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-16","2017-12-17 03:01:59"),
("1563","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-16","2017-12-17 03:02:04"),
("1666","1215","1215","300","Manager","0","0","0","2","56","-21719","0","0","0","0","0","0","0","2017-12-17","2017-12-18 03:01:44"),
("1667","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-16","2017-12-17 23:01:49"),
("1668","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-16","2017-12-17 23:01:54"),
("1669","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-17","2017-12-18 03:01:59"),
("1670","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-17","2017-12-18 03:02:04"),
("1671","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-17","2017-12-18 03:02:08"),
("1807","1215","1215","300","Manager","0","0","0","34","3950","-1001.06","0","0","0","0","0","0","0","2017-12-18","2017-12-19 03:01:37"),
("1808","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-17","2017-12-18 23:01:42"),
("1809","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-17","2017-12-18 23:01:46"),
("1810","2034","1215","300","Member","5","59","-5583.75","0","0","0","0","0","0","0","0","0","0","2017-12-18","2017-12-19 03:01:51"),
("1811","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-18","2017-12-19 03:01:56"),
("1812","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-18","2017-12-19 03:02:00"),
("1916","1215","1215","300","Manager","0","0","0","13","1602","-2688.33","0","0","0","0","0","0","0","2017-12-19","2017-12-20 03:01:37"),
("1917","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-18","2017-12-19 23:01:42"),
("1918","2032","1215","300","Member","93","4025","-298.076","0","0","0","0","0","0","0","0","0","0","2017-12-18","2017-12-19 23:01:47"),
("1919","2034","1215","300","Member","9","365","-1205.88","0","0","0","0","0","0","0","0","0","0","2017-12-19","2017-12-20 03:01:52"),
("1920","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-19","2017-12-20 03:01:56"),
("1921","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-19","2017-12-20 03:02:01"),
("2035","1215","1215","300","Manager","0","0","0","31","3411","-1125.67","0","0","0","0","0","0","0","2017-12-20","2017-12-21 03:01:38"),
("2036","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-19","2017-12-20 23:01:43"),
("2037","2032","1215","300","Member","95","5388","-216.66","0","0","0","0","0","0","0","0","0","0","2017-12-19","2017-12-20 23:01:48"),
("2038","2034","1215","300","Member","4","3209","-4609.33","0","0","0","0","0","0","0","0","0","0","2017-12-20","2017-12-21 03:01:53"),
("2039","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-20","2017-12-21 03:01:57"),
("2040","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-20","2017-12-21 03:02:02"),
("2127","1215","1215","300","Manager","0","0","0","35","3023","-1121.29","0","0","0","0","0","0","0","2017-12-21","2017-12-22 03:01:38"),
("2128","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-20","2017-12-21 23:01:42"),
("2129","2032","1215","300","Member","107","5479","-195.292","0","0","0","0","0","0","0","0","0","0","2017-12-20","2017-12-21 23:01:47"),
("2130","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-21","2017-12-22 03:01:52"),
("2131","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-21","2017-12-22 03:01:56"),
("2132","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-21","2017-12-22 03:02:01"),
("2237","1215","1215","300","Manager","0","0","0","23","2105","-1655.95","0","0","0","0","0","0","0","2017-12-22","2017-12-23 03:01:44"),
("2238","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-21","2017-12-22 23:01:49"),
("2239","2032","1215","300","Member","164","5191","-151.638","0","0","0","0","0","0","0","0","0","0","2017-12-21","2017-12-22 23:01:54"),
("2240","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-22","2017-12-23 03:01:58"),
("2241","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-22","2017-12-23 03:02:03"),
("2242","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-22","2017-12-23 03:02:08"),
("2354","1215","1215","300","Manager","0","0","0","3","216","-2819.5","0","0","0","0","0","0","0","2017-12-23","2017-12-24 03:01:44"),
("2355","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-22","2017-12-23 23:01:49"),
("2356","2032","1215","300","Member","43","1513","-174.738","0","0","0","0","0","0","0","0","0","0","2017-12-22","2017-12-23 23:01:54"),
("2357","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-23","2017-12-24 03:01:58"),
("2358","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-23","2017-12-24 03:02:03"),
("2359","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-23","2017-12-24 03:02:08"),
("2471","1215","1215","300","Manager","0","0","0","1","42","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 03:01:43"),
("2472","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-23","2017-12-24 23:01:48");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("2473","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-23","2017-12-24 23:01:53"),
("2474","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 03:01:57"),
("2475","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 03:02:02"),
("2476","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 03:02:07"),
("2588","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 03:01:43"),
("2589","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 23:01:48"),
("2590","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-24","2017-12-25 23:01:52"),
("2591","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 03:01:57"),
("2592","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 03:02:02"),
("2593","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 03:02:07"),
("2705","1215","1215","300","Manager","0","0","0","9","1077","-1544","0","0","0","0","0","0","0","2017-12-26","2017-12-27 03:01:46"),
("2706","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 23:01:50"),
("2707","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-25","2017-12-26 23:01:55"),
("2708","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-26","2017-12-27 03:02:00"),
("2709","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-26","2017-12-27 03:02:05"),
("2710","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-26","2017-12-27 03:02:10"),
("2854","1215","1215","300","Manager","0","0","0","23","1776","-1542.82","0","0","0","0","0","0","0","2017-12-27","2017-12-28 03:01:40"),
("2855","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-26","2017-12-27 23:01:45"),
("2856","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-26","2017-12-27 23:01:50"),
("2857","2034","1215","300","Member","8","542","-3334.14","0","0","0","0","0","0","0","0","0","0","2017-12-27","2017-12-28 03:01:54"),
("2858","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-27","2017-12-28 03:01:59"),
("2859","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-27","2017-12-28 03:02:04"),
("2973","1215","1215","300","Manager","0","0","0","15","2385","-2019.57","0","0","0","0","0","0","0","2017-12-28","2017-12-29 03:01:41"),
("2974","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-27","2017-12-28 23:01:46"),
("2975","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-27","2017-12-28 23:01:50"),
("2976","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-28","2017-12-29 03:01:55"),
("2977","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-28","2017-12-29 03:02:00"),
("2978","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-28","2017-12-29 03:02:05"),
("3085","1215","1215","300","Manager","0","0","0","12","1123","-2513.91","0","0","0","0","0","0","0","2017-12-29","2017-12-30 03:01:45"),
("3086","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-28","2017-12-29 23:01:50"),
("3087","2032","1215","300","Member","122","4625","-160.256","0","0","0","0","0","0","0","0","0","0","2017-12-28","2017-12-29 23:01:55"),
("3088","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-29","2017-12-30 03:01:59"),
("3089","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-29","2017-12-30 03:02:04"),
("3090","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-29","2017-12-30 03:02:09"),
("3165","1215","1215","300","Manager","0","0","0","7","660","-4438.67","0","0","0","0","0","0","0","2017-12-30","2017-12-31 03:01:40"),
("3166","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-29","2017-12-30 23:01:45"),
("3167","2032","1215","300","Member","106","4252","-240.352","0","0","0","0","0","0","0","0","0","0","2017-12-29","2017-12-30 23:01:49"),
("3168","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-30","2017-12-31 03:01:54"),
("3169","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-30","2017-12-31 03:01:59"),
("3170","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-30","2017-12-31 03:02:04"),
("3270","1215","1215","300","Manager","0","0","0","1","46","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 03:01:37"),
("3271","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-30","2017-12-31 23:01:42"),
("3272","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-30","2017-12-31 23:01:47"),
("3273","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 03:01:51"),
("3274","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 03:01:56"),
("3275","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 03:02:01"),
("3417","1215","1215","300","Manager","0","0","0","1","54","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 03:01:44"),
("3418","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 23:01:49"),
("3419","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2017-12-31","2018-01-01 23:01:54"),
("3420","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 03:01:58"),
("3421","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 03:02:03"),
("3422","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 03:02:08"),
("3506","1215","1215","300","Manager","0","0","0","27","3463","-1313.92","0","0","0","0","0","0","0","2018-01-02","2018-01-03 03:01:42"),
("3507","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 23:01:47"),
("3508","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-01","2018-01-02 23:01:52"),
("3509","2034","1215","300","Member","37","900","-776.722","0","0","0","0","0","0","0","0","0","0","2018-01-02","2018-01-03 03:01:56"),
("3510","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-02","2018-01-03 03:02:01"),
("3511","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-02","2018-01-03 03:02:06"),
("3608","1215","1215","300","Manager","0","0","0","19","1421","-1885.83","0","0","0","0","0","0","0","2018-01-03","2018-01-04 03:01:50"),
("3609","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-02","2018-01-03 23:01:54"),
("3610","2032","1215","300","Member","82","3772","-258.753","0","0","0","0","0","0","0","0","0","0","2018-01-02","2018-01-03 23:01:59"),
("3611","2034","1215","300","Member","2","79","-4947","0","0","0","0","0","0","0","0","0","0","2018-01-03","2018-01-04 03:02:04"),
("3612","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-03","2018-01-04 03:02:10"),
("3613","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-03","2018-01-04 03:02:15"),
("3723","1215","1215","300","Manager","0","0","0","20","1834","-1174.05","0","0","0","0","0","0","0","2018-01-04","2018-01-05 03:01:43"),
("3724","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-03","2018-01-04 23:01:48"),
("3725","2032","1215","300","Member","111","4127","-189","0","0","0","0","0","0","0","0","0","0","2018-01-03","2018-01-04 23:01:53"),
("3726","2034","1215","300","Member","45","541","-704.727","0","0","0","0","0","0","0","0","0","0","2018-01-04","2018-01-05 03:01:58"),
("3727","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-04","2018-01-05 03:02:03"),
("3728","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-04","2018-01-05 03:02:08"),
("3836","1215","1215","300","Manager","0","0","0","16","2959","-661.467","0","0","0","0","0","0","0","2018-01-05","2018-01-06 03:01:45"),
("3837","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-04","2018-01-05 23:01:50"),
("3838","2032","1215","300","Member","111","7224","-239.427","0","0","0","0","0","0","0","0","0","0","2018-01-04","2018-01-05 23:01:55"),
("3839","2034","1215","300","Member","39","230","-134.079","0","0","0","0","0","0","0","0","0","0","2018-01-05","2018-01-06 03:02:00"),
("3840","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-05","2018-01-06 03:02:04"),
("3841","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-05","2018-01-06 03:02:09"),
("3951","1215","1215","300","Manager","0","0","0","6","726","-4686.8","0","0","0","0","0","0","0","2018-01-06","2018-01-07 03:01:45"),
("3952","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-05","2018-01-06 23:01:50"),
("3953","2032","1215","300","Member","105","3380","-268.327","0","0","0","0","0","0","0","0","0","0","2018-01-05","2018-01-06 23:01:55"),
("3954","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-06","2018-01-07 03:02:00"),
("3955","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-06","2018-01-07 03:02:05"),
("3956","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-06","2018-01-07 03:02:10"),
("4070","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 03:01:41"),
("4071","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-06","2018-01-07 23:01:46"),
("4072","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-06","2018-01-07 23:01:50"),
("4073","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 03:01:55"),
("4074","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 03:02:00"),
("4075","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 03:02:05"),
("4189","1215","1215","300","Manager","0","0","0","20","1682","-688.737","0","0","0","0","0","0","0","2018-01-08","2018-01-09 03:01:46"),
("4190","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 23:01:51"),
("4191","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-07","2018-01-08 23:01:56"),
("4192","2034","1215","300","Member","44","3196","-703.093","0","0","0","0","0","0","0","0","0","0","2018-01-08","2018-01-09 03:02:01"),
("4193","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-08","2018-01-09 03:02:06"),
("4194","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-08","2018-01-09 03:02:10"),
("4308","1215","1215","300","Manager","0","0","0","31","2214","-206.2","0","0","0","0","1","0","0","2018-01-09","2018-01-10 03:01:45"),
("4309","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-08","2018-01-09 23:01:50"),
("4310","2032","1215","300","Member","112","2835","-195.748","0","0","0","0","0","0","0","0","0","0","2018-01-08","2018-01-09 23:01:55"),
("4311","2034","1215","300","Member","31","166","-826.6","0","0","0","0","0","0","0","0","0","0","2018-01-09","2018-01-10 03:02:01"),
("4312","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-09","2018-01-10 03:02:06"),
("4313","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-01-09","2018-01-10 03:02:11"),
("4433","1215","1215","300","Manager","0","0","0","14","896","-2048.15","0","0","0","0","1","0","0","2018-01-10","2018-01-11 03:01:53"),
("4434","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-01-09","2018-01-10 23:01:57"),
("4435","2032","1215","300","Member","49","2083","-208.375","0","0","0","0","0","0","0","1","0","0","2018-01-09","2018-01-10 23:02:02"),
("4436","2034","1215","300","Member","29","927","-588.286","0","0","0","0","0","0","0","0","0","0","2018-01-10","2018-01-11 03:02:07"),
("4437","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-10","2018-01-11 03:02:12"),
("4438","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-10","2018-01-11 03:02:17"),
("4566","1215","1215","300","Manager","0","0","0","22","2887","-125.476","0","0","0","0","0","0","0","2018-01-11","2018-01-12 03:02:37"),
("4567","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-10","2018-01-11 23:02:42"),
("4568","2032","1215","300","Member","104","4557","-218.35","0","0","0","0","0","0","0","1","0","0","2018-01-10","2018-01-11 23:02:47"),
("4569","2034","1215","300","Member","28","71","-82.3704","0","0","0","0","0","0","0","0","0","0","2018-01-11","2018-01-12 03:02:52"),
("4570","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-11","2018-01-12 03:02:56"),
("4571","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-11","2018-01-12 03:03:01"),
("4696","1215","1215","300","Manager","0","0","0","10","1033","-1570.22","0","0","0","0","0","0","0","2018-01-12","2018-01-13 03:02:31"),
("4697","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-11","2018-01-12 23:02:36"),
("4698","2032","1215","300","Member","104","4371","-220.223","0","0","0","0","0","0","0","0","0","0","2018-01-11","2018-01-12 23:02:40"),
("4699","2034","1215","300","Member","14","2745","-1339.08","0","0","0","0","0","0","0","0","0","0","2018-01-12","2018-01-13 03:02:45"),
("4700","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-12","2018-01-13 03:02:50"),
("4701","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-12","2018-01-13 03:02:55"),
("4826","1215","1215","300","Manager","0","0","0","6","568","-3303.4","0","0","0","0","0","0","0","2018-01-13","2018-01-14 03:02:33"),
("4827","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-12","2018-01-13 23:02:38"),
("4828","2032","1215","300","Member","62","3209","-234.328","0","0","0","0","0","0","0","0","0","0","2018-01-12","2018-01-13 23:02:43"),
("4829","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-13","2018-01-14 03:02:48"),
("4830","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-13","2018-01-14 03:02:53"),
("4831","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-13","2018-01-14 03:02:58"),
("4956","1215","1215","300","Manager","0","0","0","1","22","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 03:02:32"),
("4957","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-13","2018-01-14 23:02:37"),
("4958","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-13","2018-01-14 23:02:41"),
("4959","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 03:02:46"),
("4960","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 03:02:51"),
("4961","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 03:02:56"),
("5123","1215","1215","300","Manager","0","0","0","15","1227","-562.429","0","0","0","0","0","0","0","2018-01-15","2018-01-16 03:02:35"),
("5124","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 23:02:40"),
("5125","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-14","2018-01-15 23:02:45"),
("5126","2034","1215","300","Member","30","876","-765.103","0","0","0","0","0","0","0","0","0","0","2018-01-15","2018-01-16 03:02:50"),
("5127","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-15","2018-01-16 03:02:55"),
("5128","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-15","2018-01-16 03:03:00"),
("5269","1215","1215","300","Manager","0","0","0","21","2180","-1521.75","0","0","0","0","0","0","0","2018-01-16","2018-01-17 03:02:30"),
("5270","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-15","2018-01-16 23:02:35"),
("5271","2032","1215","300","Member","70","3883","-280.594","0","0","0","0","0","0","0","0","0","0","2018-01-15","2018-01-16 23:02:40"),
("5272","2034","1215","300","Member","33","2912","-884.375","0","0","0","0","0","0","0","0","0","0","2018-01-16","2018-01-17 03:02:44"),
("5273","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-16","2018-01-17 03:02:49"),
("5274","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-16","2018-01-17 03:02:54"),
("5379","1215","1215","300","Manager","0","0","0","32","3424","-969.129","0","0","0","0","0","0","0","2018-01-17","2018-01-18 03:02:32"),
("5380","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-16","2018-01-17 23:02:37"),
("5381","2032","1215","300","Member","132","7964","-222.908","0","0","0","0","0","0","0","0","0","0","2018-01-16","2018-01-17 23:02:42"),
("5382","2034","1215","300","Member","36","6063","-750.971","0","0","0","0","0","0","0","0","0","0","2018-01-17","2018-01-18 03:02:47"),
("5383","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-17","2018-01-18 03:02:52"),
("5384","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-17","2018-01-18 03:02:56"),
("5528","1215","1215","300","Manager","0","0","0","30","4201","-1103.34","0","0","0","0","0","0","0","2018-01-18","2018-01-19 03:02:38");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("5529","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-17","2018-01-18 23:02:43"),
("5530","2032","1215","300","Member","105","5408","-206.548","0","0","0","0","0","0","0","0","0","0","2018-01-17","2018-01-18 23:02:47"),
("5531","2034","1215","300","Member","37","816","-591.417","0","0","0","0","0","0","0","0","0","0","2018-01-18","2018-01-19 03:02:52"),
("5532","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-18","2018-01-19 03:02:57"),
("5533","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-18","2018-01-19 03:03:02"),
("5689","1215","1215","300","Manager","0","0","0","29","2617","-1100.93","0","0","0","0","0","0","0","2018-01-19","2018-01-20 03:02:37"),
("5690","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-18","2018-01-19 23:02:42"),
("5691","2032","1215","300","Member","100","4780","-250.384","0","0","0","0","0","0","0","0","0","0","2018-01-18","2018-01-19 23:02:47"),
("5692","2034","1215","300","Member","6","2355","-3954","0","0","0","0","0","0","0","0","0","0","2018-01-19","2018-01-20 03:02:52"),
("5693","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-19","2018-01-20 03:02:57"),
("5694","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-19","2018-01-20 03:03:02"),
("5805","1215","1215","300","Manager","0","0","0","28","1287","-1833.15","0","0","0","0","0","0","0","2018-01-20","2018-01-21 03:02:46"),
("5806","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-19","2018-01-20 23:02:51"),
("5807","2032","1215","300","Member","63","3321","-243.984","0","0","0","0","0","0","0","0","0","0","2018-01-19","2018-01-20 23:02:56"),
("5808","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-20","2018-01-21 03:03:01"),
("5809","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-20","2018-01-21 03:03:06"),
("5810","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-20","2018-01-21 03:03:11"),
("5940","1215","1215","300","Manager","0","0","0","2","72","-1936","0","0","0","0","0","0","0","2018-01-21","2018-01-22 03:02:35"),
("5941","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-20","2018-01-21 23:02:40"),
("5942","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-20","2018-01-21 23:02:45"),
("5943","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-21","2018-01-22 03:02:50"),
("5944","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-21","2018-01-22 03:02:55"),
("5945","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-21","2018-01-22 03:03:00"),
("6126","1215","1215","300","Manager","0","0","0","31","2108","-890.667","0","0","0","0","0","0","0","2018-01-22","2018-01-23 03:02:40"),
("6127","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-21","2018-01-22 23:02:45"),
("6128","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-21","2018-01-22 23:02:50"),
("6129","2034","1215","300","Member","29","284","-17.75","0","0","0","0","0","0","0","0","0","0","2018-01-22","2018-01-23 03:02:55"),
("6130","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-22","2018-01-23 03:03:00"),
("6131","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-22","2018-01-23 03:03:05"),
("6290","1215","1215","300","Manager","0","0","0","31","2069","-552.233","0","0","0","0","0","0","0","2018-01-24","2018-01-25 03:02:33"),
("6291","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-23","2018-01-24 23:02:38"),
("6292","2032","1215","300","Member","94","4857","-324.624","0","0","0","0","0","0","0","0","0","0","2018-01-23","2018-01-24 23:02:43"),
("6293","2034","1215","300","Member","1","2265","0","0","0","0","0","0","0","0","0","0","0","2018-01-24","2018-01-25 03:02:48"),
("6294","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-24","2018-01-25 03:02:53"),
("6295","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-24","2018-01-25 03:02:58"),
("6424","1215","1215","300","Manager","0","0","0","22","1100","-1350.9","0","0","0","0","0","0","0","2018-01-25","2018-01-26 03:02:43"),
("6425","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-24","2018-01-25 23:02:48"),
("6426","2032","1215","300","Member","93","4755","-280.989","0","0","0","0","0","0","0","0","0","0","2018-01-24","2018-01-25 23:02:53"),
("6427","2034","1215","300","Member","30","546","-818.966","0","0","0","0","0","0","0","0","0","0","2018-01-25","2018-01-26 03:02:58"),
("6428","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-25","2018-01-26 03:03:03"),
("6429","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-25","2018-01-26 03:03:08"),
("6545","1215","1215","300","Manager","0","0","0","16","2124","-1896.2","0","0","0","0","0","0","0","2018-01-26","2018-01-27 03:02:41"),
("6546","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-25","2018-01-26 23:02:46"),
("6547","2032","1215","300","Member","81","3293","-243.4","0","0","0","0","0","0","0","0","0","0","2018-01-25","2018-01-26 23:02:51"),
("6548","2034","1215","300","Member","13","435","-236.25","0","0","0","0","0","0","0","0","0","0","2018-01-26","2018-01-27 03:02:56"),
("6549","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-26","2018-01-27 03:03:01"),
("6550","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-26","2018-01-27 03:03:06"),
("6691","1215","1215","300","Manager","0","0","0","7","384","-5847.67","0","0","0","0","0","0","0","2018-01-27","2018-01-28 03:02:43"),
("6692","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-26","2018-01-27 23:02:48"),
("6693","2032","1215","300","Member","20","1151","-369.895","0","0","0","0","0","0","0","0","0","0","2018-01-26","2018-01-27 23:02:53"),
("6694","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-27","2018-01-28 03:02:58"),
("6695","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-27","2018-01-28 03:03:03"),
("6696","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-27","2018-01-28 03:03:08"),
("6835","1215","1215","300","Manager","0","0","0","1","70","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 03:02:38"),
("6836","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-27","2018-01-28 23:02:43"),
("6837","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-27","2018-01-28 23:02:48"),
("6838","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 03:02:53"),
("6839","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 03:02:58"),
("6840","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 03:03:03"),
("6980","1215","1215","300","Manager","0","0","0","15","785","-1801.29","0","0","0","0","0","0","0","2018-01-29","2018-01-30 03:02:38"),
("6981","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 23:02:43"),
("6982","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-28","2018-01-29 23:02:48"),
("6983","2034","1215","300","Member","26","2260","-993.76","0","0","0","0","0","0","0","0","0","0","2018-01-29","2018-01-30 03:02:53"),
("6984","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-29","2018-01-30 03:02:58"),
("6985","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-29","2018-01-30 03:03:03"),
("7137","1215","1215","300","Manager","0","0","0","15","1105","-2524.86","0","0","0","0","0","0","0","2018-01-30","2018-01-31 03:02:43"),
("7138","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-29","2018-01-30 23:02:48"),
("7139","2032","1215","300","Member","76","4483","-280.173","0","0","0","0","0","0","0","0","0","0","2018-01-29","2018-01-30 23:02:53"),
("7140","2034","1215","300","Member","18","2891","-1565.41","0","0","0","0","0","0","0","0","0","0","2018-01-30","2018-01-31 03:02:58"),
("7141","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-30","2018-01-31 03:03:03"),
("7142","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-30","2018-01-31 03:03:08"),
("7275","1215","1215","300","Manager","0","0","0","12","847","-3465.82","0","0","0","0","0","0","0","2018-01-31","2018-02-01 03:02:43"),
("7276","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-30","2018-01-31 23:02:48"),
("7277","2032","1215","300","Member","104","5872","-244.796","0","0","0","0","0","0","0","0","0","0","2018-01-30","2018-01-31 23:02:54"),
("7278","2034","1215","300","Member","7","2849","-3961.5","0","0","0","0","0","0","0","0","0","0","2018-01-31","2018-02-01 03:02:59"),
("7279","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-31","2018-02-01 03:03:04"),
("7280","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-31","2018-02-01 03:03:09"),
("7421","1215","1215","300","Manager","0","0","0","25","2782","-1376.17","0","0","0","0","0","0","0","2018-02-01","2018-02-02 03:02:43"),
("7422","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-01-31","2018-02-01 23:02:48"),
("7423","2032","1215","300","Member","80","2838","-272.595","0","0","0","0","0","0","0","0","0","0","2018-01-31","2018-02-01 23:02:53"),
("7424","2034","1215","300","Member","3","1955","-1189","0","0","0","0","0","0","0","0","0","0","2018-02-01","2018-02-02 03:02:58"),
("7425","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-01","2018-02-02 03:03:03"),
("7426","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-01","2018-02-02 03:03:08"),
("7569","1215","1215","300","Manager","0","0","0","33","3687","-1404.72","0","0","0","0","0","0","0","2018-02-02","2018-02-03 03:02:41"),
("7570","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-01","2018-02-02 23:02:46"),
("7571","2032","1215","300","Member","51","2246","-289.66","0","0","0","0","0","0","0","0","0","0","2018-02-01","2018-02-02 23:02:51"),
("7572","2034","1215","300","Member","17","5326","-1542.75","0","0","0","0","0","0","0","0","0","0","2018-02-02","2018-02-03 03:02:56"),
("7573","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-02","2018-02-03 03:03:02"),
("7574","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-02","2018-02-03 03:03:07"),
("7717","1215","1215","300","Manager","0","0","0","10","1435","-4110.56","0","0","0","0","0","0","0","2018-02-03","2018-02-04 03:02:42"),
("7718","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-02","2018-02-03 23:02:47"),
("7719","2032","1215","300","Member","33","2280","-622.156","0","0","0","0","0","0","0","0","0","0","2018-02-02","2018-02-03 23:02:52"),
("7720","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-03","2018-02-04 03:02:57"),
("7721","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-03","2018-02-04 03:03:02"),
("7722","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-03","2018-02-04 03:03:07"),
("7865","1215","1215","300","Manager","0","0","0","1","42","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 03:02:39"),
("7866","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-03","2018-02-04 23:02:44"),
("7867","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-03","2018-02-04 23:02:49"),
("7868","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 03:02:54"),
("7869","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 03:02:59"),
("7870","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 03:03:04"),
("8013","1215","1215","300","Manager","0","0","0","24","2608","-1313.43","0","0","0","0","0","0","0","2018-02-05","2018-02-06 03:02:40"),
("8014","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 23:02:46"),
("8015","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-04","2018-02-05 23:02:51"),
("8016","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-05","2018-02-06 03:02:56"),
("8017","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-05","2018-02-06 03:03:01"),
("8018","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-05","2018-02-06 03:03:06"),
("8177","1215","1215","300","Manager","0","0","0","37","2907","-1047.47","0","0","0","0","0","0","0","2018-02-06","2018-02-07 03:02:44"),
("8178","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-05","2018-02-06 23:02:49"),
("8179","2032","1215","300","Member","96","4636","-293.253","0","0","0","0","0","0","0","0","0","0","2018-02-05","2018-02-06 23:02:55"),
("8180","2034","1215","300","Member","25","3526","-1197.58","0","0","0","0","0","0","0","0","0","0","2018-02-06","2018-02-07 03:03:00"),
("8181","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-06","2018-02-07 03:03:05"),
("8182","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-06","2018-02-07 03:03:10"),
("8353","1215","1215","300","Manager","0","0","0","25","3627","-1251","0","0","0","0","0","0","0","2018-02-07","2018-02-08 03:02:41"),
("8354","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-06","2018-02-07 23:02:46"),
("8355","2032","1215","300","Member","103","4854","-216.098","0","0","0","0","0","0","0","0","0","0","2018-02-06","2018-02-07 23:02:52"),
("8356","2034","1215","300","Member","6","3024","-3779.8","0","0","0","0","0","0","0","0","0","0","2018-02-07","2018-02-08 03:02:57"),
("8357","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-07","2018-02-08 03:03:02"),
("8358","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-07","2018-02-08 03:03:07"),
("8511","1215","1215","300","Manager","0","0","0","26","2762","-1414.88","0","0","0","0","1","0","0","2018-02-08","2018-02-09 03:02:46"),
("8512","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-07","2018-02-08 23:02:51"),
("8513","2032","1215","300","Member","115","5370","-225.886","0","0","0","0","0","0","0","0","0","0","2018-02-07","2018-02-08 23:02:56"),
("8514","2034","1215","300","Member","12","6842","-2121.73","0","0","0","0","0","0","0","0","0","0","2018-02-08","2018-02-09 03:03:01"),
("8515","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-08","2018-02-09 03:03:07"),
("8516","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-08","2018-02-09 03:03:12"),
("8659","1215","1215","300","Manager","0","0","0","17","1691","-2127","0","0","0","0","0","0","0","2018-02-09","2018-02-10 03:02:54"),
("8660","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-08","2018-02-09 23:02:59"),
("8661","2032","1215","300","Member","89","4437","-277.239","0","0","0","0","0","0","0","1","0","0","2018-02-08","2018-02-09 23:03:04"),
("8662","2034","1215","300","Member","6","67","-3695","0","0","0","0","0","0","0","0","0","0","2018-02-09","2018-02-10 03:03:10"),
("8663","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-09","2018-02-10 03:03:15"),
("8664","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-09","2018-02-10 03:03:20"),
("8774","1215","1215","300","Manager","0","0","0","4","691","-2536.67","0","0","0","0","0","0","0","2018-02-10","2018-02-11 03:02:43"),
("8775","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-09","2018-02-10 23:02:48"),
("8776","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-09","2018-02-10 23:02:53"),
("8777","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-10","2018-02-11 03:02:59"),
("8778","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-10","2018-02-11 03:03:04"),
("8779","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-10","2018-02-11 03:03:09"),
("8901","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 03:02:42"),
("8902","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-10","2018-02-11 23:02:48"),
("8903","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-10","2018-02-11 23:02:53"),
("8904","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 03:02:58"),
("8905","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 03:03:03"),
("8906","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 03:03:08"),
("9049","1215","1215","300","Manager","0","0","0","23","1524","-1960.86","0","0","0","0","1","0","0","2018-02-12","2018-02-13 03:02:44"),
("9050","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 23:02:50"),
("9051","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-11","2018-02-12 23:02:55"),
("9052","2034","1215","300","Member","14","2688","-1914.08","0","0","0","0","0","0","0","1","0","0","2018-02-12","2018-02-13 03:03:00"),
("9053","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-12","2018-02-13 03:03:05"),
("9054","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-12","2018-02-13 03:03:10");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("9231","1215","1215","300","Manager","0","0","0","23","2170","-2478","0","0","0","0","0","0","0","2018-02-13","2018-02-14 03:02:42"),
("9232","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-12","2018-02-13 23:02:47"),
("9233","2032","1215","300","Member","77","3755","-343.987","0","0","0","0","0","0","0","1","0","0","2018-02-12","2018-02-13 23:02:53"),
("9234","2034","1215","300","Member","6","2771","-3819","0","0","0","0","0","0","0","0","0","0","2018-02-13","2018-02-14 03:02:58"),
("9235","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-13","2018-02-14 03:03:03"),
("9236","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-13","2018-02-14 03:03:08"),
("9402","1215","1215","300","Manager","0","0","0","18","1915","-2315.41","0","0","0","0","0","0","0","2018-02-14","2018-02-15 03:03:18"),
("9403","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-13","2018-02-14 23:03:23"),
("9404","2032","1215","300","Member","103","4684","-212.578","0","0","0","0","0","0","0","0","0","0","2018-02-13","2018-02-14 23:03:29"),
("9405","2034","1215","300","Member","8","64","-2262.71","0","0","0","0","0","0","0","0","0","0","2018-02-14","2018-02-15 03:03:34"),
("9406","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-14","2018-02-15 03:03:39"),
("9407","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-14","2018-02-15 03:03:44"),
("9521","1215","1215","300","Manager","0","0","0","18","1749","-2259.65","0","0","0","0","0","0","0","2018-02-15","2018-02-16 03:03:17"),
("9522","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-14","2018-02-15 23:03:23"),
("9523","2032","1215","300","Member","101","4183","-193.64","0","0","0","0","0","0","0","0","0","0","2018-02-14","2018-02-15 23:03:28"),
("9524","2034","1215","300","Member","1","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-15","2018-02-16 03:03:33"),
("9525","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-15","2018-02-16 03:03:38"),
("9526","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-15","2018-02-16 03:03:44"),
("9651","1215","1215","300","Manager","0","0","0","12","2238","-3475.91","0","0","0","0","0","0","0","2018-02-16","2018-02-17 03:02:39"),
("9652","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-15","2018-02-16 23:02:44"),
("9653","2032","1215","300","Member","110","4831","-252.844","0","0","0","0","0","0","0","0","0","0","2018-02-15","2018-02-16 23:02:49"),
("9654","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-16","2018-02-17 03:02:54"),
("9655","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-16","2018-02-17 03:03:00"),
("9656","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-16","2018-02-17 03:03:05"),
("9804","1215","1215","300","Manager","0","0","0","5","302","-3020.5","0","0","0","0","0","0","0","2018-02-17","2018-02-18 03:02:47"),
("9805","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-16","2018-02-17 23:02:52"),
("9806","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-16","2018-02-17 23:02:57"),
("9807","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-17","2018-02-18 03:03:02"),
("9808","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-17","2018-02-18 03:03:08"),
("9809","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-17","2018-02-18 03:03:13"),
("9956","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 03:02:44"),
("9957","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-17","2018-02-18 23:02:49"),
("9958","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-17","2018-02-18 23:02:54"),
("9959","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 03:02:59"),
("9960","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 03:03:05"),
("9961","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 03:03:10"),
("10115","1215","1215","300","Manager","0","0","0","25","1349","-1858.46","0","0","0","0","0","0","0","2018-02-19","2018-02-20 03:02:37"),
("10116","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 23:02:43"),
("10117","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-18","2018-02-19 23:02:48"),
("10118","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-19","2018-02-20 03:02:53"),
("10119","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-19","2018-02-20 03:02:58"),
("10120","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-19","2018-02-20 03:03:04"),
("10298","1215","1215","300","Manager","0","0","0","21","2631","-1461.7","0","0","0","0","0","0","0","2018-02-20","2018-02-21 03:02:39"),
("10299","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-19","2018-02-20 23:02:44"),
("10300","2032","1215","300","Member","98","3082","-251.701","0","0","0","0","0","0","0","0","0","0","2018-02-19","2018-02-20 23:02:49"),
("10301","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-20","2018-02-21 03:02:54"),
("10302","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-20","2018-02-21 03:03:00"),
("10303","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-20","2018-02-21 03:03:05"),
("10476","1215","1215","300","Manager","0","0","0","27","4122","-1376.69","0","0","0","0","1","0","0","2018-02-21","2018-02-22 03:02:45"),
("10477","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-20","2018-02-21 23:02:50"),
("10478","2032","1215","300","Member","81","3029","-230.712","0","0","0","0","0","0","0","0","0","0","2018-02-20","2018-02-21 23:02:55"),
("10479","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-21","2018-02-22 03:03:00"),
("10480","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-21","2018-02-22 03:03:06"),
("10481","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-21","2018-02-22 03:03:11"),
("10586","1215","1215","300","Manager","0","0","0","14","1345","-2706.31","0","0","0","0","0","0","0","2018-02-22","2018-02-23 03:01:54"),
("10587","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-21","2018-02-22 23:01:59"),
("10588","2032","1215","300","Member","110","2816","-199.78","0","0","0","0","0","0","0","1","0","0","2018-02-21","2018-02-22 23:02:04"),
("10589","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-22","2018-02-23 03:02:10"),
("10590","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-22","2018-02-23 03:02:15"),
("10591","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-22","2018-02-23 03:02:20"),
("10708","1215","1215","300","Manager","0","0","0","10","707","619.333","0","0","0","0","0","0","0","2018-02-23","2018-02-24 03:01:49"),
("10709","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-22","2018-02-23 23:01:55"),
("10710","2032","1215","300","Member","90","3027","-212.674","0","0","0","0","0","0","0","0","0","0","2018-02-22","2018-02-23 23:02:01"),
("10711","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-23","2018-02-24 03:02:06"),
("10712","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-23","2018-02-24 03:02:12"),
("10713","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-23","2018-02-24 03:02:17"),
("10853","1215","1215","300","Manager","0","0","0","7","807","-3306.33","0","0","0","0","0","0","0","2018-02-24","2018-02-25 03:01:56"),
("10854","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-23","2018-02-24 23:02:01"),
("10855","2032","1215","300","Member","27","541","-184.308","0","0","0","0","0","0","0","0","0","0","2018-02-23","2018-02-24 23:02:06"),
("10856","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-24","2018-02-25 03:02:12"),
("10857","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-24","2018-02-25 03:02:17"),
("10858","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-24","2018-02-25 03:02:25"),
("10999","1215","1215","300","Manager","0","0","0","1","53","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 03:01:52"),
("11000","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-24","2018-02-25 23:01:57"),
("11001","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-24","2018-02-25 23:02:03"),
("11002","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 03:02:10"),
("11003","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 03:02:16"),
("11004","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 03:02:21"),
("11145","1215","1215","300","Manager","0","0","0","26","2680","-1747.08","0","0","0","0","1","0","0","2018-02-26","2018-02-27 03:01:54"),
("11146","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 23:01:59"),
("11147","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-25","2018-02-26 23:02:04"),
("11148","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-26","2018-02-27 03:02:10"),
("11149","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-26","2018-02-27 03:02:15"),
("11150","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-26","2018-02-27 03:02:21"),
("11293","1215","1215","300","Manager","0","0","0","26","3899","-1468.84","0","0","0","0","1","0","0","2018-02-27","2018-02-28 03:01:53"),
("11294","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-26","2018-02-27 23:01:58"),
("11295","2032","1215","300","Member","102","3396","-225.743","0","0","0","0","0","0","0","1","0","0","2018-02-26","2018-02-27 23:02:04"),
("11296","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-27","2018-02-28 03:02:09"),
("11297","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-27","2018-02-28 03:02:15"),
("11298","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-27","2018-02-28 03:02:20"),
("11446","1215","1215","300","Manager","0","0","0","19","1791","-1972.72","0","0","0","0","1","0","0","2018-02-28","2018-03-01 03:01:54"),
("11447","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-27","2018-02-28 23:01:59"),
("11448","2032","1215","300","Member","101","4619","-255.29","0","0","0","0","0","0","0","1","0","0","2018-02-27","2018-02-28 23:02:05"),
("11449","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-28","2018-03-01 03:02:10"),
("11450","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-02-28","2018-03-01 03:02:16"),
("11451","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-28","2018-03-01 03:02:21"),
("11602","1215","1215","300","Manager","0","0","0","4","207","-1967.67","0","0","0","0","0","0","0","2018-03-01","2018-03-02 03:01:45"),
("11603","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-02-28","2018-03-01 23:01:51"),
("11604","2032","1215","300","Member","111","3845","-208.136","0","0","0","0","0","0","0","1","0","0","2018-02-28","2018-03-01 23:01:56"),
("11605","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-01","2018-03-02 03:02:01"),
("11606","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-01","2018-03-02 03:02:07"),
("11607","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-01","2018-03-02 03:02:12"),
("11744","1215","1215","300","Manager","0","0","0","17","1970","-2163.44","0","0","0","0","1","0","0","2018-03-02","2018-03-03 03:01:49"),
("11745","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-01","2018-03-02 23:01:55"),
("11746","2032","1215","300","Member","83","3523","-281.634","0","0","0","0","0","0","0","0","0","0","2018-03-01","2018-03-02 23:02:00"),
("11747","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-02","2018-03-03 03:02:06"),
("11748","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-02","2018-03-03 03:02:11"),
("11749","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-02","2018-03-03 03:02:16"),
("11893","1215","1215","300","Manager","0","0","0","4","687","-9323","0","0","0","0","0","0","0","2018-03-03","2018-03-04 03:01:48"),
("11894","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-02","2018-03-03 23:01:54"),
("11895","2032","1215","300","Member","32","1347","-367.968","0","0","0","0","0","0","0","1","0","0","2018-03-02","2018-03-03 23:01:59"),
("11896","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-03","2018-03-04 03:02:04"),
("11897","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-03","2018-03-04 03:02:09"),
("11898","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-03","2018-03-04 03:02:15"),
("12040","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 03:01:51"),
("12041","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-03","2018-03-04 23:01:56"),
("12042","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-03","2018-03-04 23:02:01"),
("12043","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 03:02:07"),
("12044","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 03:02:12"),
("12045","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 03:02:17"),
("12201","1215","1215","300","Manager","0","0","0","18","2352","-2108.47","0","0","0","0","0","0","0","2018-03-05","2018-03-06 03:01:49"),
("12202","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 23:01:54"),
("12203","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-04","2018-03-05 23:01:59"),
("12204","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-05","2018-03-06 03:02:05"),
("12205","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-05","2018-03-06 03:02:10"),
("12206","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-05","2018-03-06 03:02:15"),
("12346","1215","1215","300","Manager","0","0","0","24","2924","-1699.91","0","0","0","0","0","0","0","2018-03-06","2018-03-07 03:01:50"),
("12347","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-05","2018-03-06 23:01:55"),
("12348","2032","1215","300","Member","93","5193","-220.728","0","0","0","0","0","0","0","0","0","0","2018-03-05","2018-03-06 23:02:00"),
("12349","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-06","2018-03-07 03:02:05"),
("12350","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-06","2018-03-07 03:02:11"),
("12351","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-06","2018-03-07 03:02:16"),
("12518","1215","1215","300","Manager","0","0","0","18","1787","-1972.24","0","0","0","0","0","0","0","2018-03-07","2018-03-08 03:01:47"),
("12519","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-06","2018-03-07 23:01:52"),
("12520","2032","1215","300","Member","83","4000","-283.951","0","0","0","0","0","0","0","0","0","0","2018-03-06","2018-03-07 23:01:58"),
("12521","2034","1215","300","Member","2","313","-21102","0","0","0","0","0","0","0","0","0","0","2018-03-07","2018-03-08 03:02:03"),
("12522","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-07","2018-03-08 03:02:08"),
("12523","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-07","2018-03-08 03:02:14"),
("12857","1215","1215","300","Manager","0","0","0","9","1108","-2931.75","0","0","0","0","0","0","0","2018-03-09","2018-03-10 03:01:44"),
("12858","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-08","2018-03-09 23:01:49"),
("12859","2032","1215","300","Member","110","3703","-232.156","0","0","0","0","0","0","0","0","0","0","2018-03-08","2018-03-09 23:01:54"),
("12860","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-09","2018-03-10 03:01:59"),
("12861","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-09","2018-03-10 03:02:04"),
("12862","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-09","2018-03-10 03:02:10"),
("13022","1215","1215","300","Manager","0","0","0","4","149","-1598.33","0","0","0","0","0","0","0","2018-03-10","2018-03-11 04:01:45"),
("13023","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-09","2018-03-10 23:01:50"),
("13024","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-09","2018-03-10 23:01:55"),
("13025","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-10","2018-03-11 04:02:01"),
("13026","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-10","2018-03-11 04:02:06");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("13027","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-10","2018-03-11 04:02:12"),
("13186","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 03:01:46"),
("13187","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-10","2018-03-11 23:01:51"),
("13188","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-10","2018-03-11 23:01:57"),
("13189","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 03:02:02"),
("13190","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 03:02:07"),
("13191","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 03:02:13"),
("13370","1215","1215","300","Manager","103","2844","-194.451","15","1130","-2191","0","0","0","0","0","0","0","2018-03-12","2018-03-13 03:01:44"),
("13371","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 23:01:49"),
("13372","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-11","2018-03-12 23:01:55"),
("13373","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-12","2018-03-13 03:02:00"),
("13374","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-12","2018-03-13 03:02:05"),
("13375","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-12","2018-03-13 03:02:11"),
("13570","1215","1215","300","Manager","2","139","-809","17","2016","-2074.56","0","0","0","0","0","0","0","2018-03-13","2018-03-14 03:01:46"),
("13571","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-12","2018-03-13 23:01:51"),
("13572","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-12","2018-03-13 23:01:56"),
("13573","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-13","2018-03-14 03:02:02"),
("13574","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-13","2018-03-14 03:02:07"),
("13575","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-13","2018-03-14 03:02:12"),
("13768","1215","1215","300","Manager","102","3561","-217.446","26","2602","-1401.28","0","0","0","0","0","0","0","2018-03-14","2018-03-15 03:01:47"),
("13769","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-13","2018-03-14 23:01:53"),
("13770","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-13","2018-03-14 23:01:58"),
("13771","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-14","2018-03-15 03:02:03"),
("13772","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-14","2018-03-15 03:02:09"),
("13773","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-14","2018-03-15 03:02:14"),
("13919","1215","1215","300","Manager","100","3209","-218.293","23","3499","-1702.32","0","0","0","0","0","0","0","2018-03-15","2018-03-16 03:01:48"),
("13920","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-14","2018-03-15 23:01:54"),
("13921","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-14","2018-03-15 23:01:59"),
("13922","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-15","2018-03-16 03:02:05"),
("13923","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-15","2018-03-16 03:02:10"),
("13924","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-15","2018-03-16 03:02:15"),
("14060","1215","1215","300","Manager","0","0","0","15","1500","-1782.07","0","0","0","0","0","0","0","2018-03-16","2018-03-17 03:01:52"),
("14061","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-15","2018-03-16 23:01:58"),
("14062","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-15","2018-03-16 23:02:03"),
("14063","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-16","2018-03-17 03:02:09"),
("14064","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-16","2018-03-17 03:02:15"),
("14065","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-16","2018-03-17 03:02:20"),
("14235","1215","1215","300","Manager","0","0","0","7","672","-2168.83","0","0","0","0","0","0","0","2018-03-17","2018-03-18 03:01:50"),
("14236","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-16","2018-03-17 23:01:56"),
("14237","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-16","2018-03-17 23:02:01"),
("14238","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-17","2018-03-18 03:02:07"),
("14239","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-17","2018-03-18 03:02:12"),
("14240","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-17","2018-03-18 03:02:17"),
("14410","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 03:01:53"),
("14411","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-17","2018-03-18 23:01:58"),
("14412","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-17","2018-03-18 23:02:04"),
("14413","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 03:02:09"),
("14414","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 03:02:14"),
("14415","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 03:02:20"),
("14588","1215","1215","300","Manager","106","3484","-206.99","34","2818","-1287.33","0","0","0","0","0","0","0","2018-03-19","2018-03-20 03:01:54"),
("14589","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 23:02:00"),
("14590","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-18","2018-03-19 23:02:05"),
("14591","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-19","2018-03-20 03:02:10"),
("14592","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-19","2018-03-20 03:02:16"),
("14593","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-19","2018-03-20 03:02:21"),
("14766","1215","1215","300","Manager","104","3657","-295.456","15","1317","-2059.64","0","0","0","0","0","0","0","2018-03-20","2018-03-21 03:01:53"),
("14767","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-19","2018-03-20 23:01:58"),
("14768","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-19","2018-03-20 23:02:04"),
("14769","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-20","2018-03-21 03:02:10"),
("14770","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-20","2018-03-21 03:02:15"),
("14771","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-20","2018-03-21 03:02:21"),
("14979","1215","1215","300","Manager","110","3574","-250","31","3799","-1180.37","0","0","0","0","0","0","0","2018-03-21","2018-03-22 03:01:55"),
("14980","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-20","2018-03-21 23:02:01"),
("14981","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-20","2018-03-21 23:02:06"),
("14982","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-21","2018-03-22 03:02:12"),
("14983","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-21","2018-03-22 03:02:17"),
("14984","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-21","2018-03-22 03:02:23"),
("15145","1215","1215","300","Manager","70","2152","-349.014","28","2576","-1190.67","0","0","0","0","0","0","0","2018-03-22","2018-03-23 03:01:59"),
("15146","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-21","2018-03-22 23:02:05"),
("15147","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-21","2018-03-22 23:02:10"),
("15148","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-22","2018-03-23 03:02:16"),
("15149","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-22","2018-03-23 03:02:21"),
("15150","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-22","2018-03-23 03:02:27"),
("15300","1215","1215","300","Manager","0","0","0","17","820","-1980.94","0","0","0","0","0","0","0","2018-03-23","2018-03-24 03:01:52"),
("15301","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-22","2018-03-23 23:01:58"),
("15302","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-22","2018-03-23 23:02:04"),
("15303","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-23","2018-03-24 03:02:09"),
("15304","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-23","2018-03-24 03:02:15"),
("15305","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-23","2018-03-24 03:02:20"),
("15478","1215","1215","300","Manager","0","0","0","2","417","-5012","0","0","0","0","0","0","0","2018-03-24","2018-03-25 03:01:55"),
("15479","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-23","2018-03-24 23:02:01"),
("15480","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-23","2018-03-24 23:02:06"),
("15481","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-24","2018-03-25 03:02:12"),
("15482","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-24","2018-03-25 03:02:18"),
("15483","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-24","2018-03-25 03:02:23"),
("15656","1215","1215","300","Manager","0","0","0","1","28","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 03:01:55"),
("15657","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-24","2018-03-25 23:02:01"),
("15658","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-24","2018-03-25 23:02:06"),
("15659","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 03:02:12"),
("15660","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 03:02:17"),
("15661","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 03:02:23"),
("15838","1215","1215","300","Manager","45","1492","-383.727","19","1869","-2422.61","0","0","0","0","0","0","0","2018-03-26","2018-03-27 03:02:04"),
("15839","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 23:02:10"),
("15840","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-25","2018-03-26 23:02:16"),
("15841","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-26","2018-03-27 03:02:21"),
("15842","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-26","2018-03-27 03:02:27"),
("15843","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-26","2018-03-27 03:02:33"),
("16026","1215","1215","300","Manager","19","3232","-1046","28","3944","-982.63","0","0","0","0","0","0","0","2018-03-27","2018-03-28 03:02:09"),
("16027","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-26","2018-03-27 23:02:14"),
("16028","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-26","2018-03-27 23:02:20"),
("16029","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-27","2018-03-28 03:02:26"),
("16030","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-27","2018-03-28 03:02:31"),
("16031","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-27","2018-03-28 03:02:37"),
("16209","1215","1215","300","Manager","33","4553","-634.969","21","2556","-1133.5","0","0","0","0","0","0","0","2018-03-28","2018-03-29 03:02:10"),
("16210","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-27","2018-03-28 23:02:15"),
("16211","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-27","2018-03-28 23:02:21"),
("16212","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-28","2018-03-29 03:02:27"),
("16213","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-28","2018-03-29 03:02:33"),
("16214","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-28","2018-03-29 03:02:39"),
("16392","1215","1215","300","Manager","35","3422","-741.265","25","1847","-2659.29","0","0","0","0","0","0","0","2018-03-29","2018-03-30 03:02:06"),
("16393","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-28","2018-03-29 23:02:11"),
("16394","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-28","2018-03-29 23:02:17"),
("16395","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-29","2018-03-30 03:02:23"),
("16396","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-29","2018-03-30 03:02:29"),
("16397","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-29","2018-03-30 03:02:34"),
("16577","1215","1215","300","Manager","0","0","0","4","623","-12526.3","0","0","0","0","0","0","0","2018-03-30","2018-03-31 03:02:17"),
("16578","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-29","2018-03-30 23:02:23"),
("16579","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-29","2018-03-30 23:02:28"),
("16580","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-30","2018-03-31 03:02:34"),
("16581","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-30","2018-03-31 03:02:40"),
("16582","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-30","2018-03-31 03:02:46"),
("16762","1215","1215","300","Manager","0","0","0","18","471","-1455.59","0","0","0","0","0","0","0","2018-03-31","2018-04-01 03:02:12"),
("16763","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-30","2018-03-31 23:02:18"),
("16764","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-30","2018-03-31 23:02:24"),
("16765","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-31","2018-04-01 03:02:29"),
("16766","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-31","2018-04-01 03:02:35"),
("16767","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-31","2018-04-01 03:02:41"),
("16947","1215","1215","300","Manager","0","0","0","1","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 03:02:02"),
("16948","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-31","2018-04-01 23:02:08"),
("16949","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-03-31","2018-04-01 23:02:13"),
("16950","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 03:02:19"),
("16951","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 03:02:25"),
("16952","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 03:02:30"),
("17132","1215","1215","300","Manager","31","3594","-683.5","75","3701","-571.513","0","0","0","0","0","0","0","2018-04-02","2018-04-03 03:02:15"),
("17133","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 23:02:21"),
("17134","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-01","2018-04-02 23:02:27"),
("17135","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-02","2018-04-03 03:02:32"),
("17136","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-02","2018-04-03 03:02:38"),
("17137","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-02","2018-04-03 03:02:44"),
("17326","1215","1215","300","Manager","35","2381","-303.824","26","1854","-1365","0","0","0","0","0","0","0","2018-04-03","2018-04-04 03:02:12"),
("17327","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-02","2018-04-03 23:02:18"),
("17328","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-02","2018-04-03 23:02:24"),
("17329","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-03","2018-04-04 03:02:30"),
("17330","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-03","2018-04-04 03:02:36"),
("17331","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-03","2018-04-04 03:02:42"),
("17512","1215","1215","300","Manager","54","2187","-202.566","12","759","-2098.55","0","0","0","0","0","0","0","2018-04-04","2018-04-05 03:02:08"),
("17513","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-03","2018-04-04 23:02:13"),
("17514","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-03","2018-04-04 23:02:19"),
("17515","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-04","2018-04-05 03:02:25");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("17516","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-04","2018-04-05 03:02:31"),
("17517","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-04","2018-04-05 03:02:37"),
("17729","1215","1215","300","Manager","54","2132","-161.66","9","2020","-2269.5","0","0","0","0","0","0","0","2018-04-05","2018-04-06 03:02:09"),
("17730","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-04","2018-04-05 23:02:15"),
("17731","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-04","2018-04-05 23:02:20"),
("17732","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-05","2018-04-06 03:02:26"),
("17733","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-05","2018-04-06 03:02:32"),
("17734","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-05","2018-04-06 03:02:38"),
("17929","1215","1215","300","Manager","0","0","0","14","1722","-2590.69","0","0","0","0","0","0","0","2018-04-06","2018-04-07 03:02:13"),
("17930","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-05","2018-04-06 23:02:19"),
("17931","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-05","2018-04-06 23:02:24"),
("17932","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-06","2018-04-07 03:02:30"),
("17933","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-06","2018-04-07 03:02:36"),
("17934","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-06","2018-04-07 03:02:42"),
("18114","1215","1215","300","Manager","0","0","0","4","731","-920","0","0","0","0","0","0","0","2018-04-07","2018-04-08 03:02:18"),
("18115","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-06","2018-04-07 23:02:25"),
("18116","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-06","2018-04-07 23:02:32"),
("18117","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-07","2018-04-08 03:02:38"),
("18118","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-07","2018-04-08 03:02:44"),
("18119","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-07","2018-04-08 03:02:50"),
("18317","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 03:02:11"),
("18318","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-07","2018-04-08 23:02:17"),
("18319","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-07","2018-04-08 23:02:23"),
("18320","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 03:02:29"),
("18321","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 03:02:35"),
("18322","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 03:02:41"),
("18520","1215","1215","300","Manager","103","4320","-244.569","11","1497","-3731","0","0","0","0","0","0","0","2018-04-09","2018-04-10 03:02:09"),
("18521","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 23:02:15"),
("18522","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-08","2018-04-09 23:02:23"),
("18523","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-09","2018-04-10 03:02:28"),
("18524","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-09","2018-04-10 03:02:34"),
("18525","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-09","2018-04-10 03:02:40"),
("18722","1215","1215","300","Manager","106","3976","-222.019","10","1572","-2367.56","0","0","0","0","0","0","0","2018-04-10","2018-04-11 03:02:12"),
("18723","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-09","2018-04-10 23:02:18"),
("18724","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-09","2018-04-10 23:02:24"),
("18725","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-10","2018-04-11 03:02:30"),
("18726","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-10","2018-04-11 03:02:36"),
("18727","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-10","2018-04-11 03:02:42"),
("18930","1215","1215","300","Manager","85","3757","-315.321","20","2229","-1526.21","0","0","0","0","0","0","0","2018-04-11","2018-04-12 03:02:02"),
("18931","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-10","2018-04-11 23:02:07"),
("18932","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-10","2018-04-11 23:02:13"),
("18933","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-11","2018-04-12 03:02:18"),
("18934","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-11","2018-04-12 03:02:24"),
("18935","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-11","2018-04-12 03:02:29"),
("19138","1215","1215","300","Manager","97","5022","-215.042","28","3353","-1212.41","0","0","0","0","0","0","0","2018-04-12","2018-04-13 03:02:03"),
("19139","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-11","2018-04-12 23:02:08"),
("19140","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-11","2018-04-12 23:02:14"),
("19141","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-12","2018-04-13 03:02:19"),
("19142","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-12","2018-04-13 03:02:24"),
("19143","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-12","2018-04-13 03:02:30"),
("19346","1215","1215","300","Manager","52","2136","-249.098","22","3033","-1401.67","0","0","0","0","0","0","0","2018-04-13","2018-04-14 03:02:05"),
("19347","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-12","2018-04-13 23:02:11"),
("19348","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-12","2018-04-13 23:02:16"),
("19349","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-13","2018-04-14 03:02:22"),
("19350","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-13","2018-04-14 03:02:27"),
("19351","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-13","2018-04-14 03:02:33"),
("19555","1215","1215","300","Manager","0","0","0","3","176","-3723","0","0","0","0","0","0","0","2018-04-14","2018-04-15 03:02:00"),
("19556","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-13","2018-04-14 23:02:06"),
("19557","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-13","2018-04-14 23:02:11"),
("19558","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-14","2018-04-15 03:02:17"),
("19559","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-14","2018-04-15 03:02:23"),
("19560","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-14","2018-04-15 03:02:29"),
("19764","1215","1215","300","Manager","0","0","0","3","122","-6417","0","0","0","0","0","0","0","2018-04-15","2018-04-16 03:02:04"),
("19765","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-14","2018-04-15 23:02:10"),
("19766","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-14","2018-04-15 23:02:15"),
("19767","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-15","2018-04-16 03:02:20"),
("19768","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-15","2018-04-16 03:02:26"),
("19769","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-15","2018-04-16 03:02:31"),
("20027","1215","1215","300","Manager","55","3197","-296.5","9","758","-3773.88","0","0","0","0","0","0","0","2018-04-17","2018-04-18 03:02:06"),
("20028","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-16","2018-04-17 23:02:12"),
("20029","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-16","2018-04-17 23:02:17"),
("20030","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-17","2018-04-18 03:02:23"),
("20031","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-17","2018-04-18 03:02:29"),
("20032","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-17","2018-04-18 03:02:34"),
("20219","1215","1215","300","Manager","101","5012","-182.79","21","2091","-1407.9","0","0","0","0","0","0","0","2018-04-18","2018-04-19 03:02:05"),
("20220","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-17","2018-04-18 23:02:11"),
("20221","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-17","2018-04-18 23:02:16"),
("20222","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-18","2018-04-19 03:02:22"),
("20223","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-18","2018-04-19 03:02:27"),
("20224","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-18","2018-04-19 03:02:33"),
("20415","1215","1215","300","Manager","101","4561","-173.77","18","2236","-1567.65","0","0","0","0","0","0","0","2018-04-19","2018-04-20 03:02:08"),
("20416","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-18","2018-04-19 23:02:14"),
("20417","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-18","2018-04-19 23:02:19"),
("20418","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-19","2018-04-20 03:02:25"),
("20419","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-19","2018-04-20 03:02:30"),
("20420","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-19","2018-04-20 03:02:36"),
("20623","1215","1215","300","Manager","34","1684","-405.515","9","1124","-2792.75","0","0","0","0","0","0","0","2018-04-20","2018-04-21 03:02:19"),
("20624","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-19","2018-04-20 23:02:24"),
("20625","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-19","2018-04-20 23:02:30"),
("20626","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-20","2018-04-21 03:02:36"),
("20627","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-20","2018-04-21 03:02:41"),
("20628","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-20","2018-04-21 03:02:47"),
("20834","1215","1215","300","Manager","0","0","0","3","125","-2904.5","0","0","0","0","0","0","0","2018-04-21","2018-04-22 03:02:12"),
("20835","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-20","2018-04-21 23:02:17"),
("20836","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-20","2018-04-21 23:02:23"),
("20837","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-21","2018-04-22 03:02:29"),
("20838","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-21","2018-04-22 03:02:34"),
("20839","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-21","2018-04-22 03:02:40"),
("21045","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 03:02:10"),
("21046","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-21","2018-04-22 23:02:15"),
("21047","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-21","2018-04-22 23:02:21"),
("21048","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 03:02:26"),
("21049","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 03:02:32"),
("21050","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 03:02:37"),
("21256","1215","1215","300","Manager","85","3444","-236.655","29","1905","-1560.11","0","0","0","0","0","0","0","2018-04-23","2018-04-24 03:02:15"),
("21257","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 23:02:20"),
("21258","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-22","2018-04-23 23:02:26"),
("21259","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-23","2018-04-24 03:02:31"),
("21260","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-23","2018-04-24 03:02:37"),
("21261","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-23","2018-04-24 03:02:42"),
("21470","1215","1215","300","Manager","102","4975","-244.099","23","1638","-1845.86","0","0","0","0","1","0","0","2018-04-24","2018-04-25 03:02:15"),
("21471","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-23","2018-04-24 23:02:20"),
("21472","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-23","2018-04-24 23:02:26"),
("21473","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-24","2018-04-25 03:02:32"),
("21474","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-24","2018-04-25 03:02:37"),
("21475","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-24","2018-04-25 03:02:43"),
("21676","1215","1215","300","Manager","91","3887","-213.789","25","1931","-1311.29","0","0","0","0","0","0","0","2018-04-25","2018-04-26 03:02:14"),
("21677","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-24","2018-04-25 23:02:20"),
("21678","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-24","2018-04-25 23:02:25"),
("21679","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-25","2018-04-26 03:02:31"),
("21680","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-25","2018-04-26 03:02:37"),
("21681","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-25","2018-04-26 03:02:43"),
("21885","1215","1215","300","Manager","7","500","-466.833","12","936","-2084","0","0","0","0","0","0","0","2018-04-26","2018-04-27 03:02:15"),
("21886","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-25","2018-04-26 23:02:21"),
("21887","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-25","2018-04-26 23:02:26"),
("21888","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-26","2018-04-27 03:02:32"),
("21889","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-26","2018-04-27 03:02:38"),
("21890","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-26","2018-04-27 03:02:43"),
("22094","1215","1215","300","Manager","10","140","-484.778","14","736","-2213.38","0","0","0","0","0","0","0","2018-04-27","2018-04-28 03:02:06"),
("22095","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-26","2018-04-27 23:02:12"),
("22096","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-26","2018-04-27 23:02:18"),
("22097","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-27","2018-04-28 03:02:23"),
("22098","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-27","2018-04-28 03:02:29"),
("22099","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-27","2018-04-28 03:02:35"),
("22303","1215","1215","300","Manager","0","0","0","8","801","-2578.57","0","0","0","0","0","0","0","2018-04-28","2018-04-29 03:02:15"),
("22304","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-27","2018-04-28 23:02:20"),
("22305","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-27","2018-04-28 23:02:26"),
("22306","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-28","2018-04-29 03:02:32"),
("22307","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-28","2018-04-29 03:02:38"),
("22308","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-28","2018-04-29 03:02:44"),
("22512","1215","1215","300","Manager","0","0","0","1","49","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 03:02:12"),
("22513","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-28","2018-04-29 23:02:18"),
("22514","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-28","2018-04-29 23:02:23"),
("22515","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 03:02:29"),
("22516","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 03:02:35"),
("22517","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 03:02:40"),
("22723","1215","1215","300","Manager","101","4182","-192","28","2697","-1244.07","0","0","0","0","1","0","0","2018-04-30","2018-05-01 03:02:04"),
("22724","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 23:02:10"),
("22725","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-29","2018-04-30 23:02:15");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("22726","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-30","2018-05-01 03:02:20"),
("22727","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-30","2018-05-01 03:02:25"),
("22728","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-30","2018-05-01 03:02:30"),
("22934","1215","1215","300","Manager","93","4531","-235.815","17","1162","-2456.94","0","0","0","0","0","0","0","2018-05-01","2018-05-02 03:02:15"),
("22935","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-04-30","2018-05-01 23:02:20"),
("22936","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-04-30","2018-05-01 23:02:26"),
("22937","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-01","2018-05-02 03:02:31"),
("22938","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-01","2018-05-02 03:02:37"),
("22939","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-01","2018-05-02 03:02:42"),
("23146","1215","1215","300","Manager","106","4825","-189.019","23","2277","-1731.18","0","0","0","0","0","0","0","2018-05-02","2018-05-03 03:03:34"),
("23147","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-01","2018-05-02 23:03:44"),
("23148","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-01","2018-05-02 23:03:56"),
("23149","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-02","2018-05-03 03:04:05"),
("23150","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-02","2018-05-03 03:04:15"),
("23151","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-02","2018-05-03 03:04:26"),
("23380","1215","1215","300","Manager","110","5561","-157.78","11","875","-4173","0","0","0","0","0","0","0","2018-05-03","2018-05-04 03:02:12"),
("23381","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-02","2018-05-03 23:02:17"),
("23382","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-02","2018-05-03 23:02:23"),
("23383","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-03","2018-05-04 03:02:28"),
("23384","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-03","2018-05-04 03:02:33"),
("23385","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-03","2018-05-04 03:02:39"),
("23570","1215","1215","300","Manager","81","4670","-225.688","7","914","-2731.83","0","0","0","0","0","0","0","2018-05-04","2018-05-05 03:02:10"),
("23571","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-03","2018-05-04 23:02:15"),
("23572","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-03","2018-05-04 23:02:20"),
("23573","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-04","2018-05-05 03:02:25"),
("23574","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-04","2018-05-05 03:02:30"),
("23575","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-04","2018-05-05 03:02:36"),
("23782","1215","1215","300","Manager","0","0","0","5","732","-5046.25","0","0","0","0","0","0","0","2018-05-05","2018-05-06 03:02:05"),
("23783","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-04","2018-05-05 23:02:10"),
("23784","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-04","2018-05-05 23:02:16"),
("23785","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-05","2018-05-06 03:02:21"),
("23786","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-05","2018-05-06 03:02:26"),
("23787","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-05","2018-05-06 03:02:31"),
("23993","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 03:01:59"),
("23994","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-05","2018-05-06 23:02:05"),
("23995","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-05","2018-05-06 23:02:10"),
("23996","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 03:02:15"),
("23997","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 03:02:20"),
("23998","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 03:02:26"),
("24237","1215","1215","300","Manager","123","5075","-148.91","21","2380","-2361.2","0","0","0","0","0","0","0","2018-05-07","2018-05-08 03:02:02"),
("24238","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 23:02:08"),
("24239","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-06","2018-05-07 23:02:13"),
("24240","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-07","2018-05-08 03:02:18"),
("24241","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-07","2018-05-08 03:02:23"),
("24242","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-07","2018-05-08 03:02:29"),
("24425","1215","1215","300","Manager","84","4917","-234.675","10","1292","-3965.44","0","0","0","0","0","0","0","2018-05-08","2018-05-09 03:02:00"),
("24426","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-07","2018-05-08 23:02:05"),
("24427","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-07","2018-05-08 23:02:10"),
("24428","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-08","2018-05-09 03:02:15"),
("24429","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-08","2018-05-09 03:02:20"),
("24430","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-08","2018-05-09 03:02:26"),
("24631","1215","1215","300","Manager","106","3101","-172.705","22","3157","-1556.14","0","0","0","0","0","0","0","2018-05-09","2018-05-10 03:02:10"),
("24632","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-08","2018-05-09 23:02:15"),
("24633","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-08","2018-05-09 23:02:21"),
("24634","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-09","2018-05-10 03:02:26"),
("24635","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-09","2018-05-10 03:02:31"),
("24636","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-09","2018-05-10 03:02:36"),
("24843","1215","1215","300","Manager","103","4113","-194.843","10","1310","-2478.89","0","0","0","0","0","0","0","2018-05-10","2018-05-11 03:02:08"),
("24844","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-09","2018-05-10 23:02:13"),
("24845","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-09","2018-05-10 23:02:18"),
("24846","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-10","2018-05-11 03:02:23"),
("24847","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-10","2018-05-11 03:02:29"),
("24848","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-10","2018-05-11 03:02:34"),
("25059","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 03:01:59"),
("25060","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-10","2018-05-11 23:02:04"),
("25061","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-10","2018-05-11 23:02:09"),
("25062","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 03:02:14"),
("25063","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 03:02:19"),
("25064","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 03:02:24"),
("25283","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:01"),
("25284","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 23:02:06"),
("25285","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-11","2018-05-12 23:02:11"),
("25286","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:16"),
("25287","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:16"),
("25288","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:22"),
("25289","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:22"),
("25290","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 03:02:27"),
("25599","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 03:01:58"),
("25600","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 23:02:04"),
("25601","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-12","2018-05-13 23:02:09"),
("25602","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 03:02:14"),
("25603","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 03:02:19"),
("25604","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 03:02:24"),
("25814","1215","1215","300","Manager","70","1844","-214.783","8","1849","-2582.71","0","0","0","0","0","0","0","2018-05-14","2018-05-15 03:01:53"),
("25815","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 23:01:58"),
("25816","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-13","2018-05-14 23:02:03"),
("25817","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-14","2018-05-15 03:02:08"),
("25818","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-14","2018-05-15 03:02:13"),
("25819","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-14","2018-05-15 03:02:18"),
("26029","1215","1215","300","Manager","0","0","0","16","1883","-1912.4","0","0","0","0","0","0","0","2018-05-15","2018-05-16 03:01:53"),
("26030","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-14","2018-05-15 23:01:59"),
("26031","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-14","2018-05-15 23:02:04"),
("26032","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-15","2018-05-16 03:02:09"),
("26033","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-15","2018-05-16 03:02:14"),
("26034","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-15","2018-05-16 03:02:20"),
("26244","1215","1215","300","Manager","109","3189","-234.491","27","2130","-1499.81","0","0","0","0","1","0","0","2018-05-16","2018-05-17 03:02:03"),
("26245","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-15","2018-05-16 23:02:09"),
("26246","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-15","2018-05-16 23:02:14"),
("26247","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-16","2018-05-17 03:02:19"),
("26248","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-16","2018-05-17 03:02:24"),
("26249","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-16","2018-05-17 03:02:30"),
("26461","1215","1215","300","Manager","104","2744","-212.078","18","2383","-1592.53","0","0","0","0","1","0","0","2018-05-17","2018-05-18 03:02:00"),
("26462","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-16","2018-05-17 23:02:05"),
("26463","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-16","2018-05-17 23:02:11"),
("26464","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-17","2018-05-18 03:02:16"),
("26465","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-17","2018-05-18 03:02:21"),
("26466","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-17","2018-05-18 03:02:27"),
("26672","1215","1215","300","Manager","0","0","0","14","891","-2164.23","0","0","0","0","0","0","0","2018-05-18","2018-05-19 03:01:33"),
("26673","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-17","2018-05-18 23:01:39"),
("26674","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","1","0","0","2018-05-17","2018-05-18 23:01:44"),
("26675","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-18","2018-05-19 03:01:49"),
("26676","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-18","2018-05-19 03:01:55"),
("26677","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-18","2018-05-19 03:02:00"),
("26881","1215","1215","300","Manager","0","0","0","3","401","-6036","0","0","0","0","0","0","0","2018-05-19","2018-05-20 03:01:35"),
("26882","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-18","2018-05-19 23:01:41"),
("26883","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-18","2018-05-19 23:01:46"),
("26884","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-19","2018-05-20 03:01:51"),
("26885","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-19","2018-05-20 03:01:57"),
("26886","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-19","2018-05-20 03:02:02"),
("27090","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 03:01:33"),
("27091","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-19","2018-05-20 23:01:38"),
("27092","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-19","2018-05-20 23:01:43"),
("27093","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 03:01:48"),
("27094","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 03:01:54"),
("27095","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 03:01:59"),
("27302","1215","1215","300","Manager","0","0","0","28","2883","-1379","0","0","0","0","0","0","0","2018-05-21","2018-05-22 03:01:29"),
("27303","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 23:01:35"),
("27304","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-20","2018-05-21 23:01:40"),
("27305","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-21","2018-05-22 03:01:45"),
("27306","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-21","2018-05-22 03:01:51"),
("27307","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-21","2018-05-22 03:01:56"),
("27514","1215","1215","300","Manager","0","0","0","16","1916","-2470.67","0","0","0","0","0","0","0","2018-05-22","2018-05-23 03:01:29"),
("27515","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-21","2018-05-22 23:01:35"),
("27516","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-21","2018-05-22 23:01:40"),
("27517","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-22","2018-05-23 03:01:45"),
("27518","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-22","2018-05-23 03:01:51"),
("27519","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-22","2018-05-23 03:01:56"),
("27726","1215","1215","300","Manager","0","0","0","5","712","-5170.25","0","0","0","0","0","0","0","2018-05-23","2018-05-24 03:01:34"),
("27727","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-22","2018-05-23 23:01:39"),
("27728","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-22","2018-05-23 23:01:45"),
("27729","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-23","2018-05-24 03:01:50"),
("27730","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-23","2018-05-24 03:01:55"),
("27731","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-23","2018-05-24 03:02:01"),
("27939","1215","1215","300","Manager","0","0","0","10","1374","-3274","0","0","0","0","0","0","0","2018-05-24","2018-05-25 03:01:28"),
("27940","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-23","2018-05-24 23:01:33"),
("27941","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-23","2018-05-24 23:01:39"),
("27942","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-24","2018-05-25 03:01:45"),
("27943","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-24","2018-05-25 03:01:50"),
("27944","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-24","2018-05-25 03:01:56");
INSERT INTO hp_team_reports (`Id`,`memberId`,`teamId`,`resellerId`,`type`,`outbound_calls`,`outbound_duration`,`outbound_average_time`,`inbound_calls`,`inbound_duration`,`inbound_average_time`,`email_sent`,`email_opened`,`email_sent_average_time`,`sms_sent`,`sms_received`,`sms_sent_average_time`,`voicemail`,`report_date`,`dated`) VALUES
("28152","1215","1215","300","Manager","0","0","0","8","338","-4377.43","0","0","0","0","1","0","0","2018-05-25","2018-05-26 03:01:38"),
("28153","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-24","2018-05-25 23:01:44"),
("28154","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-24","2018-05-25 23:01:50"),
("28155","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-25","2018-05-26 03:01:56"),
("28156","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-25","2018-05-26 03:02:01"),
("28157","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-25","2018-05-26 03:02:07"),
("28366","1215","1215","300","Manager","0","0","0","6","718","-6059.2","0","0","0","0","0","0","0","2018-05-26","2018-05-27 03:01:40"),
("28367","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-25","2018-05-26 23:01:46"),
("28368","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-25","2018-05-26 23:01:52"),
("28369","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-26","2018-05-27 03:01:58"),
("28370","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-26","2018-05-27 03:02:03"),
("28371","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-26","2018-05-27 03:02:09"),
("28580","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 03:01:40"),
("28581","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-26","2018-05-27 23:01:46"),
("28582","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-26","2018-05-27 23:01:52"),
("28583","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 03:01:57"),
("28584","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 03:02:03"),
("28585","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 03:02:09"),
("28794","1215","1215","300","Manager","0","0","0","10","401","-3795.67","0","0","0","0","0","0","0","2018-05-28","2018-05-29 03:01:32"),
("28795","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 23:01:38"),
("28796","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-27","2018-05-28 23:01:43"),
("28797","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-28","2018-05-29 03:01:49"),
("28798","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-28","2018-05-29 03:01:55"),
("28799","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-28","2018-05-29 03:02:00"),
("29008","1215","1215","300","Manager","0","0","0","6","765","-2812.8","0","0","0","0","0","0","0","2018-05-29","2018-05-30 03:01:40"),
("29009","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-28","2018-05-29 23:01:46"),
("29010","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-28","2018-05-29 23:01:51"),
("29011","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-29","2018-05-30 03:01:57"),
("29012","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-29","2018-05-30 03:02:03"),
("29013","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-29","2018-05-30 03:02:09"),
("29223","1215","1215","300","Manager","0","0","0","6","995","-3244.2","0","0","0","0","0","0","0","2018-05-30","2018-05-31 03:01:31"),
("29224","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-29","2018-05-30 23:01:37"),
("29225","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-29","2018-05-30 23:01:43"),
("29226","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-30","2018-05-31 03:01:49"),
("29227","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-30","2018-05-31 03:01:54"),
("29228","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-30","2018-05-31 03:02:00"),
("29438","1215","1215","300","Manager","0","0","0","9","740","-2805.88","0","0","0","0","0","0","0","2018-05-31","2018-06-01 03:01:39"),
("29439","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-30","2018-05-31 23:01:45"),
("29440","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-30","2018-05-31 23:01:51"),
("29441","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-31","2018-06-01 03:01:57"),
("29442","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-31","2018-06-01 03:02:03"),
("29443","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-31","2018-06-01 03:02:09"),
("29653","1215","1215","300","Manager","0","0","0","14","1803","-1812.85","0","0","0","0","0","0","0","2018-06-01","2018-06-02 03:01:38"),
("29654","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-31","2018-06-01 23:01:44"),
("29655","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-05-31","2018-06-01 23:01:49"),
("29656","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-01","2018-06-02 03:01:55"),
("29657","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-01","2018-06-02 03:02:01"),
("29658","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-01","2018-06-02 03:02:07"),
("29869","1215","1215","300","Manager","0","0","0","1","83","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 03:01:36"),
("29870","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-01","2018-06-02 23:01:42"),
("29871","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-01","2018-06-02 23:01:47"),
("29872","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 03:01:53"),
("29873","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 03:01:58"),
("29874","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 03:02:03"),
("30085","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 03:01:33"),
("30086","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 23:01:39"),
("30087","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-02","2018-06-03 23:01:44"),
("30088","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 03:01:49"),
("30089","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 03:01:54"),
("30090","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 03:01:59"),
("30301","1215","1215","300","Manager","0","0","0","9","1036","-1285.5","0","0","0","0","0","0","0","2018-06-04","2018-06-05 03:01:28"),
("30302","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 23:01:33"),
("30303","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-03","2018-06-04 23:01:39"),
("30304","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-04","2018-06-05 03:01:44"),
("30305","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-04","2018-06-05 03:01:50"),
("30306","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-04","2018-06-05 03:01:55"),
("30519","1215","1215","300","Manager","0","0","0","9","876","-3208.75","0","0","0","0","0","0","0","2018-06-05","2018-06-06 03:01:49"),
("30520","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-04","2018-06-05 23:01:56"),
("30521","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-04","2018-06-05 23:02:02"),
("30522","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-05","2018-06-06 03:02:08"),
("30523","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-05","2018-06-06 03:02:15"),
("30524","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-05","2018-06-06 03:02:21"),
("30726","1215","1215","300","Manager","0","0","0","16","1518","-1876.33","0","0","0","0","0","0","0","2018-06-06","2018-06-07 03:01:37"),
("30727","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-05","2018-06-06 23:01:42"),
("30728","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-05","2018-06-06 23:01:48"),
("30729","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-06","2018-06-07 03:01:53"),
("30730","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-06","2018-06-07 03:01:59"),
("30731","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-06","2018-06-07 03:02:04"),
("30936","1215","1215","300","Manager","0","0","0","9","367","-2815.88","0","0","0","0","0","0","0","2018-06-07","2018-06-08 03:01:52"),
("30937","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-06","2018-06-07 23:01:58"),
("30938","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-06","2018-06-07 23:02:03"),
("30939","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-07","2018-06-08 03:02:09"),
("30940","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-07","2018-06-08 03:02:15"),
("30941","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-07","2018-06-08 03:02:20"),
("31135","1215","1215","300","Manager","0","0","0","7","959","-3953.33","0","0","0","0","0","0","0","2018-06-08","2018-06-09 03:01:48"),
("31136","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-07","2018-06-08 23:01:54"),
("31137","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-07","2018-06-08 23:01:59"),
("31138","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-08","2018-06-09 03:02:05"),
("31139","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-08","2018-06-09 03:02:11"),
("31140","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-08","2018-06-09 03:02:17"),
("31336","1215","1215","300","Manager","0","0","0","2","59","-725","0","0","0","0","0","0","0","2018-06-09","2018-06-10 03:01:50"),
("31337","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-08","2018-06-09 23:01:55"),
("31338","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-08","2018-06-09 23:02:01"),
("31339","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-09","2018-06-10 03:02:07"),
("31340","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-09","2018-06-10 03:02:12"),
("31341","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-09","2018-06-10 03:02:18"),
("31537","1215","1215","300","Manager","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 03:01:46"),
("31538","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-09","2018-06-10 23:01:52"),
("31539","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-09","2018-06-10 23:01:58"),
("31540","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 03:02:03"),
("31541","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 03:02:10"),
("31542","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 03:02:15"),
("31738","1215","1215","300","Manager","0","0","0","14","2009","-5045.54","0","0","0","0","0","0","0","2018-06-11","2018-06-12 03:02:09"),
("31739","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 23:02:16"),
("31740","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-10","2018-06-11 23:02:23"),
("31741","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-11","2018-06-12 03:02:31"),
("31742","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-11","2018-06-12 03:02:39"),
("31743","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-11","2018-06-12 03:02:47"),
("31940","1215","1215","300","Manager","0","0","0","10","1839","-2589.11","0","0","0","0","0","0","0","2018-06-12","2018-06-13 03:01:49"),
("31941","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-11","2018-06-12 23:01:55"),
("31942","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-11","2018-06-12 23:02:00"),
("31943","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-12","2018-06-13 03:02:06"),
("31944","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-12","2018-06-13 03:02:12"),
("31945","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-12","2018-06-13 03:02:17"),
("32145","1215","1215","300","Manager","0","0","0","7","1480","-7518.5","0","0","0","0","0","0","0","2018-06-13","2018-06-14 03:01:46"),
("32146","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-12","2018-06-13 23:01:51"),
("32147","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-12","2018-06-13 23:01:57"),
("32148","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-13","2018-06-14 03:02:03"),
("32149","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-13","2018-06-14 03:02:09"),
("32150","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-13","2018-06-14 03:02:14"),
("32346","1215","1215","300","Manager","0","0","0","10","618","-4447","0","0","0","0","0","0","0","2018-06-14","2018-06-15 03:01:55"),
("32347","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-13","2018-06-14 23:02:01"),
("32348","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-13","2018-06-14 23:02:07"),
("32349","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-14","2018-06-15 03:02:13"),
("32350","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-14","2018-06-15 03:02:19"),
("32351","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-14","2018-06-15 03:02:25"),
("32545","1215","1215","300","Manager","0","0","0","3","423","-6377.5","0","0","0","0","0","0","0","2018-06-15","2018-06-16 03:01:48"),
("32546","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-14","2018-06-15 23:01:54"),
("32547","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-14","2018-06-15 23:02:00"),
("32548","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-15","2018-06-16 03:02:05"),
("32549","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-15","2018-06-16 03:02:11"),
("32550","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-15","2018-06-16 03:02:17"),
("32744","1215","1215","300","Manager","0","0","0","8","915","-2160.29","0","0","0","0","0","0","0","2018-06-16","2018-06-17 03:01:54"),
("32745","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-15","2018-06-16 23:01:59"),
("32746","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-15","2018-06-16 23:02:05"),
("32747","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-16","2018-06-17 03:02:11"),
("32748","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-16","2018-06-17 03:02:17"),
("32749","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-16","2018-06-17 03:02:22"),
("32943","1215","1215","300","Manager","0","0","0","1","52","0","0","0","0","0","0","0","0","2018-06-17","2018-06-18 03:01:50"),
("32944","2031","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-16","2018-06-17 23:01:56"),
("32945","2032","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-16","2018-06-17 23:02:01"),
("32946","2034","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-17","2018-06-18 03:02:07"),
("32947","2035","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-17","2018-06-18 03:02:13"),
("32948","2036","1215","300","Member","0","0","0","0","0","0","0","0","0","0","0","0","0","2018-06-17","2018-06-18 03:02:19");



