{"userId":"1","date":"2021-04-20 15:30:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '10.10.1.5', '2021-04-20 15:30:10')"}
{"userId":"1","date":"2021-04-20 16:05:18","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('478', '2021-04-20', '1', '10.10.1.5', '1', '2021-04-20 16:05:18')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('478', '2765', '1', '2021-04-20', '1', '10.10.1.5', '1', '2021-04-20 16:05:32', '', '')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2352', '0', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2352', '1', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2352', '2', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2352', '3', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2352', '4', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2352', '', '', 'Array', '', 'Array', '', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2352', '', '', 'Array', '', 'Array', '', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2352', '', '', 'Array', '', 'Array', '', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2352', '', '', 'Array', '', 'Array', '', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 16:05:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2352', '10.10.1.5', '1', '2021-04-20 16:05:32')"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE sitesupervision SET `siteid` = '478', `userid` = '1', `ancservicedays` = '1', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2021-04-20', `numofsamplecollected` = '65', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11', `locationtype` = '2', `establishmentyear` = '2021', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2352'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE onssid = '9736'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE onssid = '9737'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE onssid = '9738'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE onssid = '9739'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218338 then '' when ansid=218339 then '' when ansid=218340 then '' when ansid=218341 then '' when ansid=218342 then ''  when ansid=218343 then ''   when ansid=218344 then ''  when ansid=218387 then '' when ansid=218389 then '' when ansid=218391 then '' when ansid=218393 then '' when ansid=218395 then '' when ansid=218397 then '' when ansid=218398 then '' when ansid=218399 then '' when ansid=218400 then ''  when ansid=218401 then ''   when ansid=218402 then ''  when ansid=218403 then ''  when ansid=218404 then ''   when ansid=218405 then ''   when ansid=218406 then ''   when ansid=218407 then ''  when ansid=218408 then '' when ansid=218409 then '' when ansid=218410 then ''  when ansid=218411 then ''   when ansid=218412 then ''   when ansid=218413 then ''   when ansid=218414 then ''  when ansid=218415 then ''  when ansid=218416 then ''   when ansid=218417 then ''  when ansid=218418 then '' when ansid=218419 then '' when ansid=218420 then '' when ansid=218421 then '' when ansid=218422 then '' when ansid=218423 then '' when ansid=218424 then '' when ansid=218425 then '' when ansid=218426 then ''  when ansid=218427 then ''   when ansid=218428 then ''   when ansid=218429 then ''   when ansid=218430 then ''  when ansid=218431 then '' when ansid=218432 then ''  when ansid=218433 then ''   when ansid=218434 then ''  when ansid=218435 then '' when ansid=218436 then '' when ansid=218437 then '' when ansid=218438 then '' when ansid=218439 then '' when ansid=218440 then '' when ansid=218441 then '' when ansid=218442 then '' when ansid=218443 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.5',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-20 18:01:11'\n\t\t\t\t\t\t\tWHERE ansid in ('218338','218339','218340','218341','218342','218343','218344','218387','218389','218391','218393','218395','218397','218398','218399','218400','218401','218402','218403','218404','218405','218406','218407','218408','218409','218410','218411','218412','218413','218414','218415','218416','218417','218418','218419','218420','218421','218422','218423','218424','218425','218426','218427','218428','218429','218430','218431','218432','218433','218434','218435','218436','218437','218438','218439','218440','218441','218442','218443')"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE supvisstepid = '11666'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE visitfeedbackid = '11536'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE visitfeedbackid = '11537'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE visitfeedbackid = '11538'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE visitfeedbackid = '11539'"}
{"userId":"1","date":"2021-04-20 18:01:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:01:11' WHERE visitfeedbackid = '11540'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE sitesupervision SET `siteid` = '478', `userid` = '1', `ancservicedays` = '1', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2021-04-20', `numofsamplecollected` = '65', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26', `locationtype` = '2', `establishmentyear` = '2021', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2352'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE onssid = '9736'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE onssid = '9737'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE onssid = '9738'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE onssid = '9739'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218338 then '1' when ansid=218339 then '2' when ansid=218340 then '' when ansid=218341 then '' when ansid=218342 then ''  when ansid=218343 then ''   when ansid=218344 then ''  when ansid=218387 then '' when ansid=218389 then '' when ansid=218391 then '' when ansid=218393 then '' when ansid=218395 then '' when ansid=218397 then '' when ansid=218398 then '' when ansid=218399 then '' when ansid=218400 then ''  when ansid=218401 then ''   when ansid=218402 then ''  when ansid=218403 then ''  when ansid=218404 then ''   when ansid=218405 then ''   when ansid=218406 then ''   when ansid=218407 then ''  when ansid=218408 then '' when ansid=218409 then '' when ansid=218410 then ''  when ansid=218411 then ''   when ansid=218412 then ''   when ansid=218413 then ''   when ansid=218414 then ''  when ansid=218415 then ''  when ansid=218416 then ''   when ansid=218417 then ''  when ansid=218418 then '' when ansid=218419 then '' when ansid=218420 then '' when ansid=218421 then '' when ansid=218422 then '' when ansid=218423 then '' when ansid=218424 then '' when ansid=218425 then '' when ansid=218426 then ''  when ansid=218427 then ''   when ansid=218428 then ''   when ansid=218429 then ''   when ansid=218430 then ''  when ansid=218431 then '' when ansid=218432 then ''  when ansid=218433 then ''   when ansid=218434 then ''  when ansid=218435 then '' when ansid=218436 then '' when ansid=218437 then '' when ansid=218438 then '' when ansid=218439 then '' when ansid=218440 then '' when ansid=218441 then '' when ansid=218442 then '' when ansid=218443 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.5',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-20 18:08:26'\n\t\t\t\t\t\t\tWHERE ansid in ('218338','218339','218340','218341','218342','218343','218344','218387','218389','218391','218393','218395','218397','218398','218399','218400','218401','218402','218403','218404','218405','218406','218407','218408','218409','218410','218411','218412','218413','218414','218415','218416','218417','218418','218419','218420','218421','218422','218423','218424','218425','218426','218427','218428','218429','218430','218431','218432','218433','218434','218435','218436','218437','218438','218439','218440','218441','218442','218443')"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE supvisstepid = '11666'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE visitfeedbackid = '11536'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE visitfeedbackid = '11537'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE visitfeedbackid = '11538'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE visitfeedbackid = '11539'"}
{"userId":"1","date":"2021-04-20 18:08:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.5', `modifiedby` = '1', `modifieddate` = '2021-04-20 18:08:26' WHERE visitfeedbackid = '11540'"}