{"userId":"7","date":"2023-02-14 09:28:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-02-14 09:28:20')"}
{"userId":"258","date":"2023-02-14 11:12:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('258', '14.139.125.18', '2023-02-14 11:12:27')"}
{"userId":"258","date":"2023-02-14 11:25:32","query":"UPDATE usermst SET `password` = '80d72d3af77a581e606b680ba2302e2f', `modifiedby` = '258', `modifieddate` = '2023-02-14 11:25:32', `ipaddress` = '14.139.125.18' WHERE userid = '258'"}
{"userId":"258","date":"2023-02-14 11:26:19","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('602', '2023-02-13', '258', '14.139.125.18', '258', '2023-02-14 11:26:19')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('602', '3258', '258', '2023-02-14', '1', '14.139.125.18', '258', '2023-02-14 11:26:30', '', '')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2791', '0', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2791', '1', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2791', '2', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2791', '3', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2791', '4', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2791', '', '', 'Array', '', 'Array', '', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2791', '', '', 'Array', '', 'Array', '', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2791', '', '', 'Array', '', 'Array', '', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2791', '', '', 'Array', '', 'Array', '', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"258","date":"2023-02-14 11:26:30","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2791', '14.139.125.18', '258', '2023-02-14 11:26:30')"}
{"userId":"574","date":"2023-02-14 11:43:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.65', '2023-02-14 11:43:18')"}
{"userId":"574","date":"2023-02-14 11:44:17","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('186', '2023-02-14', '574', '110.235.232.65', '574', '2023-02-14 11:44:17')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('186', '3259', '574', '2023-02-14', '1', '110.235.232.65', '574', '2023-02-14 11:44:20', '', '')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2792', '0', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2792', '1', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2792', '2', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2792', '3', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2792', '4', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2792', '', '', 'Array', '', 'Array', '', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2792', '', '', 'Array', '', 'Array', '', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2792', '', '', 'Array', '', 'Array', '', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2792', '', '', 'Array', '', 'Array', '', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"574","date":"2023-02-14 11:44:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2792', '110.235.232.65', '574', '2023-02-14 11:44:20')"}
{"userId":"575","date":"2023-02-14 11:45:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.65', '2023-02-14 11:45:16')"}
{"userId":"574","date":"2023-02-14 11:47:15","query":"UPDATE sitesupervision SET `siteid` = '186', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '250', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2792'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Mala', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:30' WHERE onssid = '11496'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE onsitestaffs SET `staffname` = 'Babita', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:30' WHERE onssid = '11497'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dushyant', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:30' WHERE onssid = '11498'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:30' WHERE onssid = '11499'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=264295 then '' when ansid=264296 then '' when ansid=264297 then '' when ansid=264298 then '' when ansid=264299 then ''  when ansid=264300 then ''   when ansid=264301 then ''  when ansid=264401 then '' when ansid=264402 then '' when ansid=264344 then '' when ansid=264346 then '' when ansid=264348 then '' when ansid=264350 then '' when ansid=264352 then '' when ansid=264354 then '' when ansid=264355 then '' when ansid=264356 then '' when ansid=264357 then ''  when ansid=264358 then ''   when ansid=264359 then ''  when ansid=264360 then ''  when ansid=264361 then ''   when ansid=264362 then ''   when ansid=264363 then ''   when ansid=264364 then ''  when ansid=264365 then '' when ansid=264366 then '' when ansid=264367 then ''  when ansid=264368 then ''   when ansid=264369 then ''   when ansid=264370 then ''   when ansid=264371 then ''  when ansid=264372 then ''  when ansid=264373 then ''   when ansid=264374 then ''  when ansid=264375 then '' when ansid=264376 then '' when ansid=264377 then '' when ansid=264378 then '' when ansid=264379 then '' when ansid=264380 then '' when ansid=264381 then '' when ansid=264382 then '' when ansid=264383 then ''  when ansid=264384 then ''   when ansid=264385 then ''   when ansid=264386 then ''   when ansid=264387 then ''  when ansid=264388 then '' when ansid=264389 then ''  when ansid=264390 then ''   when ansid=264391 then ''  when ansid=264392 then '' when ansid=264393 then '' when ansid=264394 then '' when ansid=264395 then '' when ansid=264396 then '' when ansid=264397 then '' when ansid=264398 then '' when ansid=264399 then '' when ansid=264400 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.65',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-14 11:47:15'\r\n\t\t\t\t\t\t\tWHERE ansid in ('264295','264296','264297','264298','264299','264300','264301','264401','264402','264344','264346','264348','264350','264352','264354','264355','264356','264357','264358','264359','264360','264361','264362','264363','264364','264365','264366','264367','264368','264369','264370','264371','264372','264373','264374','264375','264376','264377','264378','264379','264380','264381','264382','264383','264384','264385','264386','264387','264388','264389','264390','264391','264392','264393','264394','264395','264396','264397','264398','264399','264400')"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE supvisstepid = '13768'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE visitfeedbackid = '13736'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE visitfeedbackid = '13737'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE visitfeedbackid = '13738'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE visitfeedbackid = '13739'"}
{"userId":"574","date":"2023-02-14 11:47:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:15' WHERE visitfeedbackid = '13740'"}
{"userId":"574","date":"2023-02-14 11:47:59","query":"UPDATE sitesupervision SET `siteid` = '186', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '250', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2792'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Mala', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:17' WHERE onssid = '11496'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE onsitestaffs SET `staffname` = 'Babita', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:17' WHERE onssid = '11497'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dushyant', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:17' WHERE onssid = '11498'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:17' WHERE onssid = '11499'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=264295 then '1' when ansid=264296 then '1' when ansid=264297 then '1' when ansid=264298 then '' when ansid=264299 then ''  when ansid=264300 then '691'   when ansid=264301 then '1'  when ansid=264401 then '1' when ansid=264402 then '1' when ansid=264344 then '' when ansid=264346 then '' when ansid=264348 then '' when ansid=264350 then '' when ansid=264352 then '' when ansid=264354 then '' when ansid=264355 then '' when ansid=264356 then '' when ansid=264357 then ''  when ansid=264358 then ''   when ansid=264359 then ''  when ansid=264360 then ''  when ansid=264361 then ''   when ansid=264362 then ''   when ansid=264363 then ''   when ansid=264364 then ''  when ansid=264365 then '' when ansid=264366 then '' when ansid=264367 then ''  when ansid=264368 then ''   when ansid=264369 then ''   when ansid=264370 then ''   when ansid=264371 then ''  when ansid=264372 then ''  when ansid=264373 then ''   when ansid=264374 then ''  when ansid=264375 then '' when ansid=264376 then '' when ansid=264377 then '' when ansid=264378 then '' when ansid=264379 then '' when ansid=264380 then '' when ansid=264381 then '' when ansid=264382 then '' when ansid=264383 then ''  when ansid=264384 then ''   when ansid=264385 then ''   when ansid=264386 then ''   when ansid=264387 then ''  when ansid=264388 then '' when ansid=264389 then ''  when ansid=264390 then ''   when ansid=264391 then ''  when ansid=264392 then '' when ansid=264393 then '' when ansid=264394 then '' when ansid=264395 then '' when ansid=264396 then '' when ansid=264397 then '' when ansid=264398 then '' when ansid=264399 then '' when ansid=264400 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.65',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-14 11:47:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('264295','264296','264297','264298','264299','264300','264301','264401','264402','264344','264346','264348','264350','264352','264354','264355','264356','264357','264358','264359','264360','264361','264362','264363','264364','264365','264366','264367','264368','264369','264370','264371','264372','264373','264374','264375','264376','264377','264378','264379','264380','264381','264382','264383','264384','264385','264386','264387','264388','264389','264390','264391','264392','264393','264394','264395','264396','264397','264398','264399','264400')"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE supvisstepid = '13769'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE visitfeedbackid = '13736'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE visitfeedbackid = '13737'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE visitfeedbackid = '13738'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE visitfeedbackid = '13739'"}
{"userId":"574","date":"2023-02-14 11:48:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:47:59' WHERE visitfeedbackid = '13740'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE sitesupervision SET `siteid` = '186', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '250', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2792'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Mala', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE onssid = '11496'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE onsitestaffs SET `staffname` = 'Babita', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE onssid = '11497'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE onsitestaffs SET `staffname` = 'Dushyant', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE onssid = '11498'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE onssid = '11499'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=264295 then '1' when ansid=264296 then '1' when ansid=264297 then '1' when ansid=264298 then '' when ansid=264299 then ''  when ansid=264300 then '691'   when ansid=264301 then '1'  when ansid=264401 then '1' when ansid=264402 then '1' when ansid=264344 then '1' when ansid=264346 then '1' when ansid=264348 then '0' when ansid=264350 then '3' when ansid=264352 then '1' when ansid=264354 then '' when ansid=264355 then '' when ansid=264356 then '' when ansid=264357 then ''  when ansid=264358 then ''   when ansid=264359 then ''  when ansid=264360 then ''  when ansid=264361 then ''   when ansid=264362 then ''   when ansid=264363 then ''   when ansid=264364 then ''  when ansid=264365 then '' when ansid=264366 then '' when ansid=264367 then ''  when ansid=264368 then ''   when ansid=264369 then ''   when ansid=264370 then ''   when ansid=264371 then ''  when ansid=264372 then ''  when ansid=264373 then ''   when ansid=264374 then ''  when ansid=264375 then '' when ansid=264376 then '' when ansid=264377 then '' when ansid=264378 then '' when ansid=264379 then '' when ansid=264380 then '' when ansid=264381 then '' when ansid=264382 then '' when ansid=264383 then ''  when ansid=264384 then ''   when ansid=264385 then ''   when ansid=264386 then ''   when ansid=264387 then ''  when ansid=264388 then '' when ansid=264389 then ''  when ansid=264390 then ''   when ansid=264391 then ''  when ansid=264392 then '' when ansid=264393 then '' when ansid=264394 then '' when ansid=264395 then '' when ansid=264396 then '' when ansid=264397 then '' when ansid=264398 then '' when ansid=264399 then '' when ansid=264400 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.65',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-14 11:48:37'\r\n\t\t\t\t\t\t\tWHERE ansid in ('264295','264296','264297','264298','264299','264300','264301','264401','264402','264344','264346','264348','264350','264352','264354','264355','264356','264357','264358','264359','264360','264361','264362','264363','264364','264365','264366','264367','264368','264369','264370','264371','264372','264373','264374','264375','264376','264377','264378','264379','264380','264381','264382','264383','264384','264385','264386','264387','264388','264389','264390','264391','264392','264393','264394','264395','264396','264397','264398','264399','264400')"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE supvisstepid = '13770'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE visitfeedbackid = '13736'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE visitfeedbackid = '13737'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE visitfeedbackid = '13738'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE visitfeedbackid = '13739'"}
{"userId":"574","date":"2023-02-14 11:48:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:48:37' WHERE visitfeedbackid = '13740'"}
{"userId":"574","date":"2023-02-14 11:55:36","query":"UPDATE sitesupervision SET `siteid` = '186', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '250', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2792'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Mala', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:40' WHERE onssid = '11496'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Babita', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:40' WHERE onssid = '11497'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dushyant', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:40' WHERE onssid = '11498'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:40' WHERE onssid = '11499'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=264295 then '1' when ansid=264296 then '1' when ansid=264297 then '1' when ansid=264298 then '' when ansid=264299 then ''  when ansid=264300 then '691'   when ansid=264301 then '1'  when ansid=264401 then '1' when ansid=264402 then '1' when ansid=264344 then '1' when ansid=264346 then '1' when ansid=264348 then '0' when ansid=264350 then '3' when ansid=264352 then '1' when ansid=264354 then '4' when ansid=264355 then '0' when ansid=264356 then '1840' when ansid=264357 then '150'  when ansid=264358 then ''   when ansid=264359 then '1'  when ansid=264360 then '1'  when ansid=264361 then ''   when ansid=264362 then '1'   when ansid=264363 then ''   when ansid=264364 then '1'  when ansid=264365 then '10' when ansid=264366 then '1' when ansid=264367 then '1'  when ansid=264368 then 'counsellor'   when ansid=264369 then '1'   when ansid=264370 then ''   when ansid=264371 then '1'  when ansid=264372 then '1'  when ansid=264373 then ''   when ansid=264374 then '1'  when ansid=264375 then '1' when ansid=264376 then '1' when ansid=264377 then '1' when ansid=264378 then '1' when ansid=264379 then '1' when ansid=264380 then '1' when ansid=264381 then '1' when ansid=264382 then '1' when ansid=264383 then '1'  when ansid=264384 then ''   when ansid=264385 then '3'   when ansid=264386 then 'thermocol box with ice packs'   when ansid=264387 then '2'  when ansid=264388 then '1' when ansid=264389 then '1'  when ansid=264390 then 'vacutainer needles are used so needle destroyer is not required'   when ansid=264391 then '2'  when ansid=264392 then '1' when ansid=264393 then '1' when ansid=264394 then '1' when ansid=264395 then '1' when ansid=264396 then '0' when ansid=264397 then 'none' when ansid=264398 then 'Dr. Sumathi visited the site at the start of HSS. No issues were identified as the site was working satisfactorily.' when ansid=264399 then 'The site is functioning satisfactorily. However, the quantity of serum samples stored is not 2 ml. counsellor was advised to see to it as the LT was not available on the day of visit.' when ansid=264400 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.65',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-14 11:55:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('264295','264296','264297','264298','264299','264300','264301','264401','264402','264344','264346','264348','264350','264352','264354','264355','264356','264357','264358','264359','264360','264361','264362','264363','264364','264365','264366','264367','264368','264369','264370','264371','264372','264373','264374','264375','264376','264377','264378','264379','264380','264381','264382','264383','264384','264385','264386','264387','264388','264389','264390','264391','264392','264393','264394','264395','264396','264397','264398','264399','264400')"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE supvisstepid = '13771'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE visitfeedbackid = '13736'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE visitfeedbackid = '13737'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE visitfeedbackid = '13738'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE visitfeedbackid = '13739'"}
{"userId":"574","date":"2023-02-14 11:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 11:55:36' WHERE visitfeedbackid = '13740'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE sitesupervision SET `siteid` = '186', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '250', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2792'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Mala', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE onssid = '11496'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE onsitestaffs SET `staffname` = 'Babita', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE onssid = '11497'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dushyant', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE onssid = '11498'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE onssid = '11499'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=264295 then '1' when ansid=264296 then '1' when ansid=264297 then '1' when ansid=264298 then '' when ansid=264299 then ''  when ansid=264300 then '691'   when ansid=264301 then '1'  when ansid=264401 then '1' when ansid=264402 then '1' when ansid=264344 then '1' when ansid=264346 then '1' when ansid=264348 then '0' when ansid=264350 then '3' when ansid=264352 then '1' when ansid=264354 then '4' when ansid=264355 then '0' when ansid=264356 then '1840' when ansid=264357 then '150'  when ansid=264358 then ''   when ansid=264359 then '1'  when ansid=264360 then '1'  when ansid=264361 then ''   when ansid=264362 then '1'   when ansid=264363 then ''   when ansid=264364 then '1'  when ansid=264365 then '10' when ansid=264366 then '1' when ansid=264367 then '1'  when ansid=264368 then 'counsellor'   when ansid=264369 then '1'   when ansid=264370 then ''   when ansid=264371 then '1'  when ansid=264372 then '1'  when ansid=264373 then ''   when ansid=264374 then '1'  when ansid=264375 then '1' when ansid=264376 then '1' when ansid=264377 then '1' when ansid=264378 then '1' when ansid=264379 then '1' when ansid=264380 then '1' when ansid=264381 then '1' when ansid=264382 then '1' when ansid=264383 then '1'  when ansid=264384 then ''   when ansid=264385 then '3'   when ansid=264386 then 'thermocol box with ice packs'   when ansid=264387 then '2'  when ansid=264388 then '1' when ansid=264389 then '1'  when ansid=264390 then 'vacutainer needles are used so needle destroyer is not required'   when ansid=264391 then '2'  when ansid=264392 then '1' when ansid=264393 then '1' when ansid=264394 then '1' when ansid=264395 then '1' when ansid=264396 then '0' when ansid=264397 then 'none' when ansid=264398 then 'Dr. Sumathi visited the site at the start of HSS. No issues were identified as the site was working satisfactorily.' when ansid=264399 then 'The site is functioning satisfactorily. However, the quantity of serum samples stored is not 2 ml. counsellor was advised to see to it as the LT was not available on the day of visit.' when ansid=264400 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.65',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-14 12:00:17'\r\n\t\t\t\t\t\t\tWHERE ansid in ('264295','264296','264297','264298','264299','264300','264301','264401','264402','264344','264346','264348','264350','264352','264354','264355','264356','264357','264358','264359','264360','264361','264362','264363','264364','264365','264366','264367','264368','264369','264370','264371','264372','264373','264374','264375','264376','264377','264378','264379','264380','264381','264382','264383','264384','264385','264386','264387','264388','264389','264390','264391','264392','264393','264394','264395','264396','264397','264398','264399','264400')"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE supvisstepid = '13772'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE visitfeedback SET `feedback` = 'serum sample quantity not adequate', `recommendation` = 'counsellor was advised to look into the quantity of serum sample as the LT was not available on the day of visit.', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE visitfeedbackid = '13736'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE visitfeedbackid = '13737'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE visitfeedbackid = '13738'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE visitfeedbackid = '13739'"}
{"userId":"574","date":"2023-02-14 12:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:00:17' WHERE visitfeedbackid = '13740'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '574', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2785'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE onssid = '11468'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE onssid = '11469'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE onssid = '11470'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE onssid = '11471'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE supvisstepid = '13735'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE visitfeedbackid = '13701'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE visitfeedbackid = '13702'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE visitfeedbackid = '13703'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE visitfeedbackid = '13704'"}
{"userId":"574","date":"2023-02-14 12:03:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.65', `modifiedby` = '574', `modifieddate` = '2023-02-14 12:03:01' WHERE visitfeedbackid = '13705'"}
{"userId":"680","date":"2023-02-14 12:03:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '110.235.232.65', '2023-02-14 12:03:23')"}
{"userId":"574","date":"2023-02-14 12:04:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.65', '2023-02-14 12:04:46')"}
{"userId":"574","date":"2023-02-14 12:09:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.65', '2023-02-14 12:09:18')"}
{"userId":"7","date":"2023-02-14 12:17:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-02-14 12:17:22')"}