{"userId":"102","date":"2019-03-25 08:48:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('102', '223.179.197.82', '2019-03-25 08:48:49')"}
{"userId":"1","date":"2019-03-25 13:16:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '192.168.120.111', '2019-03-25 13:16:32')"}
{"userId":"1","date":"2019-03-25 15:14:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '192.168.120.111', '2019-03-25 15:14:25')"}
{"userId":"123","date":"2019-03-25 15:37:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.101.134', '2019-03-25 15:37:45')"}
{"userId":"123","date":"2019-03-25 16:01:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.69.158', '2019-03-25 16:01:49')"}
{"userId":"123","date":"2019-03-25 16:19:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.179.214.189', '2019-03-25 16:19:47')"}
{"userId":"123","date":"2019-03-25 16:21:57","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('104', '2019-03-15', '123', '223.179.214.189', '123', '2019-03-25 16:21:57')"}
{"userId":"123","date":"2019-03-25 18:27:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.179.195.38', '2019-03-25 18:27:49')"}
{"userId":"126","date":"2019-03-25 18:31:41","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('126', '157.51.52.85', '2019-03-25 18:31:41')"}
{"userId":"123","date":"2019-03-25 18:31:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.179.228.62', '2019-03-25 18:31:42')"}
{"userId":"126","date":"2019-03-25 18:32:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('126', '157.51.2.21', '2019-03-25 18:32:18')"}
{"userId":"123","date":"2019-03-25 18:32:41","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '223.179.228.62', `modifiedby` = '123', `modifieddate` = '2019-03-25 18:32:41' WHERE plansiteid = '873'"}
{"userId":"123","date":"2019-03-25 18:32:41","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '223.179.228.62', `modifiedby` = '123', `modifieddate` = '2019-03-25 18:32:41' WHERE ssid = ''"}
{"userId":"123","date":"2019-03-25 18:36:00","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('104', '2019-03-15', '123', '223.179.228.62', '123', '2019-03-25 18:36:00')"}
{"userId":"123","date":"2019-03-25 18:37:20","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '223.179.228.62', `modifiedby` = '123', `modifieddate` = '2019-03-25 18:37:20' WHERE plansiteid = '874'"}
{"userId":"123","date":"2019-03-25 18:37:20","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '223.179.228.62', `modifiedby` = '123', `modifieddate` = '2019-03-25 18:37:20' WHERE ssid = ''"}
{"userId":"123","date":"2019-03-25 18:38:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.179.195.38', '2019-03-25 18:38:32')"}
{"userId":"123","date":"2019-03-25 18:40:42","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('103', '2019-03-15', '123', '223.231.121.98', '123', '2019-03-25 18:40:42')"}
{"userId":"123","date":"2019-03-25 18:40:55","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('103', '875', '123', '2019-03-25', '0', '223.231.121.98', '123', '2019-03-25 18:40:55', '', '')"}
{"userId":"123","date":"2019-03-25 18:40:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('695', '0', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('695', '', '', 'Array', '', 'Array', '', '223.231.121.98', '123', '2019-03-25 18:40:56')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('695', '', '', 'Array', '', 'Array', '', '223.231.121.98', '123', '2019-03-25 18:40:56')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('695', '', '', 'Array', '', 'Array', '', '223.231.121.98', '123', '2019-03-25 18:40:56')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('695', '', '', 'Array', '', 'Array', '', '223.231.121.98', '123', '2019-03-25 18:40:56')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:40:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:41:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('695', '223.231.121.98', '123', '2019-03-25 18:40:55')"}
{"userId":"123","date":"2019-03-25 18:42:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.121.98', '2019-03-25 18:42:20')"}
{"userId":"123","date":"2019-03-25 18:42:56","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('103', '2019-03-25', '123', '223.231.121.98', '123', '2019-03-25 18:42:56')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('103', '876', '123', '2019-03-25', '0', '223.231.94.194', '123', '2019-03-25 18:43:08', '', '')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('696', '0', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('696', '', '', 'Array', '', 'Array', '', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('696', '', '', 'Array', '', 'Array', '', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('696', '', '', 'Array', '', 'Array', '', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('696', '', '', 'Array', '', 'Array', '', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 18:43:27","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('696', '223.231.94.194', '123', '2019-03-25 18:43:08')"}
{"userId":"123","date":"2019-03-25 19:09:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:09:59')"}
{"userId":"123","date":"2019-03-25 19:10:49","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('104', '2019-03-15', '123', '223.231.74.155', '123', '2019-03-25 19:10:49')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('104', '877', '123', '2019-03-25', '0', '223.231.74.155', '123', '2019-03-25 19:10:57', '', '')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('697', '0', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('697', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('697', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('697', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('697', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:10:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:11:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('697', '223.231.74.155', '123', '2019-03-25 19:10:57')"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE sitesupervision SET `siteid` = '104', `userid` = '123', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '697'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE onssid = '3116'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE onssid = '3117'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE onssid = '3118'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE onssid = '3119'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE supvisstepid = '4480'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE visitfeedbackid = '3266'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE visitfeedbackid = '3267'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE visitfeedbackid = '3268'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE visitfeedbackid = '3269'"}
{"userId":"123","date":"2019-03-25 19:13:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:13:05' WHERE visitfeedbackid = '3270'"}
{"userId":"123","date":"2019-03-25 19:14:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:14:46')"}
{"userId":"123","date":"2019-03-25 19:17:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:17:01')"}
{"userId":"123","date":"2019-03-25 19:17:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:17:50')"}
{"userId":"123","date":"2019-03-25 19:18:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:18:46')"}
{"userId":"123","date":"2019-03-25 19:20:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:20:29')"}
{"userId":"123","date":"2019-03-25 19:23:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:23:18')"}
{"userId":"123","date":"2019-03-25 19:23:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:23:54')"}
{"userId":"123","date":"2019-03-25 19:24:39","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:24:39')"}
{"userId":"123","date":"2019-03-25 19:34:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:34:09')"}
{"userId":"123","date":"2019-03-25 19:35:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:35:24')"}
{"userId":"123","date":"2019-03-25 19:37:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:37:16')"}
{"userId":"123","date":"2019-03-25 19:45:35","query":"UPDATE sitesupervision SET `siteid` = '103', `userid` = '123', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '695'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:36' WHERE onssid = '3108'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:36' WHERE onssid = '3109'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:36' WHERE onssid = '3110'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:36' WHERE onssid = '3111'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE supvisstepid = '4478'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE visitfeedback SET `feedback` = 'Inadequate space for counselling and lab service', `recommendation` = 'Further sensitization needed', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE visitfeedbackid = '3256'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE visitfeedback SET `feedback` = 'Lab not well organised', `recommendation` = 'proper arrangement of the equipments', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE visitfeedbackid = '3257'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE visitfeedback SET `feedback` = 'Biomexical waste segregation not done properly', `recommendation` = 'BMW proper segregation needed', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE visitfeedbackid = '3258'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE visitfeedback SET `feedback` = 'No puncture proof containter available', `recommendation` = 'coordination and cooperation among the staffs required', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE visitfeedbackid = '3259'"}
{"userId":"123","date":"2019-03-25 19:45:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:45:35' WHERE visitfeedbackid = '3260'"}
{"userId":"123","date":"2019-03-25 19:46:26","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('110', '2019-03-25', '123', '223.231.74.155', '123', '2019-03-25 19:46:26')"}
{"userId":"123","date":"2019-03-25 19:47:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:47:24')"}
{"userId":"123","date":"2019-03-25 19:47:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:47:25')"}
{"userId":"123","date":"2019-03-25 19:47:43","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:47:43' WHERE plansiteid = '878'"}
{"userId":"123","date":"2019-03-25 19:47:43","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '223.231.74.155', `modifiedby` = '123', `modifieddate` = '2019-03-25 19:47:43' WHERE ssid = ''"}
{"userId":"123","date":"2019-03-25 19:55:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 19:55:14')"}
{"userId":"123","date":"2019-03-25 19:55:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('110', '2019-03-18', '123', '223.231.74.155', '123', '2019-03-25 19:55:51')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('110', '879', '123', '2019-03-25', '1', '223.231.74.155', '123', '2019-03-25 19:56:21', '', '')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '0', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '1', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '2', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '3', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '4', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '5', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('698', '6', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('698', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:56:23')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('698', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:56:23')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('698', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:56:23')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('698', '', '', 'Array', '', 'Array', '', '223.231.74.155', '123', '2019-03-25 19:56:23')"}
{"userId":"123","date":"2019-03-25 19:56:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 19:57:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('698', '223.231.74.155', '123', '2019-03-25 19:56:21')"}
{"userId":"123","date":"2019-03-25 20:01:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '223.231.74.155', '2019-03-25 20:01:04')"}
{"userId":"123","date":"2019-03-25 21:06:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.73.169', '2019-03-25 21:06:46')"}
{"userId":"123","date":"2019-03-25 21:07:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.108.241', '2019-03-25 21:07:00')"}
{"userId":"123","date":"2019-03-25 21:07:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.73.169', '2019-03-25 21:07:32')"}
{"userId":"123","date":"2019-03-25 21:12:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.108.241', '2019-03-25 21:12:14')"}
{"userId":"123","date":"2019-03-25 21:12:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.73.169', '2019-03-25 21:12:14')"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE onssid = '3120'"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE onssid = '3121'"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE onssid = '3122'"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE onssid = '3123'"}
{"userId":"123","date":"2019-03-25 21:16:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=73168 then '' when ansid=73169 then '' when ansid=73170 then '' when ansid=73171 then '' when ansid=73172 then ''  when ansid=73173 then ''   when ansid=73174 then ''  when ansid=73175 then '' when ansid=73177 then '' when ansid=73179 then '' when ansid=73181 then '' when ansid=73183 then '' when ansid=73185 then '' when ansid=73187 then '' when ansid=73189 then '' when ansid=73191 then '' when ansid=73193 then '' when ansid=73195 then '' when ansid=73197 then '' when ansid=73199 then '' when ansid=73201 then '' when ansid=73203 then '' when ansid=73205 then '' when ansid=73207 then '' when ansid=73209 then '' when ansid=73211 then '' when ansid=73213 then '' when ansid=73215 then '' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then ''  when ansid=73231 then ''   when ansid=73232 then ''  when ansid=73233 then ''  when ansid=73234 then ''   when ansid=73235 then ''   when ansid=73236 then ''   when ansid=73237 then ''  when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then ''  when ansid=73241 then ''   when ansid=73242 then ''   when ansid=73243 then ''   when ansid=73244 then ''  when ansid=73245 then ''  when ansid=73246 then ''   when ansid=73247 then ''  when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then ''  when ansid=73257 then ''   when ansid=73258 then ''   when ansid=73259 then ''   when ansid=73260 then ''  when ansid=73261 then '' when ansid=73262 then ''  when ansid=73263 then ''   when ansid=73264 then ''  when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.73.169',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-25 21:16:32'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE supvisstepid = '4481'"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE visitfeedbackid = '3271'"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE visitfeedbackid = '3272'"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE visitfeedbackid = '3273'"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE visitfeedbackid = '3274'"}
{"userId":"123","date":"2019-03-25 21:16:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:32' WHERE visitfeedbackid = '3275'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE onssid = '3120'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE onssid = '3121'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE onssid = '3122'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE onssid = '3123'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then ''  when ansid=73173 then ''   when ansid=73174 then '1'  when ansid=73175 then '' when ansid=73177 then '' when ansid=73179 then '' when ansid=73181 then '' when ansid=73183 then '' when ansid=73185 then '' when ansid=73187 then '' when ansid=73189 then '' when ansid=73191 then '' when ansid=73193 then '' when ansid=73195 then '' when ansid=73197 then '' when ansid=73199 then '' when ansid=73201 then '' when ansid=73203 then '' when ansid=73205 then '' when ansid=73207 then '' when ansid=73209 then '' when ansid=73211 then '' when ansid=73213 then '' when ansid=73215 then '' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then ''  when ansid=73231 then ''   when ansid=73232 then ''  when ansid=73233 then ''  when ansid=73234 then ''   when ansid=73235 then ''   when ansid=73236 then ''   when ansid=73237 then ''  when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then ''  when ansid=73241 then ''   when ansid=73242 then ''   when ansid=73243 then ''   when ansid=73244 then ''  when ansid=73245 then ''  when ansid=73246 then ''   when ansid=73247 then ''  when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then ''  when ansid=73257 then ''   when ansid=73258 then ''   when ansid=73259 then ''   when ansid=73260 then ''  when ansid=73261 then '' when ansid=73262 then ''  when ansid=73263 then ''   when ansid=73264 then ''  when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.73.169',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-25 21:16:58'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE supvisstepid = '4482'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE visitfeedbackid = '3271'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE visitfeedbackid = '3272'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE visitfeedbackid = '3273'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE visitfeedbackid = '3274'"}
{"userId":"123","date":"2019-03-25 21:16:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:16:58' WHERE visitfeedbackid = '3275'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE onssid = '3120'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE onssid = '3121'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE onssid = '3122'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE onssid = '3123'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then ''  when ansid=73173 then ''   when ansid=73174 then '1'  when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '' when ansid=73193 then '' when ansid=73195 then '' when ansid=73197 then '' when ansid=73199 then '' when ansid=73201 then '' when ansid=73203 then '' when ansid=73205 then '' when ansid=73207 then '' when ansid=73209 then '' when ansid=73211 then '' when ansid=73213 then '' when ansid=73215 then '' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then ''  when ansid=73231 then ''   when ansid=73232 then ''  when ansid=73233 then ''  when ansid=73234 then ''   when ansid=73235 then ''   when ansid=73236 then ''   when ansid=73237 then ''  when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then ''  when ansid=73241 then ''   when ansid=73242 then ''   when ansid=73243 then ''   when ansid=73244 then ''  when ansid=73245 then ''  when ansid=73246 then ''   when ansid=73247 then ''  when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then ''  when ansid=73257 then ''   when ansid=73258 then ''   when ansid=73259 then ''   when ansid=73260 then ''  when ansid=73261 then '' when ansid=73262 then ''  when ansid=73263 then ''   when ansid=73264 then ''  when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.73.169',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-25 21:17:53'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE supvisstepid = '4483'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE visitfeedbackid = '3271'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE visitfeedbackid = '3272'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE visitfeedbackid = '3273'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE visitfeedbackid = '3274'"}
{"userId":"123","date":"2019-03-25 21:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.73.169', `modifiedby` = '123', `modifieddate` = '2019-03-25 21:17:53' WHERE visitfeedbackid = '3275'"}
{"userId":"123","date":"2019-03-25 21:25:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.108.241', '2019-03-25 21:25:29')"}