{"userId":"521","date":"2023-02-07 09:55:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-07 09:55:07')"}
{"userId":"532","date":"2023-02-07 10:57:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('532', '223.185.102.40', '2023-02-07 10:57:36')"}
{"userId":"656","date":"2023-02-07 11:01:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '132.154.57.238', '2023-02-07 11:01:13')"}
{"userId":"521","date":"2023-02-07 11:15:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-07 11:15:17')"}
{"userId":"656","date":"2023-02-07 12:45:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:45:10')"}
{"userId":"433","date":"2023-02-07 12:47:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('433', '117.247.66.206', '2023-02-07 12:47:20')"}
{"userId":"656","date":"2023-02-07 12:48:10","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('301', '2023-02-06', '656', '49.36.219.190', '656', '2023-02-07 12:48:10')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('301', '3229', '656', '2023-02-07', '0', '49.36.219.190', '656', '2023-02-07 12:49:03', '', '')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2764', '0', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2764', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2764', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2764', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2764', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:49:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2764', '49.36.219.190', '656', '2023-02-07 12:49:03')"}
{"userId":"656","date":"2023-02-07 12:51:57","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('302', '2023-02-07', '656', '49.36.219.190', '656', '2023-02-07 12:51:57')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('302', '3230', '656', '2023-02-07', '0', '49.36.219.190', '656', '2023-02-07 12:52:04', '', '')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2765', '0', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2765', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2765', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2765', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2765', '', '', 'Array', '', 'Array', '', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:52:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2765', '49.36.219.190', '656', '2023-02-07 12:52:04')"}
{"userId":"656","date":"2023-02-07 12:53:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:53:01')"}
{"userId":"656","date":"2023-02-07 12:54:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:54:34')"}
{"userId":"656","date":"2023-02-07 12:55:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:55:04')"}
{"userId":"656","date":"2023-02-07 12:55:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:55:15')"}
{"userId":"656","date":"2023-02-07 12:56:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:56:23')"}
{"userId":"656","date":"2023-02-07 12:59:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 12:59:33')"}
{"userId":"656","date":"2023-02-07 13:02:55","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:02:55')"}
{"userId":"656","date":"2023-02-07 13:05:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:05:06')"}
{"userId":"656","date":"2023-02-07 13:06:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:06:45')"}
{"userId":"656","date":"2023-02-07 13:08:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:08:18')"}
{"userId":"656","date":"2023-02-07 13:08:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:08:53')"}
{"userId":"656","date":"2023-02-07 13:10:55","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:10:55')"}
{"userId":"656","date":"2023-02-07 13:12:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '49.36.219.190', '2023-02-07 13:12:36')"}
{"userId":"521","date":"2023-02-07 13:47:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-07 13:47:53')"}
{"userId":"656","date":"2023-02-07 14:03:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:03:46')"}
{"userId":"574","date":"2023-02-07 14:12:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-07 14:12:40')"}
{"userId":"656","date":"2023-02-07 14:14:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:14:53')"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '656', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2764'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE onssid = '11384'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE onssid = '11385'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE onssid = '11386'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE onssid = '11387'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE supvisstepid = '13630'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE visitfeedbackid = '13596'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE visitfeedbackid = '13597'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE visitfeedbackid = '13598'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE visitfeedbackid = '13599'"}
{"userId":"656","date":"2023-02-07 14:15:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '656', `modifieddate` = '2023-02-07 14:15:36' WHERE visitfeedbackid = '13600'"}
{"userId":"656","date":"2023-02-07 14:16:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:16:16')"}
{"userId":"656","date":"2023-02-07 14:18:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:18:02')"}
{"userId":"575","date":"2023-02-07 14:18:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-07 14:18:48')"}
{"userId":"2","date":"2023-02-07 14:23:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '110.235.232.63', '2023-02-07 14:23:25')"}
{"userId":"656","date":"2023-02-07 14:25:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:25:15')"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE sitesupervision SET `siteid` = '302', `userid` = '2', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2765'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE onssid = '11388'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE onssid = '11389'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE onssid = '11390'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE onssid = '11391'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE supvisstepid = '13631'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE visitfeedbackid = '13601'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE visitfeedbackid = '13602'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE visitfeedbackid = '13603'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE visitfeedbackid = '13604'"}
{"userId":"2","date":"2023-02-07 14:31:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '2', `modifieddate` = '2023-02-07 14:31:44' WHERE visitfeedbackid = '13605'"}
{"userId":"656","date":"2023-02-07 14:33:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:33:49')"}
{"userId":"656","date":"2023-02-07 14:34:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '110.235.232.63', '2023-02-07 14:34:25')"}
{"userId":"575","date":"2023-02-07 14:34:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-07 14:34:42')"}
{"userId":"656","date":"2023-02-07 14:35:20","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('302', '2023-02-06', '656', '110.235.232.63', '656', '2023-02-07 14:35:20')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('302', '3231', '656', '2023-02-07', '1', '110.235.232.63', '656', '2023-02-07 14:35:24', '', '')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2766', '0', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2766', '1', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2766', '2', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2766', '3', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2766', '4', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2766', '', '', 'Array', '', 'Array', '', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2766', '', '', 'Array', '', 'Array', '', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2766', '', '', 'Array', '', 'Array', '', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2766', '', '', 'Array', '', 'Array', '', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"656","date":"2023-02-07 14:35:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2766', '110.235.232.63', '656', '2023-02-07 14:35:24')"}
{"userId":"2","date":"2023-02-07 14:35:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '110.235.232.63', '2023-02-07 14:35:59')"}
{"userId":"543","date":"2023-02-07 14:42:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '14.139.206.130', '2023-02-07 14:42:36')"}
{"userId":"656","date":"2023-02-07 14:48:51","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '132.154.56.70', '2023-02-07 14:48:51')"}
{"userId":"656","date":"2023-02-07 14:50:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '132.154.56.70', '2023-02-07 14:50:30')"}
{"userId":"521","date":"2023-02-07 14:50:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-07 14:50:46')"}
{"userId":"656","date":"2023-02-07 14:55:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('656', '132.154.57.223', '2023-02-07 14:55:31')"}
{"userId":"575","date":"2023-02-07 14:59:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-07 14:59:37')"}
{"userId":"575","date":"2023-02-07 15:09:01","query":"UPDATE usermst SET `ipaddress` = '110.235.232.63', `modifiedby` = '575', `modifieddate` = '2023-02-07 15:09:01', `isdeleted` = '1' WHERE userid = '656'"}
{"userId":"575","date":"2023-02-07 15:10:25","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr S D', 'Kandpal', 'dr_sdk_hiht@yahoo.com', '9411311571', 'Professor and Head', 'RML Lucknow', '827ccb0eea8a706c4c34a16891f84e7b', '2', '110.235.232.63', '575', '2023-02-07 15:10:25')"}
{"userId":"575","date":"2023-02-07 15:10:25","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('681', '101', '38', '656', '', '4933', '110.235.232.63', '575', '2023-02-07 15:10:25')"}
{"userId":"681","date":"2023-02-07 15:15:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '132.154.58.141', '2023-02-07 15:15:21')"}
{"userId":"681","date":"2023-02-07 15:19:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '110.235.232.63', '2023-02-07 15:19:07')"}
{"userId":"575","date":"2023-02-07 15:32:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-07 15:32:05')"}
{"userId":"681","date":"2023-02-07 15:33:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '110.235.232.63', '2023-02-07 15:33:50')"}
{"userId":"681","date":"2023-02-07 15:38:23","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('303', '2023-02-08', '681', '110.235.232.63', '681', '2023-02-07 15:38:23')"}
{"userId":"681","date":"2023-02-07 15:38:56","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('304', '2023-02-09', '681', '110.235.232.63', '681', '2023-02-07 15:38:56')"}
{"userId":"433","date":"2023-02-07 16:19:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('433', '117.247.66.206', '2023-02-07 16:19:47')"}
{"userId":"433","date":"2023-02-07 16:24:23","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Arvind', 'Kumar', 'drarvindkumarsingh15@gmail.com', '9504683608', '', '', 'e10adc3949ba59abbe56e057f20f883e', '4', '117.247.66.206', '433', '2023-02-07 16:24:23')"}
{"userId":"433","date":"2023-02-07 16:24:23","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('682', '101', '5', '89', '3', '563', '117.247.66.206', '433', '2023-02-07 16:24:23')"}
{"userId":"433","date":"2023-02-07 16:34:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('433', '117.247.66.206', '2023-02-07 16:34:20')"}
{"userId":"681","date":"2023-02-07 17:13:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '132.154.57.85', '2023-02-07 17:13:20')"}
{"userId":"681","date":"2023-02-07 17:16:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '132.154.57.85', '2023-02-07 17:16:12')"}
{"userId":"1","date":"2023-02-07 17:30:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '103.119.246.139', '2023-02-07 17:30:28')"}
{"userId":"1","date":"2023-02-07 17:31:10","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1792', '2023-02-07', '1', '103.119.246.139', '1', '2023-02-07 17:31:10')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1792', '3234', '1', '2023-02-07', '1', '103.119.246.139', '1', '2023-02-07 17:31:13', '', '')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '0', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '1', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '2', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '3', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '4', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '5', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2767', '6', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2767', '', '', 'Array', '', 'Array', '', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2767', '', '', 'Array', '', 'Array', '', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2767', '', '', 'Array', '', 'Array', '', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2767', '', '', 'Array', '', 'Array', '', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('184', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('185', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('186', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('187', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('188', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('189', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('190', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('191', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('192', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('193', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('194', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('195', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('196', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('197', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('198', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('199', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('200', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('201', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('202', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('203', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('204', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('205', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('206', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('207', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('208', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('209', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('210', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('211', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('212', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('213', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('214', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('215', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('216', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('217', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('218', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('219', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('220', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('221', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('222', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('223', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('224', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('225', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('226', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('227', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('228', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('229', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('230', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('231', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('232', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('233', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('234', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('235', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('236', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('237', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('238', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('239', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('240', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('241', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('242', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('243', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('244', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('245', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('246', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('247', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('248', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('249', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('250', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('251', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('252', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('253', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('254', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('255', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('256', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('257', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('258', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('259', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('260', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('261', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('262', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('263', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('264', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('265', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('266', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('267', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('268', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('269', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('270', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('271', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('272', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('273', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('274', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('275', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('276', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('277', '2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2767', '103.119.246.139', '1', '2023-02-07 17:31:13')"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '' when ansid=261665 then '' when ansid=261666 then '' when ansid=261667 then '' when ansid=261668 then '' when ansid=261669 then '' when ansid=261670 then '' when ansid=261671 then '' when ansid=261672 then '' when ansid=261673 then '' when ansid=261674 then '' when ansid=261675 then '' when ansid=261676 then '' when ansid=261677 then '' when ansid=261678 then '' when ansid=261679 then '' when ansid=261680 then '' when ansid=261681 then '' when ansid=261682 then '' when ansid=261683 then '' when ansid=261684 then '' when ansid=261685 then '' when ansid=261686 then '' when ansid=261687 then '' when ansid=261688 then '' when ansid=261689 then '' when ansid=261690 then '' when ansid=261691 then '' when ansid=261692 then '' when ansid=261693 then '' when ansid=261694 then '' when ansid=261695 then '' when ansid=261696 then '' when ansid=261697 then '' when ansid=261698 then '' when ansid=261699 then '' when ansid=261700 then '' when ansid=261701 then '' when ansid=261702 then '' when ansid=261703 then '' when ansid=261704 then '' when ansid=261705 then '' when ansid=261706 then '' when ansid=261707 then '' when ansid=261708 then '' when ansid=261709 then '' when ansid=261710 then '' when ansid=261711 then '' when ansid=261712 then '' when ansid=261713 then '' when ansid=261714 then '' when ansid=261715 then '' when ansid=261716 then '' when ansid=261717 then '' when ansid=261718 then '' when ansid=261719 then '' when ansid=261720 then '' when ansid=261721 then '' when ansid=261722 then '' when ansid=261723 then '' when ansid=261724 then '' when ansid=261725 then '' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:31:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE supvisstepid = '13637'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:31:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:36' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '' when ansid=261667 then '' when ansid=261668 then '' when ansid=261669 then '' when ansid=261670 then '' when ansid=261671 then '' when ansid=261672 then '' when ansid=261673 then '' when ansid=261674 then '' when ansid=261675 then '' when ansid=261676 then '' when ansid=261677 then '' when ansid=261678 then '' when ansid=261679 then '' when ansid=261680 then '' when ansid=261681 then '' when ansid=261682 then '' when ansid=261683 then '' when ansid=261684 then '' when ansid=261685 then '' when ansid=261686 then '' when ansid=261687 then '' when ansid=261688 then '' when ansid=261689 then '' when ansid=261690 then '' when ansid=261691 then '' when ansid=261692 then '' when ansid=261693 then '' when ansid=261694 then '' when ansid=261695 then '' when ansid=261696 then '' when ansid=261697 then '' when ansid=261698 then '' when ansid=261699 then '' when ansid=261700 then '' when ansid=261701 then '' when ansid=261702 then '' when ansid=261703 then '' when ansid=261704 then '' when ansid=261705 then '' when ansid=261706 then '' when ansid=261707 then '' when ansid=261708 then '' when ansid=261709 then '' when ansid=261710 then '' when ansid=261711 then '' when ansid=261712 then '' when ansid=261713 then '' when ansid=261714 then '' when ansid=261715 then '' when ansid=261716 then '' when ansid=261717 then '' when ansid=261718 then '' when ansid=261719 then '' when ansid=261720 then '' when ansid=261721 then '' when ansid=261722 then '' when ansid=261723 then '' when ansid=261724 then '' when ansid=261725 then '' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:31:45'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE supvisstepid = '13638'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:31:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:31:45' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '' when ansid=261698 then '' when ansid=261699 then '' when ansid=261700 then '' when ansid=261701 then '' when ansid=261702 then '' when ansid=261703 then '' when ansid=261704 then '' when ansid=261705 then '' when ansid=261706 then '' when ansid=261707 then '' when ansid=261708 then '' when ansid=261709 then '' when ansid=261710 then '' when ansid=261711 then '' when ansid=261712 then '' when ansid=261713 then '' when ansid=261714 then '' when ansid=261715 then '' when ansid=261716 then '' when ansid=261717 then '' when ansid=261718 then '' when ansid=261719 then '' when ansid=261720 then '' when ansid=261721 then '' when ansid=261722 then '' when ansid=261723 then '' when ansid=261724 then '' when ansid=261725 then '' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:32:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE supvisstepid = '13639'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:32:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:11' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '' when ansid=261706 then '' when ansid=261707 then '' when ansid=261708 then '' when ansid=261709 then '' when ansid=261710 then '' when ansid=261711 then '' when ansid=261712 then '' when ansid=261713 then '' when ansid=261714 then '' when ansid=261715 then '' when ansid=261716 then '' when ansid=261717 then '' when ansid=261718 then '' when ansid=261719 then '' when ansid=261720 then '' when ansid=261721 then '' when ansid=261722 then '' when ansid=261723 then '' when ansid=261724 then '' when ansid=261725 then '' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:32:43'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE supvisstepid = '13640'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:32:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:43' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:32:56'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE supvisstepid = '13641'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:32:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:32:56' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:33:21'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE supvisstepid = '13641'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:33:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:21' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:33:56'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE supvisstepid = '13640'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE visitfeedbackid = '13611'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE visitfeedbackid = '13612'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE visitfeedbackid = '13613'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE visitfeedbackid = '13614'"}
{"userId":"1","date":"2023-02-07 17:33:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:33:56' WHERE visitfeedbackid = '13615'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:35:46', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:35:46' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:35:46' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:35:46' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:35:46' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:35:46","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid= then '' when ansid=261729 then '' when ansid= then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:35:46'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','','261729','','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:31', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:31' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:31' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:31' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:31' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:36:31","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then 'dsd' when ansid= then 'sds' when ansid= then '4' when ansid= then '4' when ansid= then '5' when ansid= then 'r' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid= then '' when ansid=261729 then '' when ansid= then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:36:31'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','','261729','','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:33', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:33' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:33' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:33' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:33' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:36:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then 'dsd' when ansid= then 'sds' when ansid= then '4' when ansid= then '4' when ansid= then '5' when ansid= then 'r' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid= then '' when ansid=261729 then '' when ansid= then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:36:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','','261729','','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:40', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:40' WHERE onssid = '11396'"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:40' WHERE onssid = '11397'"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:40' WHERE onssid = '11398'"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.139', `modifiedby` = '1', `modifieddate` = '2023-02-07 17:36:40' WHERE onssid = '11399'"}
{"userId":"1","date":"2023-02-07 17:36:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then 'dsd' when ansid= then 'sds' when ansid= then '4' when ansid= then '4' when ansid= then '5' when ansid= then 'r' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid=261728 then '' when ansid= then '' when ansid=261729 then '' when ansid= then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.139',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-07 17:36:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','261728','','261729','','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"}
{"userId":"647","date":"2023-02-07 20:58:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('647', '125.62.193.108', '2023-02-07 20:58:32')"}
{"userId":"647","date":"2023-02-07 21:02:34","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('746', '2023-02-06', '647', '125.62.193.108', '647', '2023-02-07 21:02:34')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('746', '3235', '647', '2023-02-07', '1', '125.62.193.108', '647', '2023-02-07 21:02:53', '', '')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2768', '0', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2768', '1', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2768', '2', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2768', '3', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2768', '4', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2768', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2768', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2768', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2768', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}
{"userId":"647","date":"2023-02-07 21:02:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2768', '125.62.193.108', '647', '2023-02-07 21:02:53')"}